Accessing a data source using ODBC

Q: We access our ERP database via an ODBC driver. I have it loaded as a SystemDSN. I can link to the database with Excel and Access successfully.

When I go in to PIESCentral > Import Sources, I do not see the ODBC driver I have in my SystemDSN. Is there something I need to do in order for PIESCentral to use the ODBC driver?

A: For a SystemDSN, choose ODBC-DSN as the source type. You will need to type in the DSN name.

Revised: 2010-03-31