ODBC >> OLE DB 
Author Message
 ODBC >> OLE DB

Hi!

When I changed my database connection from ODBC to OLE DB, one of my stored
procedure on the MS SQL 7.0 stoped working. I get this error message:

ADODB.Recordset error '800a0e78'

The operation requested by the application is not allowed if the object is
closed.

search_result.asp, line 52

However search_result.asp workes fine when i use the ODBC connection.
The .asp calles a stored procedure which takes 10 input parameters.
The stored procedure looks at the input parameters and produce an sql
statement, depending on the data retrieved, and returns
the record found by the sql statement.

I get this error message on a simple if statement ( if not rs.eof then). Can
anyone help me?

set con = server.createobject("adodb.connection")
set rs = server.createobject("ADODB.Recordset")
con.open session("db")




set rs = con.execute(sql)
if not rs.eof then ' <== Gives me the error message
    response.write("Not eof!!")
end if

All the other stored procedures i have work fine with the OLE DB.... thats
why i cant figure out why this one wont.



Fri, 04 Apr 2003 03:00:00 GMT
 
 [ 1 post ] 

 Relevant Pages 

1. ODBC >> OLE DB

2. >>>SYBASE/UNIX ENIGNEERS WANTED>>>>Bay Area, CA.

3. Delphi>>>>>>>

4. Applet =>Asp =>DB =>Asp =>Applet

5. Check out the Web below for great Computer Prices >>>>>>>>>>>>

6. >>>>>>UNIX/SYBASE ENGINEERS WANTED>>>>>> Bay Area, CA

7. Check out the Web below for great Computer Prices >>>>>>>>>>>>

8. ------>>>>>>CASH IN ON THE NET

9. >>>>> ORACLE DBA 24/7/365 SUPPORT >>>>>

10. US-NY: ORACLE DBA >>>>>URGENT

11. US-NY: ORACLE DBA >>>>>URGENT

12. US-NY: ORACLE DBA >>>>>URGENT


 
Powered by phpBB® Forum Software