Databases
StackOverflow2013
Postsdbo
POODAC & C# - TNS: Connect timeout occurred - Connecting only through VS2005 debugger
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POODAC & C# - TNS: Connect timeout occurred - Connecting only through VS2005 debugger
    primarykey
    data
    text
    <p>I am new to Oracle, and there is an issue I am facing. When I run the application from IDE - Visual Studio 2005, The database connection is established smoothly, but when I run an installed version of the app, the DB connection fails and I get a TNS: Connect timeout occurred error.</p> <p>I tried with SQLNET.ORA and similar solutions found online, but I could not resolve the issue. I wonder why this happens, since the application running through the IDE and through an installation is on the same PC. I made sure the TNSNAMES.ORA file was correctly edited, and I can connect through an instance of the application running directly on Visual Studio.</p> <pre><code>public bool connectToDatabase(string dbConnStr) { try { databaseConnection = dbConnStr; OracleConnection dbConn = new OracleConnection(databaseConnection); if (dbConn == null) { CreateDLLLogFiles.ErrorLog(CreateDLLLogFiles.FileName, "Connection object is null"); return false; } if (dbConn.State.ToString().Equals("Closed", StringComparison.OrdinalIgnoreCase)) { CreateDLLLogFiles.ErrorLog(CreateDLLLogFiles.FileName, "DB connection - " + dbConn.ConnectionString); dbConn.Open(); return true; } } catch (Exception ex) { CreateDLLLogFiles.ErrorLog(CreateDLLLogFiles.FileName, ex.Message + "\n" + ex.StackTrace); CreateDLLLogFiles.ErrorLog(CreateDLLLogFiles.FileName, "DB String - " + databaseConnection); return false; } return false; } </code></pre> <p>The stack trace reads like this:</p> <pre><code>7/22/2010 6:38:51 PM ORA-12170: TNS:Connect timeout occurred at Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck) at Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, Object src) at Oracle.DataAccess.Client.OracleConnection.Open() at SQL.connectToDatabase(String dbConnStr) </code></pre> <p>The tnsnames.ora is something like this:</p> <pre><code>MySource = (DESCRIPTION = (CONNECT_TIMEOUT=180)(RETRY_COUNT=2) (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 125.63.77.232)(PORT = 1521))) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = MySource ) ) ) </code></pre> <p>In the meanwhile, I was being issued a ContextSwitchDeadlock error through the debugger, so I followed instructions and changed the attribute from STAThread to MTAThread on Main(). No more ContextSwitchDeadlock - and Still, the connection issue persists. </p> <p>I was hoping you could shed some light on the issue - I am close to pulling my hair out. Any insight would be appreciated.</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USVMAtm
    1. USSreedevi J
    plurals
    1. This table or related slice is empty.
    1. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POODAC & C# - TNS: Connect timeout occurred - Connecting only through VS2005 debugger
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POODAC & C# - TNS: Connect timeout occurred - Connecting only through VS2005 debugger
      1. This table or related slice is empty.
      1. VTUpMod
    1. COHave you ensured that your application (when installed) has at least `Read` rights to the various Oracle client files and that file/registry virtualisation is not interfering? Have you also ensured that there is no firewall blocking outgoing traffic on the port the Oracle service is running on?
      singulars
      1. POODAC & C# - TNS: Connect timeout occurred - Connecting only through VS2005 debugger
      1. USslugster
    2. COYes, it has read access; there is no firewall blocking any ports either. Had that checked out first thing. I'm still wondering why it works only when running on VS2005 IDE - the application works like a charm at that point.
      singulars
      1. POODAC & C# - TNS: Connect timeout occurred - Connecting only through VS2005 debugger
      1. USSreedevi J
    3. COAlso, if I use SQLNET.ORA, I get a "packet write failure" error and it fails to connect from both instances - debugger and installed. IS that offering any clues? For now I am not using the SQLNET.ORA file.
      singulars
      1. POODAC & C# - TNS: Connect timeout occurred - Connecting only through VS2005 debugger
      1. USSreedevi J
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload