Oracle ODBC Timeout issue

Ask a Question related to Coldfusion Database Access, Design and Development.

  1. #1

    Default Oracle ODBC Timeout issue

    I have a Windows 2003 Server running MX7 (7,0,0,91690, update level
    chf700003.jar) and the Oracle 8.1.7 client. I have created a System ODBC DSN
    using the Oracle ODBC Driver and it works fine using Oracle's ODBC test tool.
    I then created a CF data source in the Administrator using the ODBC Socket
    driver and pointing it to the ODBC DSN I just created. The data source will
    not verify. The error in the CFusionMX7\runtime\logs\coldfusion-err.log is:

    A non-SQL error occurred while requesting a connection from DEV1
    Timed out trying to establish connection
    SQLException while attempting to connect: java.sql.SQLException:
    [Macromedia][SequeLink JDBC Driver]Session refused by service, connection
    closed.
    [Macromedia][SequeLink JDBC Driver]Session refused by service, connection
    closed.

    Does anyone know what this error means and how it can be corrected? Thanks,

    Michael Mongeau
    Stratus Technologies



    MichaelXMongeau Guest

  2. Similar Questions and Discussions

    1. ODBC connectivity to Oracle
      Hi, I changed the entry in tnsnames.ora to point to a new Oracle database. Originally the server was connecting to Oracle 8 server but the new...
    2. CFMX MX7 ODBC Socket Timeout
      Hello, I have some problems with the odbc Socket under CMFX7. I have a System DSN on a Win2003 Server. Other Datasources work fine. I get the...
    3. Oracle 9.2.0.3.0 ODBC Fails
      We just upgrade our oracle server from 8i up to 9i and now our asp pages are failing. We were using the Microsoft ODBC drivers for Oracle V...
    4. PHP, ODBC, Oracle
      Hello, does anyone know the reason of displaying this error message: 'Specified driver could not be loaded due to system error 126 (Oracle73)?' ...
    5. Access 2002 ODBC Timeout Issue
      Desktop PC was recently upgraded (replaced would be a better term) with Access 2002 XP version and Informix SDK 2.81. This installs ODBC 3.82. ...
  3. #2

    Default Re: Oracle ODBC Timeout issue

    I was able to resolve this problem by downloading the new JDBC drivers mentioned in this Tech Note:

    [url]http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=1a3c2ad0[/url]

    Michael
    MichaelXMongeau Guest

Posting Permissions

  • You may not post new threads
  • You may post replies
  • You may not post attachments
  • You may not edit your posts

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139