db = "Provider=MSDAORA.1;Password=---;User ID=---;Data Source=---;Persist Security Info=True"
.NET Framework Data Provider for Oracle (System.Data.OracleClient.OracleConnection) Data Source=MyOracleDB;User Id=myUsername;Password=myPassword;Integrated Security=no;.NET Framework Data Provider for OLE DB (System.Data.OleDb.OleDbConnection) Provider=OraOLEDB.Oracle;Data Source=MyOracleDB;User Id=myUsername;Password=myPassword;OLEDB.NET=True;Microsoft OLE DB Provider for Oracle Provider=msdaora;Data Source=MyOracleDB;User Id=myUsername;Password=myPassword;Oracle Provider for OLE DB Provider=OraOLEDB.Oracle;Data Source=MyOracleDB;User Id=myUsername;Password=myPassword;
如果是 VB6 Provider=OraOLEDB.Oracle;dbq=localhost:1521/XE;Database=myDataBase;User Id=myUsername;Password=myPassword; 如果是 VB.NET Data Source=MyOracleDB;User Id=myUsername;Password=myPassword;Integrated Security=no;连接字符串可以参看【www.connectionstrings.com】
Dim cnn As New ADODB.Connection Dim rs As New ADODB.Recordsetcnn.Open "Provider=MSDAORA.1;Password=密码;User ID=帐号;Data Source=数据库;Persist Security Info=True"rs.Open "select * from abc where rownum<=10", cnn, adOpenKeyset, adLockOptimisticcnn.Close我这个得给全分啊。
Dim cnn As New ADODB.Connection Dim rs As New ADODB.Recordsetcnn.Open "Provider=MSDAORA.1;Password=密码;User ID=帐号;Data Source=数据库;Persist Security Info=True"rs.Open "select * from abc where rownum<=10", cnn, adOpenKeyset, adLockOptimistic cnn.Close 别20分也要我和人分,统统给我 give me ,give me
Data Source=MyOracleDB;User Id=myUsername;Password=myPassword;Integrated Security=no;.NET Framework Data Provider for OLE DB (System.Data.OleDb.OleDbConnection)
Provider=OraOLEDB.Oracle;Data Source=MyOracleDB;User Id=myUsername;Password=myPassword;OLEDB.NET=True;Microsoft OLE DB Provider for Oracle
Provider=msdaora;Data Source=MyOracleDB;User Id=myUsername;Password=myPassword;Oracle Provider for OLE DB
Provider=OraOLEDB.Oracle;Data Source=MyOracleDB;User Id=myUsername;Password=myPassword;
Provider=OraOLEDB.Oracle;dbq=localhost:1521/XE;Database=myDataBase;User Id=myUsername;Password=myPassword;
如果是 VB.NET
Data Source=MyOracleDB;User Id=myUsername;Password=myPassword;Integrated Security=no;连接字符串可以参看【www.connectionstrings.com】
Dim rs As New ADODB.Recordsetcnn.Open "Provider=MSDAORA.1;Password=密码;User ID=帐号;Data Source=数据库;Persist Security Info=True"rs.Open "select * from abc where rownum<=10", cnn, adOpenKeyset, adLockOptimisticcnn.Close我这个得给全分啊。
Dim cnn As New ADODB.Connection
Dim rs As New ADODB.Recordsetcnn.Open "Provider=MSDAORA.1;Password=密码;User ID=帐号;Data Source=数据库;Persist Security Info=True"rs.Open "select * from abc where rownum<=10", cnn, adOpenKeyset, adLockOptimistic
cnn.Close
别20分也要我和人分,统统给我
give me ,give me