怎么连接sql server，不用jdbc:odbc桥

xingxing 2002-12-13 05:14:06

...全文

47 5 打赏收藏转发到动态举报

写回复

用AI写文章

5 条回复

切换为时间正序

请发表友善的回复…

发表回复

longzhijian 2002-12-13

打赏
举报

如果用JRUN可以用自带的JDBC比较方便

merlin45 2002-12-13

打赏
举报

http://msdn.microsoft.com/MSDN-FILES/027/001/779/JDBCRTMReleaseMa
nifest.htm

1. Download theMicrosoft SQL Server 2000 Driver for JDBC (setup.exe file) from
the Microsoft MSDN Web site at
http://msdn.microsoft.com/downloads/default.asp?URL=/downloads/
sample.asp?url=/MSDN-FILES/027/001/779/msdncompositedoc.xml.
Save the file in a temporary directory on your local computer.
2. Run setup.exe from the temporary directory and follow the instructions on the
screen.
3. Add the path to the following files to your CLASSPATH:
" install_dir/lib/msbase.jar
" install_dir/lib/msutil.jar
" install_dir/lib/mssqlserver.jar
Where install_dir is the folder in which you installed the driver. For
example:
set CLASSPATH=install_dir\lib\msbase.jar;
install_dir\lib\msutil.jar;install_dir\lib\mssqlserver.jar;
%CLASSPATH%

DriverName="com.microsoft.jdbc.sqlserver.SQLServerDriver"
URL="jdbc:microsoft:sqlserver://lcdbnt4:1433"

conning333 2002-12-13

打赏
举报

使用jdbc来进行连接就可以了

masterz 2002-12-13

打赏
举报

Microsoft SQL Server 2000 Driver for JDBC
(http://www.microsoft.com/downloads/release.asp?releaseid=38312)

masterz 2002-12-13

打赏
举报

Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
Connection conn = DriverManager.getConnection("jdbc:microsoft:sqlserver://192.168.0.9:1433;user=sa;password=sa;DatabaseName=testDb");