var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Where to get JDBC driver for SQL Server 2000?
I have SQL server installed on a XP box. I need to access it from other machines using Java code. Where can I download a JDBC driver?
I'd suggest Microsoft's
JDBC Driver, but I'm a lazy bum that way!
I got the driver.
When I connect I got this error:
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Login failed for user 'name'. Reason: Not associated with a trusted SQL Server connectionn.
How to associate a user with a trusted SQL Server connectionn?
I am using SQL server 2000 developer Edition.
My guess would be that there is a problem with your login credentials (in your connect string). Check out KB #
313100 for more details.
Now I have it working.
In terms of availability, Microsoft's JDBC driver and FreeTDS are free and easily downloaded. FreeTDS is quite young and buggy, however, and I've heard of performance issues with Microsoft's offering. We tried itand found it not quite to the task.
For our apps, we use the i-net OPTA or MERLIA drivers, they're fast but a little pricey....
jTDS is another opensource JDBC type 4 driver. We're started using it several months ago and have been pleasantly surprised with the performance and results.