不用odbc怎么连接远程oriacal数据库

Question

Provider=MSDAORA.1;Password=a;User ID=a;Data Source=server;Persist Security Info=True
以上是连接字符串，修改相应信息即可

Answer 1

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"