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
 ODBC >> OLE DB

Hello!

You problably get that message becouse your sql doesn't return any data at
all. Try
the following:
--------------
 set con = server.createobject("adodb.connection")
 set rs = server.createobject("ADODB.Recordset")
 con.open session("db")





response.write sql
-------------

Now take the SQL that is written in your browser window, copy it to the
query analyser and run the SQL string. Now you will see that the string
problably doesn't return any data. Why i don't know.

Marius


Quote:
> 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
 
 [ 2 post ] 

 Relevant Pages 

1. ODBC >> OLE DB

2. Delphi>>>>>>>

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

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