我必须使用“NET”/C#(Winform)应用程序与网络的一名Oracle服务器连接。 我正在尝试使用<代码>System.Data.OracleClient但徒劳。
这里,我想到的细节(可能有助于阅读这一问题的人):
平台:视觉演播室2005年/NET 2.0 和视窗家庭保费C#
图书馆:System.Data.OracleClient
服务器:Oracle 11g(在同一局域网上的位置)
请注意,我没有当地安装甲骨文,我 every住了每一个可能提供帮助的讨论论坛,但大多数都假定当地安装甲骨文!
在这方面,我的联系是:
“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.
www.un.org/Depts/DGACM/index_spanish.htm 标记:
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:SVNRootsandboxDGDevUtilDataUtil.cs:line 68