Microsoft SQL Server 2005 连接字符串

July 24th, 2008 9:48 PM 5 Comments Filed under: 资源分享 Feed for this Entry

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

5 Comments

  1. Ulysses Ulysses Says:

    July 26th, 2008 at 08:59 am

    鄙视啊，不加上原文地址。

    :)

  2. A君 A君 Says:

    July 26th, 2008 at 11:18 am

    哈哈，就不加。人家已经知道了。你来也。。。

  3. Ulysses Ulysses Says:

    July 29th, 2008 at 09:14 am

    搜索這個標題，你的竟然在 Google 中排前面，沒天理！

  4. A君 A君 Says:

    July 29th, 2008 at 01:45 pm

    我看了，没有我的链接。

  5. Ulysses Ulysses Says:

    July 30th, 2008 at 09:14 am

    http://www.google.com/search?q=Microsoft+SQL+Server+2005+%E8%BF%9E%E6%8E%A5%E5%AD%97%E7%AC%A6%E4%B8%B2&ie=utf-8&oe=utf-8&aq=t&rls=org.mozilla:zh-CN:official&client=firefox-a

    第一页，第六个。

Leave a comment

captcha
请输入验证码