1. When trying to connect using direct mode with the correct host and service name, we got an "Invalid service name" error message. We created a tiny console application to verify that. The connection string looked like this:
Code: Select all
User Id=theuser;Password=thepassword;Server=the.fqdn.of.the.host;Direct=True;Service name=theservicename
Code: Select all
User Id=theuser;Password=thepassword;Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=the.fqdn.of.the.host)(PORT=1521)))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=theservicename)));Direct=False
Code: Select all
Can not load Oracle client library oci.dll from home . at Devart.Data.Oracle.OracleHome.get_ClientVersion()
at Devart.Data.Oracle.aw.a(Boolean A_0, Boolean A_1, OracleHome A_2, Boolean A_3)
at Devart.Data.Oracle.OracleInternalConnection..ctor(aa connectionOptions, OracleInternalConnection proxyConnection)
at Devart.Data.Oracle.cs.a(l A_0, Object A_1, DbConnectionBase A_2)
at Devart.Common.DbConnectionFactory.a(DbConnectionPool A_0, l A_1, DbConnectionBase A_2)
at Devart.Common.DbConnectionPool.a(DbConnectionBase A_0)
at Devart.Common.DbConnectionPool.GetObject(DbConnectionBase owningConnection)
at Devart.Common.DbConnectionFactory.a(DbConnectionBase A_0)
at Devart.Common.DbConnectionClosed.Open(DbConnectionBase outerConnection)
at Devart.Common.DbConnectionBase.Open()
at Devart.Data.Oracle.OracleConnection.Open()
at Devart.Common.Entity.b7.a(DbConnection A_0)
at Devart.Data.Oracle.Entity.j.a(OracleConnection A_0, Boolean A_1)
at Devart.Data.Oracle.Entity.OracleEntityProviderServices.GetDbProviderManifestToken(DbConnection connection)
at System.Data.Common.DbProviderServices.GetProviderManifestToken(DbConnection connection)
I also added a test aspx page which executes the following code, and the page was successful.
Code: Select all
If you can help me solve this, I will be glad. I will be even more happy if I could resolve the first of these issues, such as not to need the instant client at all.
Thanks,
chiccodoro