以下為VB連接ORACLE數據庫
-----------------------------------------------------
dim conn as adodb.connection
dim rs as adodb.Recordset
form_load()
set conn=new adodb.connection
conn.open"Provider=MSDAORA.1;Password=密码;User ID=用户名;Data Source=数据库服务器名;Persist Security Info=True"
先点击菜单中工程——应用,然后选择
Microsoft ActiveX Data Objects 2.5 Library
在程序中:
dim conn as adodb.connection
dim rs as adodb.Recordset
set conn=new adodb.connection
set rs=new adodb.Recordset
conn.open"Provider=MSDAORA.1;Password=密码;User ID=用户名;Data Source=数据库服务器名;Persist Security Info=True"
rs.open "select * from 表名", conn, adOpenStatic, adLockReadOnly
Set DataGrid1.DataSource = rs
先在odbc建一个 oracle odbc.
然后在程序中写
Dim conn As ADODB.Connection
Set conn = New ADODB.Connection
conn = "DSN=;UID=;PWD=;SERVER="
--------------------------------------------------------
ORACLE中的SQL語句與SQL SERVER中的SQL語句有不同的地方。