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

Btrieve required permissions

Btrieve required permissions

(OP)
We are accessing a Pervasive SQL 7.0 database using BTRVID calls from IIS with ASP. The ASP calls a VB dll that issues the BTRVID. Everything works fine - except that I must give explicit permissions to the database file directory (which is on another server in the domain - the web server is not part of the domain) or else I get Status 94 errors. I would like to avoid this - I know that when using the SQL relational engine no explict permissions have to be given to login to the database - is there something similar on btrieve side ? If not, what is the most secure way that I could set up the permissions from the web server to the data server ?

RE: Btrieve required permissions

With Pervasive.SQL 7.0 and the Btrieve API, you must give explicit permissions.  Btrieve does not have the concept of databases or logins and uses the Operating System for permissions to the file.  
WIth Pervasive.SQL V8.5 (Security release), this has changed. Now Btrieve and SQL can use the same security model and Btrieve can be told to "login" to a database using database security and eliminating the need for explicit permissions on the files.

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

RE: Btrieve required permissions

(OP)
Thanks for the response !

Upgrading to v8 is not possible at the moment.
Do you know of any safe way (as safe as possible given that I must give file permissions) to allow access to the files from the web server ?

RE: Btrieve required permissions

Is the data being changed?  If not, then give only read only rights to the user.  If so, then you're just going to have to give them enough rights to do what needs to be done.

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

RE: Btrieve required permissions

(OP)
It's read and write - i have been doing some tests today with the MapNetworkDrive of the WScript component (without actually mapping a drive but passing the server\share and user & password of an account on the domain that has change permissions only in the data directory). This seems to work - no more 94's and from the web server no one can access the data server since the MapNetworkDrive is being done within the context of IIS. I hope this is secure enough and the network admins won't flip

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