Late post i just realized. But that's totally a SAS/ACCESS to ODBC issue. You need a driver manager and the proper driver to the database you intend to contact.
As an additional, yet important note: Depending on if this is a server installation or not, you will also need to deal with what sort of user/pass credentials your db uses. For security purposes, many companies are going, or have gone to using ldap to authorize users. For example, if you are in an environment that requires you use a user/pass from an active directory (ie single sign on / SSO) that will need to be considered when configuring ODBC connection parameters to those data sources. This as we've found can be a big deal and all efforts should be made in checking through these requirements first as any single source of information on how to set this up is not to be found.
It would be helpful to know what operating system you are using with SAS and what database you are trying to connect to. If you are using Windows then you can configure/test ODBC connections in the ODBC Administrator tool of Windows Control Panel. It will also list what ODBC drivers you have installed.
Still, the error implies that there something missing in the installation, not any ODBC manager configuration issue,
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.