Connection Issue with dotConnect for Oracle.

Connection Issue with dotConnect for Oracle.

Postby sudhanshu » Thu 15 May 2014 10:19

I am not able to connect with my Oracle database when I use (dotConnect for Oracle) as a data provider, but I can connect successfully using (OPD.NET, Managed Driver) or using Oracle Client.
It give me error :- 'Server did not respond within the specified timeout interval.'
Details :-
I tried below settings but it does not provide any positive result.
ORACLE_HOME = c:\app\administrator\product\12.1.0\client_3\network\admin\tnsnames.ora
ORACLE_HOME = c:\app\administrator\product\12.1.0\client_3

-------
Please respond ... Thanks in advance.
sudhanshu
 
Posts: 3
Joined: Thu 08 May 2014 10:46

Re: Connection Issue with dotConnect for Oracle.

Postby Pinturiccio » Fri 16 May 2014 15:16

Probably you use several Oracle Clients, and different Oracle Clients are used with dotConnect for Oracle and ODP.NET or Oracle Client providers.

dotConnect for Oracle allows you to specify an Oracle Home for the connection. You can do this with the 'HOME' parameter in the connection string, or using the 'Home' property of the OracleConnection or OracleConnectionStringBuilder objects. For more information, please refer to http://www.devart.com/dotconnect/oracle/docs/?Devart.Data.Oracle~Devart.Data.Oracle.OracleConnection~Home.html

You can also use the Direct connection mode that does not require Oracle Client. For more information, please refer to http://www.devart.com/dotconnect/oracle/docs/?DirectMode.html
Pinturiccio
Devart Team
 
Posts: 2020
Joined: Wed 02 Nov 2011 09:44


Return to dotConnect for Oracle