如何连接ACESS和ORACLE?
想知道连接代码如何写，为什么用ASP的写法连不上了？ 问题点数：40、回复次数：3Top
1 楼saucer（思归）回复于 2003-01-07 10:27:02 得分 10
you need to use classes in System.Data.OleDb namespace,and see
http://www.able-consulting.com/dotnet/adonet/Data_Providers.htm#OLEDBManagedProviderTop
2 楼xuzhi（芝）回复于 2003-01-07 10:56:24 得分 15
string myConnectionString = "Provider=MSDAORA;Password=gp;User ID=ja;Data Source=GP";
OleDbConnection myConnection = new OleDbConnection(myConnectionString);
myConnection.Open();
将Password 、User ID 、Data Source换成你的ORACLE数据库的用户密码、连接用户名、数据库名即可打开一个ORACLE数据库连接Top
3 楼daleyin（生存之道!）回复于 2003-01-07 11:00:52 得分 15
连结ACCESS:
dim sConnString as string="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\knowledgelib.mdb;Persist Security Info=False"
objconn = new oledbconnection (sConnString)
objconn.open()
连结ORACLE:
dim sConnString as string="Password=数据库密码;Persist Security Info=True;UID=数据用户名;database=数据库名称;server=数据库所在服务器名称或IP"
objconn = new oledbconnection (sConnString)
objconn.open()
或建立一个ODBC数据源,然后象再连结:
Top
