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=127.0.0.1;uid=username;pwd=P@ssw0rd;database=dbname;"
%>

MS-SQL 2005 Connection String


<%
oConnection.Open "Provider=SQLNCLI;Server=127.0.0.1;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 *