Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Peachtree - pawcom, odbc, how to get data from PT

Peachtree - pawcom, odbc, how to get data from PT

Peachtree - pawcom, odbc, how to get data from PT

Hi all -

I've read thru most of the threads here on PT - here's my situation...

I have a ticketing system I am finishing up for a client in .asp/sql2000.  The client is now asking that I pull all customer and inventory data from their PT system when creating service requests, and later entering general ledger records when requests are closed.  

I have set up a nightly batch process to pull exports of the customer list from pt, as well as their inventory master, importing into sql to deal with the routine searches on equipment availability and customer accounts.

My next step is to (1)perhaps pull the customer/inventory data right from PT, and (2)write the data back to PT directly, versus a DTS process to export out ledger records for importing back into PT.  It'd be much easier to just dump in at the transaction level into the PT file, as well as give realtime access to inventory and customer control.

Most of the documentation for pawcom revolves around using MSaccess as a front-end - I am more interested in utilizing the com object to access the data directly.  

Enough of my blabbing - to access the data, am i able to directly access the customer/inventory/ledger info, and if so, which files represent that data (I am a total newb to PT, and documentation really leaves a lot to be desired)

If possible, could someone post up a sample chunk of code that might get me started?   
Thanks in advance for any help!!

RE: Peachtree - pawcom, odbc, how to get data from PT

As you are probably aware, the PT database is a descendant of Btrieve and currently lives in Pervasive.SQL (latest version right now is 8.6).

You can access the db files directly if you download the workgroup engine (free) here:

Once you have this engine installed, you can use VB (or other languages you may have) in the same manner you would for an access db etc.  You can even use the adodc and datagrids; just specify the Pervasive ODBC engine interface installed with the engine.

They even have sample code and excellent documentation.  I have implemented the samples in Visual Studio and found no bugs.  If you have a bad taste in your mouth over Btrieve from past experiences (i did) you can rest easy.  The bugs are gone.

The code is clean and will get you started.

As to the names of the files, I have no clue.

Hope this helps, James May

RE: Peachtree - pawcom, odbc, how to get data from PT

I know you can access customer and I am pretty sure you can get inventory and ledger data.  

The real answer to your question is, if you look in the P-Tree documentation either with the system (if the help was installed) or on their web site, there is reasonable documentation about table and field names.

It is not perfect and there are sometine holes in it but I have found it gets you pretty close.

RE: Peachtree - pawcom, odbc, how to get data from PT

Have any of you ever had problems with not being able to link to a specific table.  I am using MS Access as a front end, trying to draw data from PT.  I can see the data on the Pervasive Control Console; tables etc, but when I try to link to the tables via Access ODBC, I get an error message - Invalid field definition 'JournalGUID' in deinition of index or relationship.

I get this for the JRNLHDR and JRNLROW tables, which keeps me from progressing any further.

I have Pervasive SQL engine V8 set up.

Thanks for your help.


Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close