Win a copy of Functional Reactive Programming this week in the Other Languages forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Connection with SQL Server

 
Anirban Das
Ranch Hand
Posts: 63
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Pie
Posts: 65229
95
IntelliJ IDE Java jQuery Mac Mac OS X
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
Joe Ess
Bartender
Posts: 9320
10
Linux Mac OS X Windows
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
Anurag Gupta
Ranch Hand
Posts: 40
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic