2 Replies Latest reply: May 14, 2014 2:37 AM by benton RSS

    ODBC connection issues

    benton

      OS Win7

      Microsoft Office (32 bit)

       

      On recently acquiring a new computer I installed the latest version of SQL Developer and set about to make a connection to an MS Access DB.

       

      I received the following errors from the following SQL Developer Versions;

      4.0.2.15 returns error "Status : Failure -Test failed: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified"

      4.0.0.13 returns error "Status : Failure -Test failed: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified"

       

      Some investigation lead me to re-install a previous version of SQL Developer (3.2.20.09.87) successfully allowing me to connect to MS Access.

       

      Is it possible to connect to 32 bit MS Access using the latest versions of SQL Developer or is my issue something different?

       

      Regards

      Ben