Improve company productivity with a Business Account.Sign Up

x
?
Solved

Sun Database driver in JDK 1.2

Posted on 2000-03-30
2
Medium Priority
?
376 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 200 total points
ID: 2670996
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
ID: 2671037
Thanks your the Man.
0

Featured Post

Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

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

Media Temple is thrilled to announce the launch of our new Partner Program, specifically designed to empower digital agencies and adtech platforms by offering white-glove support and exclusive hosting enhancements to optimize their sites and their c…
Whether you have a site with just static html pages or a dynamic database-driven one, this step-by-step migration guide will help you get started with your new DV server. This guide is by no means comprehensive but it should cover the basics to get …
Viewers will learn about arithmetic and Boolean expressions in Java and the logical operators used to create Boolean expressions. We will cover the symbols used for arithmetic expressions and define each logical operator and how to use them in Boole…
Viewers will learn one way to get user input in Java. Introduce the Scanner object: Declare the variable that stores the user input: An example prompting the user for input: Methods you need to invoke in order to properly get  user input:

608 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