SQL Server 2005 Driver for JDBC
来源:互联网 发布:淘宝联盟推广位怎么写 编辑:程序博客网 时间:2024/05/02 02:35
- Load the SQL Server 2005 Driver for JDBC before you load the SQL Server 2000 Driver for JDBC. To do this, use the DriverManager class as in the following code example.
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver"); // 2005 versionClass.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver"); // 2000 version
- Use a SQL Server 2005 Driver for JDBC connection URL to establish a connection. To do this, use code that resembles the following code example.
Connection con = DriverManager.getConnection("jdbc:sqlserver://<ServerName>;user=<UserName>;password=<Password>");
For more information about how to connect with data sources and how to use a connection URL, visit the following Microsoft Developer Network (MSDN) Web sites:
Building the connection URL
http://msdn2.microsoft.com/en-us/library/ms378428.aspx (http://msdn2.microsoft.com/en-us/library/ms378428.aspx)
Setting the connection properties
http://msdn2.microsoft.com/en-us/library/ms378988.aspx (http://msdn2.microsoft.com/en-us/library/ms378988.aspx)
http://msdn2.microsoft.com/en-us/library/ms378428.aspx (http://msdn2.microsoft.com/en-us/library/ms378428.aspx)
Setting the connection properties
http://msdn2.microsoft.com/en-us/library/ms378988.aspx (http://msdn2.microsoft.com/en-us/library/ms378988.aspx)
The SQL Server 2000 JDBC driver accepts connection URLs from the SQL Server 2005 JDBC Driver. The SQL Server 2005 JDBC Driver connection string URLs start with the following string:
jdbc:sqlserver://ConnectionString
The SQL Server 2000 Driver for JDBC should only accept connection string URLs that start with the following string:jdbc:microsoft:sqlserver://ConnectionString
However, the SQL Server 2000 Driver for JDBC also accepts connections that have the following format:jdbc:sqlserver://ConnectionString
The exception occurs because the SQL Server 2000 Driver for JDBC is not designed to connect to a SQL Server 2005 database.- SQL Server 2005 Driver for JDBC
- Microsoft JDBC Driver 4.0 for SQL Server
- Microsoft JDBC Driver 4.0 for SQL Server
- microsoft JDBC Driver for SQL Server
- SQL Server JDBC driver
- SQL Server 2005 JDBC Driver 配置
- Microsoft SQL Server 2005 JDBC Driver 1.1
- Microsoft SQL Server 2005 JDBC Driver 1.1
- Microsoft SQL Server 2000 Driver for JDBC,连接池
- SQL Server 2000 Driver for JDBC Service Pack 3
- Microsoft SQL Server 2000 Driver for JDBC 连接数据库
- SQL Server 2000 Driver for JDBC安装与配置
- SQL Server 2000 Driver for JDBC安装与配置
- [Microsoft][SQL Server 2000 Driver for JDBC]Error establishing socket.
- JDBC For SQL Server 2005
- JTDS-sql server jdbc driver
- Microsoft SQL Server 2000 Driver for JDBC SP1与连接SQL Server实例的问题
- Microsoft SQL Server及SQL Server 2000 Driver for JDBC安装与配置
- 更改远程桌面登陆端口
- 真正的嵌入式精英是如何修炼成的?
- hlsl语法规则小结
- 日记-2010.5.30
- 定时操作的三种触发器,作业,任务计划
- SQL Server 2005 Driver for JDBC
- 回调函数简单说明
- Socket操作类
- Base64 Online Encode and Decode Tools - Base64加解密在线工具
- 简单的Delphi三层程序开发
- 亲爱的朋友,请不要忽视知识管理
- 打印分页css样式,style="page-break-after:always;"
- 二进制上传下载
- 微软宣布XP Mode虚拟机不再需要硬件虚拟化技术