Skip to Content

ODBC Connection

Hi

I try to connect via ODBC to an ADD. I always get an error message:

There was an error reading DSN information from the registry.

I tried ver 11 and 12, same error, my OS is Win 10 Pro, ADS server is version 12.

It seems to work with ver 10 on other machines.

Anyone has any ideas how to solve this problem.

Regards Marcus

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Oct 25, 2017 at 03:29 PM

    Did you - by chance - mix 32Bit ODBC with 64Bit Windows?

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 26, 2017 at 08:40 AM

    No. I am aware of that. But Win10 has 2 different items for 32 and 64 bit (Not like Win 7). Actually I tried both. I think the ODBC driver has to match the program that is loading ODBC, it does not depend on the OS, right?

    With the ODBC 32 bit and Access 32bit driver I can:

    set up a connection using local engine and local disk. It works, But no remote connection to an ADS server

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 27, 2017 at 02:23 PM

    Yes, the bitness of the DSN needs to match that of the application. However, in Windows 10, this doesn't seem to work the way we would expect.

    I tested this with MS-Query and took a Process Monitor trace.

    Although MS-Query's dialog saw User DSNs, it did not search the HKCU section of the registry when trying to connect, and so returned an error.

    When I created a 32-bit System DSN, Process Monitor showed MS-Query finding the registry entry, but then querying the 64-bit section of the registry as well, and failing when it didn't find the DSN.

    If I removed the 32-bit DSN but kept the 64-bit one, 32-bit MS-Query didn't display it in the connection dialog.

    The only combination that worked for me was a 32-bit System DSN, with an identical 64-bit System DSN.

    This seems to be a change in behavior in Windows 10 or MS-Query, since it happens before the ADS ODBC dlls are loaded.

    Regards,

    Mike Loop
    Senior Support Engineer
    SAP Product Support

    Add comment
    10|10000 characters needed characters exceeded