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.
Connection Issue with dotConnect for Oracle.
-
- Devart Team
- Posts: 2420
- Joined: Wed 02 Nov 2011 09:44
Re: Connection Issue with dotConnect for Oracle.
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 ... ~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 ... tMode.html
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 ... ~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 ... tMode.html