I have a 32-bit application and tried to create a System DSN for SQL Server using the 32-bit ODBC ( \Windows\SysWOW64\odbcad32.exe ) - but encountered the error "SQL Server does not exist or access denied".
I then used the 64-bit ODBC System DSN, and the connection was successful. I also tried the 64-bit ODBC User DSN and it was also successful.
I then went back to the 32-bit ODBC and under User DSN found the entry which was created when connecting with the 64-bit User DSN previously. Unfortunately, this User DSN also failed when I tested it.
Does it succeed while click “Test Data Source” button at the time of creating a System DSN using 32-bit ODBC? What is the full text error while the test failed? According to the error message, it seems the ODBC provider is worked and it generates
an error while it tries to connect to the SQL Server. Since it is a generic issue and there are many potential causes on this KB article:
Is the application developed by .NET? Could you please make sure that it is 32-bit? For 32-bit application, it is not available to connect data source with 64-bit provider.
You are using 64-bit operation system, right? Since 32-bit version of the ODBC Administrator tool and the 64-bit version of the ODBC Administrator tool display both the 32-bit user DSNs and the 64-bit user DSNs on 64-bit operation system, please also check
that you are using the right provider. For more information: