if I install j2se on my computer, must i install jdbc driver on my computer separately?
or if i have sql server 2000, has it jdbc ? and no need to install?
2006-07-23 20:26:31 · 2 answers · asked by far 1 in Computers & Internet ➔ Other - Computers
Without relying on any MS SQL Server installation at all, you can set up an ODBC data source (In Window XP, go to Start → Settings → Control Panel → Adminstrative Tools → Data Sources(ODBC)), and then use the JDBC:OCBC bridge (see Java tutorial for JDBC), but that is not very efficient.
Instead I would recommend using the JDBC Jar files for MS SQL Server 2000. You can download and install them from here:
http://www.microsoft.com/downloads/details.aspx?familyid=86212D54-8488-481D-B46B-AF29BB18E1E5&displaylang=en
This is a free download.
When you install this, it creates a new folder:
C:\Program Files\Microsoft SQL Server 2000 Driver for JDBC\lib
This folder contains 3 jar files. Copy all three to your java project directory and/or add them to your classpath. The reference guide is in Adobe acrobat format, and located here:
C:\Program Files\Microsoft SQL Server 2000 Driver for JDBC\books\Msjdbcref\msjdbcref.pdf
2006-07-24 09:29:35 · answer #1 · answered by BalRog 5 · 1⤊ 0⤋
you need to import the sql 2000 driver into your progrms, there shouldn't be an installer for jdbc or the sql driver. Just a jar that you import
2006-07-24 03:30:03 · answer #2 · answered by Brady 3 · 0⤊ 1⤋