×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

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.

Students Click Here

Status 20 Odbc

Status 20 Odbc

Status 20 Odbc

(OP)
Problem:

Trying to add a new system DSN returns error 20 on a serverbased pervasive v7.
Normally I would start the Scalable SQL service on the NT4 server in question but this is not an option since it´s "rocking the boat" for another crucial application.

The ODBC call is made from a win98 client without pervasive workstation engine.

Thankful for hints and ideas!

RE: Status 20 Odbc

error 20 is Btrieve not loaded.  There are a number of things that can cause this.  I would check out pervasives website for this.  I can email you a Btrieve not loaded checklist, but it is unique to Macola software so some of the items on there may not apply.

Software Training and Support for Macola, Crystal Reports and Goldmine
714-348-0964
dgilsdorf@mchsi.com

RE: Status 20 Odbc

(OP)
Thanks for the attention "dgillz"

Clarification of previous posting.

I´m trying to create a system DSN for ODBC connection to a pervasive 7 database which is serverbased. The original application that is using the database is Scala(ERP). Even if Scala is running on the client (Pervasive loaded) I still get the "Status 20" attempting to add the DSN.

Since I can´t use the Scalable SQL Service on the server my conclusion is that if I use an ODBC driver that is a bit old (2.50 or earlier) the call would pass through without the support of the Scalable SQL Service.

But still Status 20!

Please send me the checklist for loading btrieve locally
email: erikewing67@hotmail.com

RE: Status 20 Odbc

Can't use SQL on the server?   Now I am confused.  You must have the database on the same server as Pervasive.   If you have two servers, you cannot have Pervasive running on server A and the data on server B.  You may also want to look into setting the protocol.  Go into Setup(32) and select the Communications Requester then Supported protocols. Then delete the protocol(s) that you do not use to communicate with that server.

RE: Status 20 Odbc

We were running Scala on Pervasive v7 and had no end of problems making the ODBC work, status 20 being one of the many problems. Following advice from Pervasive we upgraded to pervasive 2000 and it all works fine.

RE: Status 20 Odbc

(OP)
Problem solved!

Used a different odbc-driver. Merant/Data Direct.

Everything is working like clockwork.

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