Why does the ODBC connection call fail when connecting with Access?

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Lucy Lane

    Why does the ODBC connection call fail when connecting with Access?

    I get: [Microsoft][ODBC driver for Oracle][Oracle]ORA-06413: Connection not open. (#6413) [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAt tr failed IM006 0 [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAt tr failed (#0)

    Don't really know what this means.
  • Stewart Ross
    Recognized Expert Moderator Specialist
    • Feb 2008
    • 2545

    #2
    Hi. It is difficult to advise you on this one as you don't tell us the context in which this error has occurred.

    It is possible that you don't have the relevant ODBC driver for Oracle set up on the machine you are using. Or, the ODBC driver may well be present but the username or password (if that is how it is set up) is now invalid.

    I'd suggest that your first step should be to check whether or not you can connect successfully using the ODBC driver itself. Dependent on what version of Windows you are using you'll probably find this by going to Control Panel, Administrative Tools, and Data Sources (ODBC). Look for either a System or File DSN entry relating to your Oracle server instance and test the connection from there. If you can't find an entry then you clearly don't have an ODBC connection set up as yet on the PC you are using.

    If you can connect successfully from the ODBC administrator software you know that there is no inherent connection problem, in which case the Access connection is either using the wrong username or password (if applicable).

    If you can't connect via the ODBC administrator there is a more fundamental problem with your connection - either you are unable to establish a connection to the server concerned, or you are being denied access (possibly through incorrect connection parameters or changes made administrativel y at the server end that have not been made at your end (the client end) of the connection).

    You'd need to refer 'can't connect' issues relating to the fundamental connection to your Oracle system to your system administrators for resolution.

    -Stewart
    Last edited by Stewart Ross; Nov 20 '10, 08:38 AM.

    Comment

    Working...