SQL Provider – AuctionPro

1. 데이터 연결 속성에 SQL Native Client 만 있는 경우 (로컬컴에 sqlncli.msi 설치시)

여러버전 있음

다운로드 : https://support.microsoft.com/en-us/help/2726013/download-information-about-the-sql-server-native-client-drivers-that-a

PROVIDER=MSDASQL;driver={SQL Native Client};server=1.222.333.444;uid=myID;pwd=myPassword;database=myDB

2. 데이터 연결 속성에 Native Client 10.0 인 만 있은 경우

Provider=SQLNCLI10.1;User ID=myID;Initial Catalog=;Data Source=1.222.333.444;password =myPassword

2. Provider=SQLOLEDB;SERVER=111.111.111.111,2222;uid=myID;Pwd=myPassword;Database=myDB;network library=dbmssocn

asp 파일 로 연결 테스트


<%
'////////////////////   DB접속정보   ////////////////////////////////////////
dim db
dim db_name
dim db_ip
dim db_id
dim db_pass

db_ip="111.111.111.111,2222"
db_name="dbname"
db_id="myid"
db_pass="mypass"

sub dbconn_sub
  dim strConnection
  set db = Server.CreateObject("ADODB.Connection")
  strConnection = "Provider=SQLOLEDB;SERVER="& db_ip &";Uid="& db_id &";Pwd="& db_pass &";Database="& db_name &";network library=dbmssocn"
  db.open strConnection 
end sub

dbconn_sub

%>

'//////////////////// DB접속정보 ////////////////////////////////////////

dim db

dim db_name

dim db_ip

dim db_id

dim db_pass

db_ip="111.111.111.111,2222"

db_name="dbname"

db_id="myid"

db_pass="mypass"

sub dbconn_sub

dim strConnection

set db = Server.CreateObject("ADODB.Connection")

strConnection = "Provider=SQLOLEDB;SERVER="& db_ip &";Uid="& db_id &";Pwd="& db_pass &";Database="& db_name &";network library=dbmssocn"

db.open strConnection

end sub

dbconn_sub