×
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!
  • Students Click Here

*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

Jobs

Connecting with Access or Excel
2

Connecting with Access or Excel

Connecting with Access or Excel

(OP)
I can connect to every table but the Customer, JrnlHeader, and JrnlRow tables.  I get an ODBC error when trying to link to the customer table.  I can link to the jrnl tables but the data just shows #error in every field.  Has anyone seen this before?

Win2K
OfficeXP

RE: Connecting with Access or Excel

How are you establishing the ODBC link?  I've tried Pervasive Btrieve without success.  

Bill Chambers

RE: Connecting with Access or Excel

Hi dg,

Yeah I read that.  Have you gotten the ODBC connection to work based upon those instructions?  I have not. If there are more detailed instructions available, I'd sure like to know. (There is always the possibility I'm being dense. <g>)  

Bill Chambers

RE: Connecting with Access or Excel

Connecting via ODBC was easier then I imagined.  The only thing you do is install a recent copy of Pervasive SQL.  I'm using Pervasive SQL 8 Workgroup Engine (which costs $25).  Once that is installed go to your ODBC control panel, click the system tab, then add a new connection.  The driver to use it the Pervasive Engine (not the client).  Call the connection whatever you like, then create a new database...browse to your ddf files.  Mine where in c:\peachw\ under my company folder.  That's it I believe.  Ok out of there, and it's ready to go.  Enjoy!

RE: Connecting with Access or Excel

Hi Flimpo,

Maybe I have the wrong version of Pervasive... I've ordered my copy of the Pervasive SQL 8 Workgroup Engine.    

thanks,

Bill Chambers
Fairfax, VA

RE: Connecting with Access or Excel

Hi Flimpo...

Right on the money!  Just installed P SQL V8, followed your steps and it works great!!!

thanks,

Bill Chambers
Fairfax, VA

RE: Connecting with Access or Excel

Hi Luceze,

Your original question about accessing JrnlHdr, JrnlRow and Customer:  I just installed Pervasive SQL V8 (as you gather from earlier in the thread) and I am able to acees all tables (except Linetems when I try "SELECT * ..." -- to many fields).

One nice thing about the Pervasive SQL V8 Workgroup Edition is the SQL Datamanager that comes with it.  The SQL DM allows you to query the tables directly.

Bill Chambers
Fairfax, VA
 

RE: Connecting with Access or Excel

(OP)
I'm going to order that right now.  Just one more question.  Does the software need to be installed on the server where the data files are or just on the local workstation?

RE: Connecting with Access or Excel

Hi Luceze,

I beleive it needs to be installed on each workstation.  

Bill Chambers
Fairfax, VA

RE: Connecting with Access or Excel

(OP)
Thanks Bill.

RE: Connecting with Access or Excel

Hi, dgillz
Did you try to delete or change anything in PT tables? It is easy to try just write delete or update statment in Pervasive SQL Datamanager. Problem I had that I was getting error message (error code 46 - Access denied) Any idea how to bypass it?

RE: Connecting with Access or Excel

(OP)
Hey dgillz,

Everything was working fine until today.  Now I get BTrieve error 51 on every table but the company table saying that the owners name is invalid.  Do you know if I accidentally changed a setting or something?

RE: Connecting with Access or Excel

Luceze,

Try posting this is the Pervasive and/or btrieve forums, there are some btrieve gurus there that I am sure can help you get this sorted out.

Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports
www.trianglepartners.com
dgilsdorf@trianglepartners.com

RE: Connecting with Access or Excel

Hi dgillz
Yes, ODBC is not read-only. I suppose you never tried to modify (update/delete) in any PT table?
To luceze
I think you didn't change any setting. Before you were just browsing data in a tables and today you tried to modify records in tables and got error message. As far as I could find problem is in owner name. It is password that PT put on btrieve files. Through their ddf you can only see some fields in records of some tables but you can change nothing if you don't know owner name.

RE: Connecting with Access or Excel

I download free copy of PSQl 8 and try to run. I can browse the ddf but don't know how to create the report. Anyone can help.

Are PSQL same with PAWCOM.

Regards

RE: Connecting with Access or Excel

Hi All,

I followed the instructions and suggestions in this thread to successfully connect to a peachtree database via ODBC.  However, I am experiencing the same problem as luceze with accessing JrnlRow.  I get a locking error.  The only time I can successfully access this table is when all users exit out of the peachtree application.  Since I only need to query this table (no inserts or updates), is there anything I can do to be able to query this and other tables while users are connected via the peachtree application?

Thanks in advance.

RE: Connecting with Access or Excel

Wow thanx a bunch...thats exactly what i was looking at.

Thanks,     PAUL

RE: Connecting with Access or Excel

nexpress,

did you ever figure out how to update records?

thanks,

-Sam

RE: Connecting with Access or Excel

Hi meph,
Looks like you can update it only with PawCom.
"...Despite Craig's rather cryptic comment it is pretty easy and reliable to get Peachtree data into MS Access with PawCom.
You don't need ODBC - the PawCom object library makes direct calls to Peachtree's Btrieve files in exactly the same way that Peachtree itself does.

Bob Walraven
Architect of PawCom"
 http://multiwareinc.com/pawcom.htm)

RE: Connecting with Access or Excel

Nexpress,

I actually got updating to work ( I am using the latest Pervasive engine, 9.1 ). I initially tried to update the record in place in the results display grid in the Pervasive Data Control Center application, and I was ( and still am ) getting the '46' error.Thats when I posted to this thread. But later I tried using a query to update the table, such as INSERT or UPDATE, and that seems to work fine....

RE: Connecting with Access or Excel

That's interesting! I tried trial Pervasive (but don't remember a version) and it didn't work. Are you working with commersial Pervasive or trial version?

Thanks

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