Microsoft SQL Server 2005 连接字符串

Written by aijun July 24th, 2008 9:48 PM 5 Comments Filed under: 资源分享

ASP 中通过 OLE DB 接口方式连接 Microsoft SQL Server 2000 和 Microsoft SQL Server 2005 ，连接字符串有一点区别，主要就是 Provider 后的内容。

Provider=SQLOLEDB;Data Source=server;Initial Catalog=database;User Id=user;Password=password; 

或者
Provider=SQLOLEDB;Server=server;Database=database;Uid=user;Pwd=password; 

Microsoft SQL Server 2005
Provider=SQLNCLI;Data Source=server;Initial Catalog=database;User Id=user;Password=password; 

或者
Provider=SQLNCLI;Server=server;Database=database;Uid=user;Pwd=password;

TAGS: sql, server

  1. 1