Solved

Sun Database driver in JDK 1.2

Posted on 2000-03-30
2
360 Views
Last Modified: 2013-11-21
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
Comment
Question by:7of9121098
2 Comments
 
LVL 8

Accepted Solution

by:
diakov earned 50 total points
Comment Utility
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
 

Author Comment

by:7of9121098
Comment Utility
Thanks your the Man.
0

Featured Post

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Join & Write a Comment

Suggested Solutions

If you don't have the right permissions set for your WordPress location in IIS, you won't be able to perform automatic updates. Here's how to fix the problem.
When it comes to showing a 404 error page to your visitors, you do not want that generic page to show, and you especially do not want your hosting provider’s ad error page to show either. In this article, I will show you how to enable the custom 40…
Video by: Michael
Viewers learn about how to reduce the potential repetitiveness of coding in main by developing methods to perform specific tasks for their program. Additionally, objects are introduced for the purpose of learning how to call methods in Java. Define …
Viewers will learn about if statements in Java and their use The if statement: The condition required to create an if statement: Variations of if statements: An example using if statements:

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now