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

Pervasive SQL Config problem?

Pervasive SQL Config problem?

(OP)
We are the developers of TRIMS, a program distributed with Btrieve 6.15 workstation engine.  One of our customers is using it with Pervasive SQL 8 WorkGroup Edition and is experiencing problems with one workstation.

Please read problem description below.
Anyone have an idea as to what's happening?

Lee

==================
Data files reside on an NT4 server.
 
All of the client workstations have a mapped drive pointing to the Trims2k share on that server.
 
All of the 4 clients at the maintenance shop point to that server for the Trims data.  

None of the clients including Linda have any data on their PCs.  

Everyone can work normally whether or not Linda’s PC is turned On or Off.

If Linda starts Trims first then she and everyone can work normally but if anyone else starts Trims first then everyone but Linda can work.  

If Linda’s PC is powered off for a week everyone can work fine because Linda’s PC is not where the data is...data is on the NT 4 server.  

If everyone has their PCs on and not in Trims then Linda can start Trims without any problem or if everyone else gets out of Trims then Linda can start Trims without any problem.

==================================

RE: Pervasive SQL Config problem?

Sounds like you've got multiple engines accessing the data. Is Linda's PC the only one with the V8 Workgroup engine?  If so, that's the problem.  Everyone else is using 6.15 and the two engines can't access the same data at the same time.  

Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician
Custom VB and Btrieve development.
http://www.mirtheil.com

RE: Pervasive SQL Config problem?

(OP)
mirthiel:
I've been told that all workstations are using PSQL.

That's the first thing I thought of.  We distribute the 6.15 library but customer has installed PSQL.

It is possible that customer reinstalled our software and overwrote some of the PSQL routines of same name as Btrieve 6.15 components in Windows\System32 folder.

I'll have them reinstall psql on Lindas machine.

Lee

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