We updated our NT server from MDAC 2.5 to MDAC 2.6 sp2 and all of a sudden we started getting errors about not being able to find any stored procedures when run from the web envirionment. When we run these stored procedures from the development environment, or Query Analyzer they run fine. But when run from a web page, we get and odbc error--cannot find 'stored procedure'.
When I create and adodb connection and run a cmdText query, it runs fine, but if I specify that the cmdText is a stored procedure I get the error.
any suggestions are greatly appreciated..
tsmith
When I create and adodb connection and run a cmdText query, it runs fine, but if I specify that the cmdText is a stored procedure I get the error.
any suggestions are greatly appreciated..
tsmith