SQL 2005 Connection String – ASP

Print Friendly, PDF & Email

MS-SQL 2000 Connection String

Dim oConnection
Set oConnection = Server.CreateObject("ADODB.Connection")
oConnection.Open "provider=sqloledb;server=;uid=username;pwd=P@ssw0rd;database=dbname;"

MS-SQL 2005 Connection String

oConnection.Open "Provider=SQLNCLI;Server=;Database=dbname;UID=username;PWD=P@ssw0rd;"

Main Difference is Provider -> sqloledb and SQLNCLI

One thought on “SQL 2005 Connection String – ASP

  1. 빛찬이 says

    좋은 정보 감사합니다.
    이것땜에 얼마나 고생이 많았는지 몰라요.

    커피라도 사주고 싶네요 ^^;

Leave a Reply

Your email address will not be published. Required fields are marked *