Please don't use JDBC-ODBC bridge. The problem is that this JDBC driver is only for testing / evaluation purposes and should not be used for development and/or production.
Can you give me an idea where i can find a good driver(free if it can) on the internet.I downloaded from microsoft a new driver.Is this good?Thanks in advance...
you can find the driver at:
it looks like this driver is from merant BUT if you plan to use the sqlServer2000 bigint data type the driver has some bugs:
java.sql.SQLException: [Microsoft][SQLServer JDBC Driver]
Unhandled data type: TDS_INT8
statement form Sarah Parra Microsoft Developer Support:
Right now the only workaround is to allow the column to be Nullable
(from the microsoft newsgroup: microsoft.public.sqlserver.jdbcdriver)
> Please don't use JDBC-ODBC bridge. The problem is
> that this JDBC driver is only for testing /
> evaluation purposes and should not be used for
> development and/or production.
Why? Is this because it doesn´t work properly in all situations, or is it because of licencing issues?
Just like to know - Katarzyna
No, the JDBC-ODBC bridge is not thread-safe and will create problems when load increases. Also the guys from Sun did indent to write a good JDBC driver but just an example which works on Windows to show JDBC in action.
Somewhere on Javasoft side you will find a note explaining it a little bit more in details.
Motto: Whenever you are going to create a bigger or a reliable project don't use it.