Server – SO Manual Site


<%
Dim Conn,db

Set Conn = Server.CreateObject("ADODB.Connection")

str = "Provider=SQLOLEDB;Data Source=서버IP;Initial Catalog=DB이름;user ID=아이디;password=비번;"

Conn.Open str

Conn.Close
Set Conn=Nothing

%>

Dim Conn,db

Set Conn = Server.CreateObject("ADODB.Connection")

str = "Provider=SQLOLEDB;Data Source=서버IP;Initial Catalog=DB이름;user ID=아이디;password=비번;"

Conn.Open str

Conn.Close

Set Conn=Nothing

[태그:] Server

ASP OLEDB 연결테스트 방법