How To Connect Sql Server 2000 From Java

[subhendu123]

Hi,

How do I Connect Sql Server 2000 to Java

[r035198x]

Hi,

How do I Connect Sql Server 2000 to Java

Java connects to databases using JDBC. You just need an appropriate driver for the connecton to work.

[nurmaiza]

Java connects to databases using JDBC. You just need an appropriate driver for the connecton to work.

1. download the jar file from microsoft ; msutil.jar, mssqlsever.jar, msbase.jar
2. Setting the CLASSPATH: C:/..lib/msutil.jar,.../mssqlserver.jar;.../msbase.jar
3. Enable TCP/IP
4. the default port no usually 1433.
5. Stop Firewall

[ck9663]

1. download the jar file from microsoft ; msutil.jar, mssqlsever.jar, msbase.jar
2. Setting the CLASSPATH: C:/..lib/msutil.jar,.../mssqlserver.jar;.../msbase.jar
3. Enable TCP/IP
4. the default port no usually 1433.
5. Stop Firewall

So far, I have not seen any updates on how to access sql server using Windows Authentication. I don't think it can. There's a (used to be free) softwware that says they can: http://www.datadirect.com/products/jdbc/comparing_with_microsoft/index.ssp

[ck9663]

Hi,

How do I Connect Sql Server 2000 to Java

i found this:
http://jtds.sourceforge.net/index.html

[r035198x]

i found this:
http://jtds.sourceforge.net/index.html

And you can get the connection strings from
www.connectionstrings.com