asked on

How to add ODBC Data Source to Pervasive SQL?

Hello - I could do this in Access 2003 under Windows XP with no problem, but since switching to Windows 7, the same process does not seem to work (still running Office/Access 2003).

Pervasive version is 10.30.17 (both client and engine)

Can somebody point me to a reference source?

Thanks

Mark

PatHartman

Did you switch machines so that you are now running a 64-bit OS rather than a 32-bit? If that is the case, you may need to download a new driver.

mlagrange

ASKER

Computer properties shows Windows 7 Professional, SP1, 32-bit

SOLUTION

Bill Bach

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

mlagrange

ASKER

ok, thanks Bill, but Too Much Information... all I want to do is create an ODBC data source.
Right off the bat, from the ODBC Administrator, Create New Data Source dialog, which Interface should I select? The Client, or the Engine? (I am trying to create a File DSN, so I can copy this out for the network admin's to use)

ASKER CERTIFIED SOLUTION

Bill Bach

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

mlagrange

ASKER

Thanks Bill - I tried all 6 combinations (client, engine interface; user, system file dsn's), and the only one I was able to get through without error was creating a user dsn using engine interface.