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

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.
LVL 4
ThirtAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

mirtheilCommented:
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
ThirtAuthor Commented:
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
mirtheilCommented:
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Databases

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.