02-03-2009 02:19 PM
10-17-2013 12:24 PM
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.
10-17-2013 02:54 PM
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.