以下為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語句有不同的地方。
-----------------------------------------------------
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語句有不同的地方。
用.net 1.1 的oledb 访问Oracle.连接字符串:
"Provider=MSDAORA;User ID=sruser;Data Source=ora7;Password=sr123"