wood burning stoves*
The moose likes JDBC and the fly likes Connection with SQL Server Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Connection with SQL Server " Watch "Connection with SQL Server " New topic
Author

Connection with SQL Server

Anirban Das
Ranch Hand

Joined: Nov 22, 2003
Posts: 63
I have installed Microsoft Sql Server 7.0 database.I want to know whether any Type 4 (Pure Java Driver ) comes with it. It will be nice if you kindly tell me what will be the JDBC URL for the Type 4 driver.
Bear Bibeault
Author and ninkuma
Marshal

Joined: Jan 10, 2002
Posts: 60780
    
  65

Welcome to the Ranch Bamby!
You'll find this forum a great place to seek help on JDBC, and there aren't many rules you'll have to worry about, but one is that proper names are required. Please take a look at the JavaRanch Naming Policy and change your display name to match it.
In particular, your display name must be a first and a last name separated by a space character, and must not be obviously fictitious.
Thanks!
bear
JDBC Forum Bartender


[Asking smart questions] [Bear's FrontMan] [About Bear] [Books by Bear]
Joe Ess
Bartender

Joined: Oct 29, 2001
Posts: 8836
    
    7

Originally posted by Bamby:
I have installed Microsoft Sql Server 7.0 database.I want to know whether any Type 4 (Pure Java Driver ) comes with it.

Microsoft making life easier on users rather than making life difficult for competitors (Sun and Microsoft have quite a history, if you don't know)? That will be the day. The Java SDK comes with a JDBC-ODBC bridge (class name sun.jdbc.odbc.JdbcOdbcDriver), but it is for "prototyping", not for use in production environments (per the documentation)
You can search among the various available JDBC drivers here:
JDBC Drivers


"blabbing like a narcissistic fool with a superiority complex" ~ N.A.
[How To Ask Questions On JavaRanch]
Anurag Gupta
Ranch Hand

Joined: Dec 13, 2001
Posts: 40
For SQL Server, One good JDBC Driver is available from Merant - now Known as Data-Direct --> http://www.datadirect-technologies.com
You could use either:
1) Merant SequeLink Server 5.X for jdbc - Type 3 Driver.
2) Connect for JDBC - Type 4 Driver.
That should solve your issues... atleast till the evaluation period of the driver expires.


Anurag Gupta
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: Connection with SQL Server
 
Similar Threads
Type-4 Driver for Ms Sql Server 2000
Merant ConnectJDBC Driver (Type 4) for MS SQL Server
SQLServer thindriver for Tomcat5.0
[Microsoft Driver] error
Sun jdbc odbc bridge error