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.
... View more