does somebody know were to get a cheap jdbc driver for the SQL server
because MS doesnt provide any? The driver should at least run with NT
Q. Where can I get a JDBC driver for SQL Server? Do Microsoft write one?Quote:> does somebody know were to get a cheap jdbc driver for the SQL server
> because MS doesnt provide any? The driver should at least run with NT
A. Microsoft don't supply one. You can get 3rd party ones from a variety of
vendors and some free open-source ones as well.
Which is the best one? As I don't use any of them I can't comment from
personal experience. The two most commonly used seem to be WebLogic and
OpenLink - and feedback on them seems good.
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). Download type-4 driver direct from
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://www.easysoft.com / http://beta.easysoft.com. JDBC/ODBC bridge.
5. ftp://freetds.internetcds.com/pub/freetds_jdbc. Type 4 open-source driver
that is designed to work with SQLServer and Sybase
7. http://lpv.home.texas.net (LpVodbc)
Applies to SQL Server versions : All
FAQ Categories : Connectivity
Related FAQ articles : odbcunix
Related Microsoft Kb articles : n/a
Other related information : n/a
Authors : Neil Pike
Neil Pike MVP/MCSE. Protech Computing Ltd
(Please reply only to newsgroups)
SQL FAQ (428 entries) see
forumsb.compuserve.com/gvforums/UK/default.asp?SRV=MSDevApps (sqlfaq.zip - L7
- SQL Public)
I'm trying to CREATE, DROP, ALTER tables from within my Java app
I'm using the Intersolv JDBCTest Tool Version 1.04, the jdbc Connection
is through OpenLink
This is what I'm getting.
CREATE TABLE test (col1 CHARACTER(30)).
DROP TABLE test
Message: [OpenLink][ODBC][Progress Server]** The _Index record has
NO-LOCK status. DELETE not allowed. (335)
ALTER TABLE test ALTER COLUMN col1 FORMAT "CHARACTER(50)".
Message: [OpenLink][ODBC][Progress Server]** _Field record has NO-LOCK
status, update to field not allowed. (396)
Obviously there is a problem with a LOCK status
The solution however is not obvious to me (allthough probably simple,
but I admit I'm a bit dense at times :) )
All help greatly appreciated.