[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

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

Posted on 2004-11-21
3
Medium Priority
?
1,653 Views
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.
0
Comment
Question by:Thirt
  • 2
3 Comments
 
LVL 18

Accepted Solution

by:
mirtheil earned 2000 total points
ID: 12668749
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.  
0
 
LVL 4

Author Comment

by:Thirt
ID: 12671373
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?
0
 
LVL 18

Expert Comment

by:mirtheil
ID: 13183507
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.
0

Featured Post

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft Access is a place to store data within tables and represent this stored data using multiple database objects such as in form of macros, forms, reports, etc. After a MS Access database is created there is need to improve the performance and…
In this article, we’ll look at how to deploy ProxySQL.
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…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
Suggested Courses

834 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