Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
amitkumarmadhukar
Starting Member
45 Posts |
 Posted - 2004-07-23 : 04:32:25
|
| I have SQL Server 7.0 /Sql server 2000 with SP1,and SP2i developer of Java and Want to Connect Java with SQL Server.Please give me the driver (JDBC Driver) and example Code of Database Conection with any example Database of Sql Serverplease also give the classpath declaration style if any (Like in ORACLE)i am very thankful to u. amit kumar madhukar |
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2004-07-26 : 18:10:09
|
| btw, the JDBC driver from microsoft is not certified to run with SQL 7.The connection strings you are looking for are in the help file that gets installed when you run setup.Installing in unix apparently does not require a client. (answered my own question)-ec |
 |
|
|
webmad
Starting Member
1 Post |
Posted - 2004-08-12 : 12:57:47
|
| Unfortunately, JDBC driver DOES NOT work with SQL Server...Trying to connect to a SQL 7 server gives the following Exception:"java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]This version of the JDBC driver only supports Microsoft SQL Server 2000. You can either upgrade to SQL Server 2000 or possibly locate another version of the driver."I installed JDBC driver on my Linux machine and it works fine ;)Bye,-Pietro. |
|
|
|
Andraax
Aged Yak Warrior
790 Posts |
Posted - 2004-08-13 : 03:12:44
|
| There are alternatives to the Microsoft driver which is, I'm sad to say, not the best one around :(Here is a good one which is also open source:http://jtds.sourceforge.net/It's fast, it supports BLOB's (which Microsofts driver doesn't), and it supports SQL Server 7.0/2000/2005./Andraax |
|
|
|
|
|
|
|
|
Java-Sql Server Connection