• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 377
  • Last Modified:

Sun Database driver in JDK 1.2

I'm trying to use Sun driver to connect to the Microsoft SQL Server 6.5 so my JavaServlet can display table info.
Which of the Jar files contain the actual Database drivers. I tried everything. I know I have to use a type4 driver to connect to MSQL 6.5, therefore my classpath should point to the Database driver in one of the Jar files in JDK 1.2? But which one. Has anyone tried to run a JavaServlet that connects to a MSQL Server 6.5 and was successful. Help.....Thanks.
0
7of9121098
Asked:
7of9121098
1 Solution
 
diakovCommented:
There is no thin JDBC driver in the package. You can use the JDBCODBC driver in the package that is not thin. You have to make a data source on the local machine that points to the sql server database and use the datasorce from Java.
About the thin drivers:

Microsoft don't supply one. You can get 3rd party ones from a variety of vendors and some free open-source ones as well. It is difficult to recommend one, but WebLogic users seem to be generally happy. The full list that I know of are :-

1. WebLogic : http://weblogic.beasys.com and www.weblogic.com. (type 2, 3 or 4. SQL 6.5 and 7.0)

2. http:\\www.inetsoftware.de. JDBC Type 4 drivers for the Microsoft SQLServer 6.5 and 7.0. JDBC 1.22 driver to use with JDK 1.1x and a JDBC 2.0 driver (i-net Sprinta) to use with Java 2 (JKD 1.2x).

JDBC 1.22 : http://www.inetsoftware.de/English/produkte/jdbctreiber/Default.htm
JDBC 2.0 : http://www.inetsoftware.de/English/produkte/jdbc2/Default.htm.

3. www.openlinksw.com (www.openlinksw.co.uk)

4. http://beta.easysoft.com. JDBC/ODBC bridge (www.easysoft.com)

5. ftp://freetds.internetcds.com/pub/freetds_jdbc. Type 4 open-source driver that is designed to work with SQLServer and Sybase

6. http://java.sun.com/products/jdbc

7. http://lpv.home.texas.net (LpVodbc)

8. http://ourworld.compuserve.com/homepages/Ken_North/jdbcvend.htm


Cheers,
  Nik
0
 
7of9121098Author Commented:
Thanks your the Man.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now