紧急求助,求VB连接ORACLE数据库的字符串

bingchuanhan 2010-09-07 01:50:36

如何连接

紧急求帮

谢谢

...全文

145 7 打赏收藏转发到动态举报

写回复

用AI写文章

7 条回复

切换为时间正序

请发表友善的回复…

发表回复

_db_ 2010-09-09

打赏
举报

如果是 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】

ecjtu5208 2010-09-09

打赏
举报



Dim cnn As New ADODB.Connection

Dim rs As New ADODB.Recordset



cnn.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

ecjtu5208 2010-09-09

打赏
举报

Dim cnn As New ADODB.Connection
Dim rs As New ADODB.Recordset

cnn.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

我这个得给全分啊。

mxd163 2010-09-08

打赏
举报

[Quote=引用 3 楼 xman_78tom 的回复:]
.NET Framework Data Provider for Oracle (System.Data.OracleClient.OracleConnection)
Data Source=MyOracleDB;User Id=myUsername;Password=myPassword;Integrated Security=no;

.NET Framework Data Provid……
[/Quote]
顶

xman_78tom 2010-09-07

打赏
举报

.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;