connect to Interbase DB from Web-server

Hi!
I am trying to connect to Interbase DB from Web-server. I have TSQLConnection on my WebModule. When I set prop "connected" to true at design time, it goes to it perfectly. But when I put a string in a service function and activate this function with sertain client I see error message "Access violation at address ….". What is wrong?
I tried SGI and ISAPI no change. I learned – access permissions to DB or/and IIS configuration are mattered. I searched the entire Internet but couldn’t find clear (for my level) instructions what to do or explanations what is the reason.
Somewhere in the NET I've found the fraise: "the IIS user account needs proper permissions to the database file & folder", but I cannot make sense of it.
If anyone could be nice to tell me the truth I would appreciate it very much

Average rating
(0 votes)
Brashquido's picture

Location: Melbourne, Australia

Joined: Sep 2003

Send PM

Brashquido said:

Your service will by default be run with one of three accounts. Network Service (most likely), Local Service and Local System. Usually Services will be run with the Network Service identity as it has the least amount of permissions to the system. However this can cause permissions issues when the service being run requires elevated privs. Try running your service with either of the two local accounts and see how you go.

----------------
Dominic Ryan
5 x Microsoft IIS MVP, MCSE, MCSA
IIS Aid owner/webmaster