80040e37 error through ADODB but query works in query analyzer
Posted on 2006-11-27
I've got a ADODB.Connection open which works for many queries
I've got a stored procedure that updates a view, the view is created in the stored procedure based on some of the stored procedure parameters.
Query works fine through query analyzer, but when run through asp/ADODB it gives this error:
Microsoft OLE DB Provider for ODBC Drivers error '80040e37'
[Microsoft][ODBC SQL Server Driver][SQL Server]contacts_2006_09
contacts_2006_09 is the name of the view.