Pervasive SQL run-time error 75 path/file access error

Posted on 2004-11-21
Last Modified: 2007-12-19
Installing an application in Windows Server 2003 Terminal Server. The application uses Pervasive SQL client which I think is having problems when the users logs into the Terminal Server. When the user runs the application, get the error Run-time error 75 path/file access error. The only thing I could find close to this in Google is that the log file for Psql writes to C:\ and sure enough, the user doesn't have write access to C:\. I have no idea how to change this with PSQL.
Question by:Thirt
    LVL 18

    Accepted Solution

    First off, let's make sure that it's pervasive returning that error.  
    Open the Pervasive Function Executor and open "C:\PVSW\DEMODATA\CLASS.MKD" (or any Btrieve/Pervasive data file for that matter). Does that return an error?  If not, then the 75 is coming from the application is is an application issue not a database issue.  
    LVL 4

    Author Comment

    I followed your directions and I don't think I got an error. I'm not familar with this tool, and it opens what appears to be a hex editor. I'm I suppose to press exectute to do something and test for the error?
    LVL 18

    Expert Comment

    Actually, if you get a "hex editor" on the screen, then the file opened correctly and you are looking at the binary result from the Btrieve API call.  If you don't get an error with Function Executor, then the problem is in the application.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Join & Write a Comment

    Introduction: Often, when running a query with joins, the results show up "duplicates", and often, those duplicates can be "eliminated" in the results using DISTINCT, for example. Using DISTINCT is simple: just add it after the SELECT keyword, an…
    Shadow IT is coming out of the shadows as more businesses are choosing cloud-based applications. It is now a multi-cloud world for most organizations. Simultaneously, most businesses have yet to consolidate with one cloud provider or define an offic…
    Video by: Steve
    Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
    Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

    733 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    24 Experts available now in Live!

    Get 1:1 Help Now