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

ODBC from Btreive. Access 97

ODBC from Btreive. Access 97

(OP)
I am having some issues with extracting data from a btreive Database.

Using Access 97 to Extract data from a Btreive database.  This worked fine before all the passwords on the domain changed, the Btreive ddf files are on a member server and the ODBC is on another server, using mapped drive to extract the info, running the make table query and get the error "Login Must succedd before data source entry can be written" Status code 2103. The database has no security on it which would require a login, has tried mapping a drive as the administrator, but still get the same errors.

Does anyone have any ideas.
 

RE: ODBC from Btreive. Access 97

What version of btrieve are you using?  Are you using a DSN on the client PC to connect to the data?

RE: ODBC from Btreive. Access 97

(OP)
Hi

We are using Btrieve v 7.0 and a System DSN on the Client PC.

RE: ODBC from Btreive. Access 97

It sounds like it's a rights/permissions issue with Pervasive on the server more so than on the client PC - if your're using an NT/2000 environment you might go to your databe and give it "every one/full control" and see can you create the table then.

RE: ODBC from Btreive. Access 97

(OP)
I have changed the permissions on the DB directory, to everyone Full Control, but still seem to be getting the login error message.  The log file doesnt give any errors, on the client or server, it only indicates that resources are being allocated or realased.  

RE: ODBC from Btreive. Access 97

A status 2103 indicates that the SQL engine couldn't be loaded.  Can you use SQLScope from these machines?  If not, are you also getting a 2103?
Also, what are the "Target Engine" settings set to on the server where ODBC is being run?  

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

RE: ODBC from Btreive. Access 97

(OP)
Using SQLScope on one client give the error message 2103, but running it on the server where there database is, gives the a 802 error, the Target Engine is set to (1) Have checked the services on the server and Sql Scable service i running

RE: ODBC from Btreive. Access 97

(OP)
I am still getting the error using the SQlscope on the client, managed to VPN on to the Server and can use the Sqlscope and create new ODBC connections without any errors, however still getting the 2103 error using the client.  We have about 20 connecrtins to these databases and none of them work.  Any more ideas.....  

RE: ODBC from Btreive. Access 97

The TargetEngine on the Clients (assuming they are WinNT/Win2k/WinXP) machines needs to be set to 0.  

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

RE: ODBC from Btreive. Access 97

(OP)
Hi

I have managed to resove the issue, the server had had its network cards replaced the new ones were bound together using different IP addresses, unfortunlaty i am based in Vancouver BC and the server is in Newcastle, England, so a bit difficult to get things changed.

Many thanks for you 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!

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