from http://www.connectionstrings.com:ODBC连接 New version: "Driver={Microsoft ODBC for Oracle};Server=OracleServer.world;Uid=Username;Pwd=asdasd;" Old version: "Driver={Microsoft ODBC Driver for Oracle};ConnectString=OracleServer.world;Uid=myUsername;Pwd=myPassword;" OLE DB, OleDbConnection (.NET) Standard security: "Provider=msdaora;Data Source=MyOracleDB;User Id=UserName;Password=asdasd;" This one's from Microsoft, the following are from OracleStandard Security: "Provider=OraOLEDB.Oracle;Data Source=MyOracleDB;User Id=Username;Password=asdasd;" Trusted Connection: "Provider=OraOLEDB.Oracle;Data Source=MyOracleDB;OSAuthent=1;"
引用:ADO Public p_Con As New ADODB.Connection Public Const p_strCon = "Provider=MSDAORA.1;Password=密码;User ID=用户名;Data Source=数据库;Persist Security Info=false" Public Sub main() On Error GoTo Ex p_Con.CursorLocation = adUseClient p_Con.Open p_strCon
New version:
"Driver={Microsoft ODBC for Oracle};Server=OracleServer.world;Uid=Username;Pwd=asdasd;" Old version:
"Driver={Microsoft ODBC Driver for Oracle};ConnectString=OracleServer.world;Uid=myUsername;Pwd=myPassword;" OLE DB, OleDbConnection (.NET) Standard security:
"Provider=msdaora;Data Source=MyOracleDB;User Id=UserName;Password=asdasd;"
This one's from Microsoft, the following are from OracleStandard Security:
"Provider=OraOLEDB.Oracle;Data Source=MyOracleDB;User Id=Username;Password=asdasd;" Trusted Connection:
"Provider=OraOLEDB.Oracle;Data Source=MyOracleDB;OSAuthent=1;"
Public Const p_strCon = "Provider=MSDAORA.1;Password=密码;User ID=用户名;Data Source=数据库;Persist Security Info=false"
Public Sub main()
On Error GoTo Ex
p_Con.CursorLocation = adUseClient
p_Con.Open p_strCon
Exit Sub
Ex:
End Sub
viena(维也纳nn-实心木头人石欠RUKYO)
的说法
用ODBC,几乎不用怎么改!!!