Oracle 사용을 위한 팁 (2)

Oracle Connection String - VB

1. FileDSN 사용

File : ORA_KTF.dsn

UserID : magicn

Password : ******

Service Name : mickey_ctf

cstDSN = "server=ORAJUDB;uid=magicn;pwd=******;FileDSN=ORA_KTF"

2. 직접 접속(Microsoft OLE DB Provider for Oracle)

ConnectionString = "Provider=MSDAORA;User ID=magicn;Password=******;Data Source=mickey_ctf;Persist Security Info=True"

3. 직접 접속2 (Oracle Provider for OLE DB)

ConnectionString = "Provider=OraOLEDB.Oracle;User ID=magicn;Password=******;Data Source=mickey_ctf"

ConnectionString = "Driver={Oracle ODBC Driver};Server=mickey_ctf;UID=magicn;PWD=******"