Changed all objects from dbo to non dbo, now cannot send parameters

  • Thread starter Thread starter diznuts
  • Start date Start date
D

diznuts

due to some tables not being owned by dbo, i needed to change all other
objects to the same owner. I have since updated the db to do this as
well as the ADP. However, when i run the adp, it fails. For some
reason it fails when either refreshing the stored procedure parameters,
or setting a value to a parameter. Usingthe same login in query
analyzer (or the queries tab in access) i am able to view the correct
results.

Any suggestions?

Dim cmdGetSwitchBoardItems As New ADODB.Command
Dim rst As New ADODB.Recordset

' Set CommandText equal to the stored procedure name.
cmdGetSwitchBoardItems.CommandText = "eID_Admin.spSwitchBoard"
cmdGetSwitchBoardItems.CommandType = adCmdStoredProc

cmdGetSwitchBoardItems.ActiveConnection = CurrentProject.Connection

On Error GoTo errMenu

' Automatically fill in parameter info from stored procedure.
'FAILS HERE
cmdGetSwitchBoardItems.Parameters.Refresh

' Set the param value.
'FAILS HERE
cmdGetSwitchBoardItems.Parameters("@SBValue") = Me.SwitchboardID

' Execute the storedprocedure
Set rst = cmdGetSwitchBoardItems.Execute
 
To make life simpler, change the ownership so that everything is owned
by dbo, not the other way around. Otherwise, you will have to fully
qualify all object references and/or will run into broken ownership
chain problems. See Using Ownership Chains in SQLS BOL.

--Mary
 
Back
Top