Connection with SQL Server
Anirban Das
Ranch Hand
Posts: 63
posted 13 years ago
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
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
posted 13 years ago
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
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
posted 13 years ago
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.
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
|