使用oracle client 远程连接oracle,使用Oracle 2.0的OracleClient连接到远程Oracle 11g服务器...

我必须使用.NET / C#(Winform)应用程序连接到网络上的Oracle服务器。我试图使用System.Data.OracleClient但徒劳无功。

以下是我可能想到的细节(这可能有助于读者阅读这个问题)：

平台：Windows Vista家庭高级版带有C#的Visual Studio 2005 / .NET 2.0

图书馆：System.Data.OracleClient

服务器：Oracle 11g(位于同一局域网内)

请注意，我没有在本地安装Oracle，并且我已经为每个讨论论坛寻找帮助 - 但其中大多数都假定本地Oracle安装！

这是我的连接字符串：

“User Id=TSUSER;Password=ts12TS;Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=MyServerIP)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=ORCL)));”

我得到这个错误：

OCIEnvCreate failed with return code -1 but error message text was not available.堆栈跟踪：

at System.Data.OracleClient.OciHandle..ctor(OciHandle parentHandle, HTYPE handleType, MODE ocimode, HANDLEFLAG handleflags)

at System.Data.OracleClient.OracleInternalConnection.OpenOnLocalTransaction(String userName, String password, String serverName, Boolean integratedSecurity, Boolean unicode, Boolean omitOracleConnectionName)

at System.Data.OracleClient.OracleInternalConnection..ctor(OracleConnectionString connectionOptions)

at System.Data.OracleClient.OracleConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject)

at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options)

at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject)

at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject)

at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)

at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)

at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)

at System.Data.OracleClient.OracleConnection.Open()

at DGKit.Util.DataUtil.Generate() in D:\SVNRoot\sandbox\DGDev\Util\DataUtil.cs:line 68