|
texanman
Junior Member
United States
410 Posts |
 Posted - 14 August 2009 : 13:22:06
|
Hello!
I have just migrated to a new host. The old and the new hosts have SQL server 2008. Everything works fine except the user space mod. I get an error message:
Microsoft OLE DB Provider for SQL Server error '80040e14'
Could not find stored procedure 'my_spDisplay'.
/forum/my.asp, line 108
and lines 106-108 are:
set objRS = server.createobject("adodb.recordset")
'Call the stored procedure to increment a counter on the page
objRS.Open "exec my_spDisplay " & intID & "", my_Conn
One thing I noticed, with my old host the stored procedures folder was under the DB and with new host it is under a folder called "programmability", which is under the DB.
Any help?
|
Edited by - texanman on 14 August 2009 17:59:47 |
|
Topic Locked
.