求教VB 连接ORACLE具体方法和步骤，水平有限，如能告知详细步骤或者提供相关资料，不胜感激


PS：数据库处于内网，本机已安装ORACLE 客户端，且用TOAD连接成功

[此贴子已经被作者于2007-9-16 12:08:02编辑过]

学会用搜索bbs.bc-cn.net/dispbbs.asp?BoardID=6&ID=165932

建一个 udl 然后用记事本打开就可以了

VB+oracle 连接示例:

Dim conn As ADODB.Connection
Dim rs As ADODB.Recordset
Dim sql As String
conn.CommandTimeout = 1
conn.Open "Provider=OraOLEDB.Oracle.1;Password=gl2hys;User ID=gl2hys;Data Source=gl2hys;Persist Security Info=True"
sql = "select * from sjk5_display"
rs1.CursorLocation = adUseClient
rs1.Open sql, conn, adOpenKeyset, adLockOptimistic