Sun jdbc odbc bridge error

[Martin Lira]

Hi,
I get this error when I try to close the Connection to my jdbc-odbc bridge for a SQL Server.

  
java.sql.SQLException: 
[Microsoft][ODBC SQL Server Driver]Invalid transaction state

Thanks,
Martin

[Julian Kennedy]

I've never seen before this but, just a thought, do you begin a transaction and then close the connection without either a commit or rollback?

Jules

[Stefan Wagner]

Why do you use the jdbc-odbc-bridge, instead of a jdbc-driver?

[Martin Lira]

Whats wrong in using a JDBC-ODBC brige?

[Julian Kennedy]

Martin,

This is what Sun has to say about their bridge driver.

Jules

[Martin Lira]

Got it guys, i have switched to a MS Sql server type 4 JDBC driver.

Thanks,
ML