c#中连接oracle数据库不能读取数据，用的是oledb，这样写有什么问题吗？_百度知道
c#中连接oracle数据库不能读取数据，用的是oledb，这样写有什么问题吗？
public int ExecuteSql(string strSql)
int intTmp=1;
string strConn=ConfigurationSettings.AppSettings[&strConn&];
OleDbConnection ObjConn = new OleDbConnection(strConn);
ObjConn.Open();
OleDbCommand ObjCmd = new OleDbCommand(strSql, ObjConn);
OleDbDataReader ObjDR= ObjCmd.ExecuteReader();
if (ObjDR.Read())
intTmp=Convert.ToInt32(ObjDR[0].ToString());
ObjConn.Close();
ObjConn.Dispose();
return intT
还有你确定连上数据库了？以及确定你的sql语句是能取到数据的？参考：
来自团队：
其他类似问题
为您推荐：
oracle数据库的相关知识
等待您来回答
下载知道APP
随时随地咨询
出门在外也不愁转)C#中连接各种数据库方法&odbc&oledb&sqlserver(
SQL——OLEDB&
Provider=SQLOLEDB.1;Data
Source=.\SQLEXPRESS;Integrated Security=SSPI;Initial
Catalog=NorthWind
SQL Server
Standard Security:
"Driver={SQL
Server};Server=Aron1;Database=Uid=Pwd="
Trusted connection:
"Driver={SQL
Server};Server=Aron1;Database=Trusted_Connection="
Prompt for username and password:
oConn.Properties("Prompt") = adPromptAlways
oConn.Open "Driver={SQL Server};Server=Aron1;DataBase="
OLEDB, OleDbConnection (.NET)
Standard Security:
"Provider=Data Source=Aron1;Initial Catalog=User
Id=Password="
Trusted Connection:
"Provider=Data Source=Aron1;Initial
Catalog=Integrated Security=SSPI;"
(use serverName\instanceName as Data Source to use an specifik
SQLServer instance, only SQLServer2000)
Prompt for username and password:
oConn.Provider = "sqloledb"
oConn.Properties("Prompt") = adPromptAlways
oConn.Open "Data Source=Aron1;Initial Catalog="
Connect via an IP address:
"Provider=Data Source=190.190.200.100,1433;Network
Library=DBMSSOCN;Initial Catalog=User
ID=Password="
(DBMSSOCN=TCP/IP instead of Named Pipes, at the end of the Data
Source is the port to use (1433 is the default))
SqlConnection (.NET)
Standard Security:
"Data Source=Aron1;Initial Catalog=User
Id=Password="
Trusted Connection:
"Data Source=Aron1;Initial Catalog=Integrated
Security=SSPI;"
(use serverName\instanceName as Data Source to use an specifik
SQLServer instance, only SQLServer2000)
Connect via an IP address:
"Data Source=190.190.200.100,1433;Network Library=DBMSSOCN;Initial
Catalog=User ID=Password="
(DBMSSOCN=TCP/IP instead of Named Pipes, at the end of the Data
Source is the port to use (1433 is the default))
Declare the SqlConnection:
using System.Data.SqlC
SqlConnection oSQLConn = new SqlConnection();
oSQLConn.ConnectionString="my connectionstring";
oSQLConn.Open();
Imports System.Data.SqlClient
Dim oSQLConn As SqlConnection = New SqlConnection()
oSQLConn.ConnectionString="my connectionstring"
oSQLConn.Open()
Standard Security:
"Driver={Microsoft Access Driver
(*.mdb)};Dbq=\somepath\mydb.Uid=APwd="
Workgroup:
"Driver={Microsoft Access Driver
(*.mdb)};Dbq=\somepath\mydb.SystemDB=\somepath\mydb.","admin",
OLEDB, OleDbConnection (.NET)
Standard security:
"Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=\somepath\mydb.User Id=Password="
Workgroup (system database):
"Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=\somepath\mydb.Jet OLEDB:System
Database=system.","admin", ""
With password:
"Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=\somepath\mydb.Jet OLEDB:Database
Password=MyDbP","admin", ""
New version:
"Driver={Microsoft ODBC for
Oracle};Server=OracleServer.Uid=UPwd="
Old version:
"Driver={Microsoft ODBC Driver for
Oracle};ConnectString=OracleServer.Uid=myUPwd=myP"
OLEDB, OleDbConnection (.NET)
Standard security:
"Provider=Data Source=MyOracleDB;User
Id=UserNPassword="
This one's from Microsoft, the following are from Oracle
Standard Security:
"Provider=OraOLEDB.OData Source=MyOracleDB;User
Id=UPassword="
Trusted Connection:
"Provider=OraOLEDB.OData
Source=MyOracleDB;OSAuthent=1;"
OracleConnection (.NET)
"Data Source=Oracle8i;Integrated Security=yes";
This one works only with Oracle 8i release 3 or later
Declare the OracleConnection:
using System.Data.OracleC
OracleConnection oOracleConn = new OracleConnection();
oOracleConn.ConnectionString = "my connectionstring";
oOracleConn.Open();
Imports System.Data.OracleClient
Dim oOracleConn As OracleConnection = New OracleConnection()
oOracleConn.ConnectionString = "my connectionstring"
oOracleConn.Open()
Data Shape
MS Data Shape:
"Provider=MSDataShape.1;Persist Security Info=FData
Provider=MSDAORA;Data Source=user
id=password=mypw"
Local database:
"Driver={mySQL};Server=mySrvNOption=16834;Database="
Remote database:
"Driver={mySQL};Server=;Port=3306;Option=131072;Stmt=;Database=my-Uid=Pwd="
OLEDB, OleDbConnection (.NET)
"Provider=MySQLPData Source=User
Id=UserNPassword="
MySqlConnection (.NET)
"Data Source=Database=User
ID=Password=Command Logging=false"
This one is used with eInfoDesigns dbProvider, an add-on to
Declare the MySqlConnection:
using EID.MySqlC
MySqlConnection oMySqlConn = new MySqlConnection();
oMySqlConn.ConnectionString = "my connectionstring";
oMySqlConn.Open();
Imports EID.MySqlClient
Dim oMySqlConn As MySqlConnection = New MySqlConnection()
oMySqlConn.ConnectionString = "my connectionstring"
oMySqlConn.Open()
OLEDB, OleDbConnection (.NET) from ms
"Provider=DB2OLEDB;Network Transport Library=TCPIP;Network
Address=XXX.XXX.XXX.XXX;Initial Catalog=MyCPackage
Collection=MyPkgCDefault Schema=SUser
ID=MyUPassword=MyPW"
"Provider=DB2OLEDB;APPC Local LU Alias=MyAAPPC Remote LU
Alias=MyRInitial Catalog=MyCPackage
Collection=MyPkgCDefault Schema=SUser
ID=MyUPassword=MyPW"
"Driver={SYBASE SYSTEM
11};Srvr=Aron1;Uid=Pwd="
Intersolv 3.10:
"Driver={INTERSOLV 3.10 32-BIT
Sybase};Srvr=Aron1;Uid=Pwd="
Informix 3.30:
"Dsn='';Driver={INFORMIX 3.30 32
BIT};Host=Server=Service=service-Protocol=Database=UID=PWD=myPwd
Informix-CLI 2.5:
"Driver={Informix-CLI 2.5 (32
Bit)};Server=Database=Uid=Pwd=myPwd"
"DSN=myDUid=Pwd=;"
"FILEDSN=c:\myData.Uid=Pwd=;"
"Driver={Microsoft Excel Driver
(*.xls)};DriverId=790;Dbq=C:\MyExcel.DefaultDir=c:\"
"Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=C:\MyExcel.Extended Properties=Excel 8.0;HDR=Y"
"HDR=Y" indicates that the first row contains columnnames, not
DBF / FoxPro
"Driver={Microsoft dBASE Driver
(*.dbf)};DriverID=277;Dbq=c:\"
OLEDB, OleDbConnection (.NET)
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\Extended
Properties=dBASE IV;User ID=APassword="
"Driver={Pervasive ODBC Client
Interface};ServerName=dbq=@dbname"
1.使用SqlConnection对象:
public void SqlConnectionOpen()
SqlConnection conn= new SqlConnection();
conn.ConnectionString = "user id=password=;initial
catalog=datasource=connect Timeout=20";
conn.Open();
2.使用OleDbConnection对象:
public void OleDBConnectionOpen()
OleDBConnection conn = new OleDbconnection();
conn.ConnectionString="Provider=Microsoft.Jet.OLEDB.4.0;DataSource=C:\Customer.mdb";
conn.Open();
1.ODBC连接Access本地数据库
conGoodDay.Open("Driver={Microsoft Access
Driver(*.mdb)};"+"Dbq=C:\a."+
"Uid=A"+"Pwd=;");
2.ODBC连接Access系统数据库
conGoodDay.Open("Driver={Microsoft Access
Driver(*.mdb)};"+"Dbq=C:\a."+
"SystemDB=A"+"Pwd=;");
3.ODBC连接Access系统数据库
conGoodDay.Open("Driver={Microsoft Access
Driver(*.mdb)};"+"Dbq=\\server\share\a.");
4.ODBC连接Excel系统数据库
conGoodDay.Open("Driver={Microsoft Access
Driver(*.xls)};"+"DriverId=790;"+
"Dbq=C:\a."+"DefaultDir=c:\");
5.ODBC连接Oracle系统数据库
conGoodDay.Open("Driver={Microsoft ODBC for
oracle};"+"Server=OracleServer."+
"Uid=A"+"Pwd=");
6.ODBC连接Sql Servr
conGoodDay.Open("Driver={Sql
Server};"+"Server=myS"+"Database=myDatabaseN"
"Uid=A"+"Pwd=");
7.ODBC连接Visual FoxPro
conGoodDay.Open("Driver={Microsoft Visual FoxPro Driver};"+
"SourceType=DBC;"+"SourceDB=c:a."+"Exclusive=No;");
以上网友发言只代表其个人观点，不代表新浪网的观点或立场。C#中使用远程的Oracle数据库的连接字符串_百度知道
C#中使用远程的Oracle数据库的连接字符串
有一个Winfrom程序；原来是sqlserver的数据库现在改成Oracle的数据库我第一次使用Oracle，连接字串不知道怎么写，IP地址，用户名，密码，库名，都知道网上写的是 ：“Data Source=User Id=Password=123”好像还要装客户端，修改orant\net80\admin\tnsnames.ora 文件。这个是不能实现的，我的用户那么多，不可能每个都部署
提问者采纳
学会搜索，参考：
我看你发的连接不安装，但是也要一台一台的部署啊能不能像SQLserver那样，没环境要求啊！
SQLserver也有环境要求的，它要求每台机器都安装MDAC只不过现在的Windows默认都自带安装好了另外，这个链接，所要求的步骤，你完全可以通过程序去实现，比如程序启动时，检查注册表、环境变量，如果不存在，就进行相应设置，而不需要自己去部署
其他类似问题
为您推荐：
oracle数据库的相关知识
其他2条回答
要在你的服务器上配置的你的TNS才可以的！！你的TNS只需要写一个就好了啊！跟客户多少有什么关系？除非你每个客户都有一个Schma？不可以把数据都放在一个schma下面么！这样配置一个就好了！！
Driver={Microsoft ODBC for Oracle};Server=myServerAUid=myUPwd=myP
Driver={Microsoft ODBC Driver for Oracle};ConnectString=OracleServer.Uid=myUPwd=myP
OLE DB, OleDbConnection (.NET)
此连接字符串适用了微软的驱动。
Provider=Data Source=MyOracleDB;User Id=myUPassword=myP
Provider=Data Source=MyOracleDB;Persist Security Info=FIntegrated Security=Y
由Oracle提供的驱动。
Provider=OraOLEDB.OData Source=MyOracleDB;User Id=myUPassword=myP
Provider=...
等待您来回答
下载知道APP
随时随地咨询
出门在外也不愁您所在的位置： &
C#中Access数据库连接字符串出现错误的解决方法
C#中Access数据库连接字符串出现错误的解决方法
这里将介绍C#中Access数据库连接字符串出现错误的解决方法，主要错误提示为数据插入成功但数据库中无数据解决方法，希望本文对大家有所帮助。
C#数据库连接关键在于连接字符串，这是数据库开发中最重要的，如果数据库连接不上， 其它的一切对数数库的操作都不能进行。因此C#中Access数据库连接字符串出现错误的可能性很高。
C#中Access数据库连接字符串解决代码：&key="ConnectionString"&value="Provider=Microsoft.Jet.OLEDB.4.0;Data&Source=zijin.Jet&OLEDB:Database&Password=Persist&Security&Info=False"&
数据插入成功但数据库中无数据解决方法：
把编译后的exe文件、cofig配置文件以及数据库复制出来，放到一个文件夹中，就OK了！
C#中Access数据库连接字符串出现错误的解决方法
【编辑推荐】
【责任编辑： TEL：（010）】
关于的更多文章
Angular.js 是一个MV*（Model-View-Whatever，不管是MVC或者MVVM
再过一次生日，我就满七十岁了。而且正如大家印象中一样，像我这个年纪的...
Hadoop Summit 2013 大会讲师 PPT 第二季重磅来袭！如
现在这天气到处都是高温，还是老老实实的呆在家里上网
、27日，在美国圣何塞举行的Hadoop Summit
本书是根据全国计算机技术与软件专业资格（水平）考试“网络工程师级考试大纲”编写的考试辅导用书。全书主体按考试大纲的章节编
51CTO旗下网站}