-
1. Re: jdbc odbc driver
schaefera Nov 28, 2001 3:37 PM (in response to serifu)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.
Andy -
2. Re: jdbc odbc driver
serifu Nov 29, 2001 2:31 AM (in response to serifu)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...
-
3. Re: jdbc odbc driver
jochen.schurich Nov 29, 2001 6:11 AM (in response to serifu)you can find the driver at:
http://www.microsoft.com/sql/downloads/2000/jdbc.asp
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)
joe -
4. Re: jdbc odbc driver
jochen.schurich Nov 29, 2001 6:14 AM (in response to serifu)you can take a look at this free driver:
http://www.thinweb.com/tw_products_twfreetds.html -
5. Re: jdbc odbc driver
katarzyna.hedlund Dec 5, 2001 4:30 AM (in response to serifu)> 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.
>
> Andy
Why? Is this because it doesn´t work properly in all situations, or is it because of licencing issues?
Just like to know - Katarzyna -
6. Re: jdbc odbc driver
schaefera Dec 5, 2001 9:24 PM (in response to serifu)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.