asked on

How to setup an ODBC between MS Access and Peachtree

I am trying to create my ODBC connection to Peachtree to retrieve data and do some statistical processing. I don't have control or setup of the Peachtree File Server but was given a server file path name (use \\myserver\mycompany\mypeachtree where mypeachtree is the folder that holds the Peachtree files. I was also given a user name and password that was setup ( I was told) as the "only access" for ODBC.

In following the attachment I don't get the same screen shot as show in step 6. Also when I try to use the \\myserver.... in the adress it will not create. I get an error in the pvsw.log of "Btrieve server not found. PNSL open session by name returned status = 3103."

What I need to know is
1. was there not something not completed on the Peachtree side that I need to go back to that group with
2. What am I missing on my side in information to correctly setup a ODBC that works between MS Access and Peachtree
3. Do I or does Peachtree group need to use a Pervasive server to get this to work.
4. Can someone provide me the steps needed to setup the ODBC successfully?
I have setup other odbcs in the past between MS Access and SQL and Oracle but this Pervasive database has be baffled.

I have downloaded for my client pervasive driver the PSQL-Client-10.30.022.000-win.x86
Sage-Peachtree-ODBC-access.JPG
PeachTree-ODBC-setup.pdf

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

gilnari

ASKER

Absolutely perfect information. I suspected as much however I don't have access to the server I am trying to gain access, nor is the consultant doing the install understand this is a critical step that is needed. You have given me the informaiton I need to take back to the other consultant team they are not done with their side of configuration.

Thank you and experts-exchange reminds me once again this is the best place to get answers and keep your projects moving forward when you get into a pickle