INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

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.

Jobs

Pervasive data from Peachtree Quantum 2008

Pervasive data from Peachtree Quantum 2008

(OP)
We are currently using Pervasive with OLE DB to extract data from our Peachtree 2006 data files into our own database for reporting purposes.  We just purchased the Peachtree Quantum 2008, and in testing the same process have found that we cannont connect to the Peachtree files.  We are getting a logon and password prompt and nothing we try seems to work.  Has anyone been seen this or been able to connect to the Peachtree files after the 2008 upgrade?  We tried using Pervasive 10.0 and that does not resolve the issue.    

RE: Pervasive data from Peachtree Quantum 2008

Sounds like Peachtree Quantum added a user/password.  If that's the case, you'll need the user/password for it from Peachtree.  
What error do you get if you don't put a user/password for the connect?

Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician
http://www.mirtheil.com

RE: Pervasive data from Peachtree Quantum 2008

(OP)
Error   java.io.IOException:  could not connect

p.s  peachtree is of no help on this one.  

RE: Pervasive data from Peachtree Quantum 2008

What about through OLEDB?  DOes it give anything else?

Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician
http://www.mirtheil.com

RE: Pervasive data from Peachtree Quantum 2008

(OP)
Just asks for login name and password.  I am pretty sure you are correct and Quantum has added a security password to the database file.  I am going to try to talk to them again,  maybe this time I will get someone there that has a clue.  Thanks for your help.

kb

RE: Pervasive data from Peachtree Quantum 2008

Did you make any progress on this kjobob?  I'm in the same boat - upgraded from PT Complete 2006 to 2008 and now locked out from my Pervasive connection.  

That connection was a wonderful tool - so much access to information and reports that PT fails to provide.  It was important enougth that we will probably go back to using v2006 adn keeping the connection via pervasive.

Thank you.

RE: Pervasive data from Peachtree Quantum 2008

Just curious why you extract data from Peachtree file to your own database to report.  Why not report directly from the Peachtree files?

www.peachtreeuser.com is a good resource, you might ask there about this issue.  There is also a Peachtree forum here at tek-tips.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports
www.gainfocus.biz

"What version of URGENT!!! are you using?"

RE: Pervasive data from Peachtree Quantum 2008

Thanks for the tip on the other forum.  I am registered there too and use it occasionally.

As to why we use Access: a couple of reasons.  First, Access report writing is far easier than Crystal and more versatile than PT.  

Second, we have additional tables that link to the Peachtree inventory items.  In those tables, we have much more information about our products.  From this, we can upload to our website store, create product lookups of every imaginable kind (whereas Peachtree only allows lookup by item number or description); and it allows for verification of accurate and complete synchronization of the PT and website data.

As for the original issue w/ Pervasive, here's some more info for anyone who can use it or respond to it:  Peachtree says there is no username or password, but that this connection from PervasiveSQL control center just no longer will work.  (Skeptical, I am...) They say to download/ use SDK 3rd Party add-on and use that as the link.  I'll be trying that...


Matt

RE: Pervasive data from Peachtree Quantum 2008

(OP)
We have been the rounds with Peachtree on this, I downloaded the SDK and am not impressed.  It uses a comm object that is so old technology, it would require that we totally rewrite all of our downloads.  what a pain.  They have put a password on all of the files, they told me such.  Each file has its own password (to protect us from ourselves they say) thank you Enron).  We have not figured out how to get around the password yet, but would love to hear any suggestions.  kjobob

RE: Pervasive data from Peachtree Quantum 2008

I don't mean to start any arguments here, so I will just post this and move on: If you think Access is easier than crystal, you need to spend some quality time with crystal.  Also crystal can mix data sources.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports
www.gainfocus.biz

"What version of URGENT!!! are you using?"

RE: Pervasive data from Peachtree Quantum 2008

(OP)
Sorry Dgillz  I missed your question about reporting directly out of Peachtree.  We do reporting for about 20 companies and we download the data into tables so we can can provide and enterprise wide reports package to the owners.  A lot of work, but nice for management.

RE: Pervasive data from Peachtree Quantum 2008

No arguments here...I just personally find crystal both expensive and difficult.  Just can't get my mind around it like good ole' VBA script and Access.

Anyway, before the self-protecting passwords on the PT files, that Pervasive link was sweet.

Kjobob: agree with you comments on the SDK.  I cannot believe they suggested that as an alternative to our previous setup.  I wish I had suggestions on getting around the password but that's over my head.  Help anyone???

RE: Pervasive data from Peachtree Quantum 2008

I did find a firm that is authorized by PT to remove/ reset for password to allow Pervasive ODBC access.  See www.goldstarsoftware.com.  I corresponded w/ Bill Bach who very nicely explained the process and fees.  Its $250/ database.  

Unfortunately, that's more than I can justify investing in this, so I'm sticking with PT 2006 and writing PT a strongly worded letter.  

We all need to badger PT about this.  They can't blame this on Sarbanes Oxley.  Many accounting systems remain open systems and allow, at a minimum, read-only access.  And I suspect that PT is not being used by too many publicly held companies.  

RE: Pervasive data from Peachtree Quantum 2008

Peachtree advertises their own product as working with crystal, which uses ODBC:

http://www.peachtreebuyers.com/products.asp?dept=18

They could have a proprietary ODBC connection that works only with Crystal Reports, I have seen this with other packages in the past.  I would ask the question how Quantum uses Crystal and see what they say.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports
www.gainfocus.biz

"What version of URGENT!!! are you using?"

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!

Resources

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