Need to learn how to use my Pervasive SQL9 database and connect it via ODBC.
Trying to create excel reports and access 2007 to analysis our data from this database system.
Currently we are using Small Business Server 2003 using the Pervasive SQL9 software as our database for Magic eDeveloper 9.4 as our production system. Normally I retrieve data using Crystal Reports by using DDF files thru Betrieve connection.
But trying to improve some reporting to utilize Excel & Access 2007 to connect to this Pervasive SQL9 database.