oracle连接问题!!!老大们,过来看看,急呀!!!

[tonghaibinfc]

系统win2003

开始在.net2002下,oleDbConnection用向导生成connectionString连接测试成功
在打开时出错:

Error while trying to retrieve text for error ORA-01019
说明: 执行当前 Web 请求期间，出现未处理的异常。请检查堆栈跟踪信息，以了解有关该错误以及代码中导致错误的出处的详细信息。

异常详细信息: System.Data.OleDb.OleDbException: Error while trying to retrieve text for error ORA-01019

而用OracleClient.OracleConnection时,也同样出错:

无法创建环境: OCIEnvCreate 返回 -1。
说明: 执行当前 Web 请求期间，出现未处理的异常。请检查堆栈跟踪信息，以了解有关该错误以及代码中导致错误的出处的详细信息。

异常详细信息: System.Exception: 无法创建环境: OCIEnvCreate 返回 -1。

搜索了下,说只有.net framework 1.1才支持连接oracle,就改装vs.net2003

但还是出同样的错!

这个是什么问题呢?各位老大帮帮忙,谢谢了!

[steveson]

错误提示是ORA-01019，好像是从oracle数据库那边抛出来的

[softye]

这是连接Oracle 大全 看对你有用不！！

Oracle
· ODBC


o New version:
"Driver={Microsoft ODBC for Oracle};Server=OracleServer.world;Uid=Username;Pwd=asdasd;"
o Old version:
"Driver={Microsoft ODBC Driver for Oracle};ConnectString=OracleServer.world;Uid=myUsername;Pwd=myPassword;"
· OLEDB, OleDbConnection (.NET)


o Standard security:
"Provider=msdaora;Data Source=MyOracleDB;User Id=UserName;Password=asdasd;"
This one's from Microsoft, the following are from Oracle
o Standard Security:
"Provider=OraOLEDB.Oracle;Data Source=MyOracleDB;User Id=Username;Password=asdasd;"
o Trusted Connection:
"Provider=OraOLEDB.Oracle;Data Source=MyOracleDB;OSAuthent=1;"
· OracleConnection (.NET)


o Standard:
"Data Source=Oracle8i;Integrated Security=yes";
This one works only with Oracle 8i release 3 or later
o Declare the OracleConnection:
C#:
using System.Data.OracleClient;
OracleConnection oOracleConn = new OracleConnection();
oOracleConn.ConnectionString = "my connectionstring";
oOracleConn.Open();

VB.NET:
Imports System.Data.OracleClient
Dim oOracleConn As OracleConnection = New OracleConnection()
oOracleConn.ConnectionString = "my connectionstring"
oOracleConn.Open()
· Data Shape


o MS Data Shape:
"Provider=MSDataShape.1;Persist Security Info=False;Data Provider=MSDAORA;Data Source=orac;user id=username;password=mypw"

[acewang]

有没有防火墙之类的?

[steveson]

http://www.dgi.com/support/faq_openworks.shtml 下的回答

16. I get error ORA-01019. What does this mean?

This means that the client (ev_getdata) cannot communicate with the Oracle server. It is not caused by the usual types of communication problems though. A number of things can cause it. The most common cause is a version of SQL*Net that is incompatible with the import programs.

[godliu521]

hehe

[tonghaibinfc]

防火墙,本机win2003自带的,关了

[tonghaibinfc]

测试连接成功的

[_5_]

看看是不是你的ORACLE（客户端？）和服务器版本不一致造成的！

[tonghaibinfc]

郁闷呀

我系统是2003,装了vs.net2002和2003，

[tonghaibinfc]

在2000下没任何问题,在2003下就出上面的错了

2003下安装要注意什么呢?