Migrated SAS 9.4 to Windows 10 server.
Keep getting this error when trying to assign a libname to an ODBC source.
The specified DSN contains an architecture mismatch between the Driver and Application
As far as I know the admin has set up the ODBC 64bit driver.
Is there something else that has to be done?
Make sure where the LIBNAME executes has the proper version of the drivers as well as the source.
Be default a LIBNAME expects to be able to write to the destination. Does your ODBC setup include write functionality? It might be setting for the specific source. ODBC settings are very much connection specific in the Windows world (haven't used ODBC anywhere else so not sure) so make sure that you understand the settings and reference the correct connection.
Any ODBC data source name likely needs to be completely redefined. And the features of the drivers have very likely changed from Windows 7 to 10. Are any other programs able to access the ODBC source(s)? If not, then I would start with the definitions.
Then you get into the specific LIBNAME options which can depend on the specific ODBC source. So maybe some more details are in order.
What bitness is your SAS 9.4? It must be the same as your ODBC drivers.
Looks like bitness matches, but there is still an architectural difference with your ODBC driver. I'd raise the error with your SAS administrator. I assuming here that your SAS runs on a remote Windows server.
ODBC is now working.
Thanks to all for the direction. Creating the registry entries for ODBC was all that was needed (something that was apparently not done). It seems that ODBC calls assume default settings when those are not defined.
In my experience, installing the ODBC driver would update the registry but perhaps there was some permissions issue preventing this.
The SAS Users Group for Administrators (SUGA) is open to all SAS administrators and architects who install, update, manage or maintain a SAS deployment.
SAS technical trainer Erin Winters shows you how to explore assets, create new data discovery agents, schedule data discovery agents, and much more.
Find more tutorials on the SAS Users YouTube channel.