Free JDBC-ODBC Bridge drivers

The JDBC-ODBC bridge driver from Sun is included with the Java 2 SDK Standard Edition as package sun.jdbc.odbc.

Or you could use Microsofts own JDBC driver for SqlServer

Download: http://www.microsoft.com/downloads/details.aspx?FamilyID=86212D54-8488-481D-B46B-AF29BB18E1E5&displaylang=en

Here's the how-to: http://support.microsoft.com/default.aspx?scid=kb;en-us;313100

>>The JDBC-ODBC bridge driver from Sun is included with the Java 2 SDK Standard Edition as package sun.jdbc.odbc.

How do you connect to this driver?

>.How do you connect to this driver?

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

Just like above!!

And here are some links to help you.

http://www.javaworld.com/javaworld/javaqa/2000-09/03-qa-0922-access.html
http://www.javacoffeebreak.com/articles/jdbc/

http://www.roseindia.net/jdbc/introduction.shtml
http://www.easysoft.com/products/2003/forte_adddriver.phtml
http://www.awprofessional.com/articles/article.asp?p=167843
http://java.sun.com/products/jdbc/jdbc.drivers.html
http://www.ingrid.org/jajakarta/turbine/en/turbine/torque/mssql-howto.html

>>Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

How do I connect to the driver using NetBeans GUI?

http://www.idssoftware.com/download.html#ODBC

I'm still having problems.

When I try to make a connection, I get a "Unable to add connection prompt"
See following screen shot:
http://axter.com/tmp/jdbcproblem.jpg

I downloaded the driver from the MS site to see if that help any, but I still can't make a connection.

zloy_ochen,
The link you posted is for a trial version.  I'm not looking for a trial version.
I'm looking for a free driver that will work with MSSQL server.

I've already downloaded the driver from MS, and I haven't been able to get that one to work.

What about the port number and database name? And is that doesn't help, change the url to an IP number.

Well that was a really stupid mistake!!!

I was too busy looking at it as a Java problem instead of seeing it as a really simple ODBC problem.


Thanks

8-)

Your best solution for Microsoft SQL Server is to not use ODBC at all.  There is an EXCELLENT free, open source Type 4 (no native code!) JDBC driver called JTDS.  Google for JTDS (it is a SourceForge project) and you'll be absolutely impressed with the performance and reliability.

>>There is an EXCELLENT free, open source Type 4 (no native code!) JDBC driver called JTDS.  Google for JTDS (it is a SourceForge project)
>>and you'll be absolutely impressed with the performance and reliability.

How much of a performance difference are we talking about?

Substantial performance benefits (it uses a wire level protocol), plus you need zero MSSQL stuff on the box.  No network client DLL's, etc..  Almost no way to crash your server using it, whereas with the JDBC/ODBC bridge, crashing is a common occurrence.  The only reason you wouldn't use it is if, for some reason, the SQL administrator wouldn't allow MSSQL to listen on TCP/IP and required named pipes only.  Otherwise, use the pure Java, Type 4 JDBC driver, always!

>>Substantial performance benefits (it uses a wire level protocol), plus you need zero MSSQL stuff on the box.

Are we talking about 5%, 10%, 20%, 50%, 100%, 1000% ????

I'm just looking for a ball park figure.
And have you tested this, or are you getting the stats from somewhere else, and if so, can you give me the links.