廢物金魚之打雜紀錄

Microsoft SQL Server

OLE DB

<%
Set cnn = Server.CreateObject("ADODB.Connection")
cnn.open "PROVIDER=SQLOLEDB;DATA SOURCE=sqlservername;UID=username;PWD=password;DATABASE=mydatabase "
%>

有 DSN 時

<%
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.open "DSN=MyDSN;UID=user;PWD=password;DATABASE=mydatabase"
%>

沒有 DSN 時

<%
Set Conn = Server.CreateObject("ADODB.Connection")
DSNtest="DRIVER={SQL Server};SERVER=ServerName;UID=USER;PWD=password;DATABASE=mydatabase"
Conn.open DSNtest
%>

 

ref: https://support.microsoft.com/zh-tw/help/300382/how-to-create-a-database-connection-from-an-asp-page-in-iis

=====================================================================================

盡力耍廢也很好

By 金魚