what permissions do you need to access an odbc db?

[CoronaB]

i have written a perl script which accesses data in a db hosted by my systems odbc. when i run the script from the command prompt under my logon it runs perfectly, but when i execute it from iis under the iusr account i hear an error beep, and it just hangs. i have to assume it is because the iusr account doesnt have proper permissions to access the db. i have given read\write access to the db files themselves, as well as read access to all of the odbc's dll's. Does anyone know what other permissions the iusr account will need to be able to access the odbc? PLEASE!!!!

 

[jabhawk]

Just had a similar issue myself...
1. What OS are you using
2. Where is the database residing: local, NTserver, unix

I had a workstation with a system DNS setup for a database residing on a seperate NT4 server. The process was being run by the local Admin but could not access the DB.

We ended up creating a user profile on the system that has the correct NT access to the shared folder setup on the server and to the db files themselves.

I would suggest loggin into the workstation as the ODBC user and attempting to connect manually to see the errors and go from there. It will depend on the level of security you have on your network.

Hope this helped.
Jon Jonthan A Black
GAF Materials Corp
Wayne, NJ

 

[CoronaB]

Im running Xp Pro, the database resides on a local drive. if i log on as my iusr account i get the same problem, but if i log on as my admin account it works just fine. instead of using the odbc ive already started an alternate solution. im running mysql and using the perl:dbi module to access it. i like running mysql more than i like just using the local ms odbc. anyway thanks for your advice but i think im just going to use mysql instead, it seems to be working great