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

Error setting up ODBC datasource for Btrieve 6.15 files on Win2000/XP

Error setting up ODBC datasource for Btrieve 6.15 files on Win2000/XP

Error setting up ODBC datasource for Btrieve 6.15 files on Win2000/XP

(OP)
I'm getting the following error when trying to set up an ODBC data source for Btrieve 6.15 files on Win 2000 & Win XP machines:

"Login must succeed before data source entry can be written (Status code 802)"

I'm using Pervasive ODBC Interface 2.01.  Is there possibly another interface that will work with Btrieve 6.15 on a Win 2000 or Win XP machine?

RE: Error setting up ODBC datasource for Btrieve 6.15 files on Win2000/XP

An error 802 means that that the ODBC could not connect to the Scalable SQL engine.  With Btrieve 6.15, the SQL engine is part of the ODBC driver so you're most likely running into a "Target Engine" issue.  You need to make sure that any Scalable SQL "Target Engine" settings are set to 0 (zero) in the registry. If you're using the Btrieve Workstatio engine, all of you Target Engine settings should be set to 0.  

info@mirtheil.com
Custom VB and Btrieve development.
Certified Pervasive Developer
Certified Pervasive Technician

RE: Error setting up ODBC datasource for Btrieve 6.15 files on Win2000/XP

(OP)
Thanks for your assistance.  I made the change to the Target Engine key in the registry.  Now I'm getting the same text message: Login must succeed before data source entry can be written.  HOWEVER, now the status code is 20.

Any ideas?

RE: Error setting up ODBC datasource for Btrieve 6.15 files on Win2000/XP

The status 20 means that the Btrieve Engine is not available.  Do you have a Workstation engine or Client installed on the machine with the ODBC driver?  If so, set the Btrieve Target Engine to 0. If you've got the Btrieve Server Engine installed on the machine where the ODBC driver is installed, you should set the Target Engine to 1.

info@mirtheil.com
Custom VB and Btrieve development.
Certified Pervasive Developer
Certified Pervasive Technician

RE: Error setting up ODBC datasource for Btrieve 6.15 files on Win2000/XP

(OP)
Thank you very much!  That did the trick!

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