用ODBC,如:
string DbConnstr="Provider=OraOLEDB.Oracle;Password=tt_passwd;Persist Security Info=True;User ID=tt_user;Data S" + "ource=db.com;ConnectionTimeout=0;Extended Properties=\"\"";OleDbConnection myDbConn = new OleDbConnection(DbConnstr);
string DbConnstr="Provider=OraOLEDB.Oracle;Password=tt_passwd;Persist Security Info=True;User ID=tt_user;Data S" + "ource=db.com;ConnectionTimeout=0;Extended Properties=\"\"";OleDbConnection myDbConn = new OleDbConnection(DbConnstr);
解决方案 »
- oracle不对称查询语句
- 如何引用oracle.dataaccess.dll
- 请问大虾们:10G Universal Installer是不是会把客户端和服务器端都默认安装进Windows系统
- 如何查看当前哪些表的记录正在被读取?
- oracle数据库语句优化问题
- LINUX下安装ORACLE客户端,可用tnsping通ORACLE数据库服务,但用SQLPLUS不能连上.
- 怎样根据表名返回该表已经建立了主键约束并删除它?
- 在设置自增字段时,写的触发器为什么不能执行?
- oracle查询
- 安装oracle数据库失败问题
- 在线请教Oracle 中的服务名是个什么东东?
- sql-server数据是否可以导入到oracle中呢?
Using C#:using System.Data.OracleClient;
OracleConnection oOracleConn = new OracleConnection();
oOracleConn.ConnectionString = "Data Source=Oracle8i;" +
"Integrated Security=SSPI";
oOracleConn.Open();
我的DATA后面没有RracleClient??
在建立OLEDBDATAADAPTER的时候,
winzard的最后一步是一些DETAILS:
有两个Generated上面是"!",不知道为什么,
一个是:Generated UPDATE statement:
Could not determine which columns uniquely identify the rows for "KFC_CHINASTORELIST".
另一个是:Generated DELETE statement:
Could not determine which columns uniquely identify the rows for "KFC_CHINASTORELIST".不知道为什么....
所以在程序中:oleDbDataAdapterOracle.Fill(ds,"KFC_CHINASTORELIST");
这句总会报错,不能通过,不知道怎么办了:(
有没有拖拖控件就可以的办法?
Using C#:using System.Data.OracleClient;
OracleConnection oOracleConn = new OracleConnection();
oOracleConn.ConnectionString = "Data Source=Oracle8i;" +
"Integrated Security=SSPI";
oOracleConn.Open();
Using VB.NET:Imports System.Data.OracleClient
Dim oOracleConn As OracleConnection = New OracleConnection()
oOracleConn.ConnectionString = "Data Source=Oracle8i;" & _
"Integrated Security=SSPI";
oOracleConn.Open()
谁能快速讲一下原理或有源代码看看都行....
http://download.oracle.com/otn/other/ole-oo4o/OraOLEDB_92020.exe
http://download.oracle.com/otn/other/ole-oo4o/OraWin_92010.exe
http://download.oracle.com/otn/other/ole-oo4o/OraOLEDB_90101.exe
http://download.oracle.com/otn/other/ole-oo4o/OraOLEDB_81730.zip
下载后再安装
using System.Data.OleDb;
using System.Data;
看看.net开发有关OleDb的介绍,很简单。