在VB当中采用引用的ADO技术，如何在语句中实现与Oracle连接

[yujingjun]

在VB当足采用引用的ADO技术，如何在语句足实现与Oracle连接

[w18ily]

OLE DB Provider for Oracle (from Oracle)
For Standard Security

oConn.Open "Provider=OraOLEDB.Oracle;" & _
"Data Source=MyOracleDB;" & _
"User Id=myUsername;" & _
"Password=myPassword"

For a Trusted Connection

oConn.Open "Provider=OraOLEDB.Oracle;" & _
"Data Source=MyOracleDB;" & _
"User Id=/;" & _
"Password="
' Or
oConn.Open "Provider=OraOLEDB.Oracle;" & _
"Data Source=MyOracleDB;" & _
"OSAuthent=1"
Note: "Data Source=" must be set to the appropriate Net8 name which is known to the naming method in use. For example, for Local Naming, it is the alias in the tnsnames.ora file; for Oracle Names, it is the Net8 Service Name.

[w18ily]

ODBC Driver for Oracle (from Oracle)
oConn.Open "Driver={Oracle ODBC Driver};" & _
"Dbq=myDBName;" & _
"Uid=myUsername;" & _
"Pwd=myPassword"
Where: The DBQ name must be defined in the tnsnames.ora file

[CloneCenter]

建立一个 oracle ODBC 数据源，然后使用连接字符串来连接。
"Provider=MSDAORA.1;Password=12345;User ID=system;Data Source=OracleData;Persist Security Info=True"

[starry]

建立一个oracle的dsn
建立ado的connection对象cn
cn.ConnectionString = "dsn=ora_dsn;UID=username;PWD=passwd"
cn.open
ok了