List:MySQL ODBC« Previous MessageNext Message »
From:rafarife Date:July 7 2003 6:04pm
Subject:Error in Updating a cursor opened from a not active database
View as plain text  
Hello Venu,

I am using MySQL 4.0.13 and MyODBC 3.51.06.

Did you remember then problem when you opened
a cursor from a database that was not the active
database in the connection and you wanted to update 
the cursor?

It produced the following error:

 [MySQL][ODBC 3.51 Driver][mysqld-4.0.13-max-nt-log] Table 'BD1.Table'
 does not exist.

BD1 was the active database in the connection but the cursor was opened
from BD2 database: cursor.open "Select * from BD2.Table"

How about it?

Thanks,
Rafa.





__________________________________________________________________
McAfee VirusScan Online from the Netscape Network.
Comprehensive protection for your entire computer. Get your free trial today!
http://channels.netscape.com/ns/computing/mcafee/index.jsp?promo=393397

Get AOL Instant Messenger 5.1 free of charge.  Download Now!
http://aim.aol.com/aimnew/Aim/register.adp?promo=380455
Thread
Error in Updating a cursor opened from a not active databaserafarife7 Jul