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
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
p.s peachtree is of no help on this one.
RE: Pervasive data from Peachtree Quantum 2008
Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician
http://www.mirtheil.com
RE: Pervasive data from Peachtree Quantum 2008
kb
RE: Pervasive data from Peachtree Quantum 2008
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
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
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
RE: Pervasive data from Peachtree Quantum 2008
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
RE: Pervasive data from Peachtree Quantum 2008
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
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
h
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?"