ASP OLEDB 연결테스트 방법

 

ASP

<% 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 %>

0 1 2 3 4 5 6 7 8 9 10 11 12 13 14

<% 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   %>

 

2008ASPOLEDBRCServer