Java Database Connectivity (JDBC)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Invalid cursor state

843854Jan 28 2002 — edited Jan 29 2002

Hi all,

I`m currently writing a program to connect to a Microsoft SQL Server 7.0 database and retrieve some data.

The bloke that looks after the databases told me I have to use an ODBC-JDBC bridge as its not possible to connect straight through to Microsoft SQL Server 7.0 using JDBC.

So I`ve used this ODBC-JDBC bridge and have executed a query statement, but I get an error at run-time: -

java.sql.SQLException: [Microsoft][ODBC Driver Manager] Invalid cursor state

Why do I get this error? After 2 hours staring at this screen I`m running out of ideas.

I`d be very grateful for any help.

Cheers,
Tom

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 26 2002

Added on Jan 28 2002

#java-database-connectivity-jdbc

3 comments

154 views