can't find stored procedure 1

[gusset]

i am executing a stored procedure with this code:

Set com = New ADODB.Command
With com
.ActiveConnection = cnn
.CommandType = adCmdStoredProc
.CommandText = "ex_TimeEntries"
End With
Set rst = New ADODB.Recordset
Set rst = com.Execute

and i get the message "could not find stored procedure "ex_TimeEntries". i don't understand this, as i created the sp myself and it runs fine from the sql code editor. perhaps it is a permissions point.

does anyone have any ideas, please?

thanks

gusset

 

[JayKusch]

Try specifying a database name too as in ...

MyDB.dbo.ex_TimeEntries

Thanks

J. Kusch

 

[gusset]

amazing! that worked. thanks

i've never come across that before. the db name was coded into the connection string, so i didn't think i'd need that.

i tried this "dbo.ex_TimeEntries" but the program didn't like that. when i did "Mydb.dbo.ex_TimeEntries", it went without a hitch.

i guess it must be a permissions point. i never had that problem when i was using databases of my own creation on my own server.

gusset