Jump to content

Specified Driver Could Not Be Loaded


ShadowMage
 Share

Recommended Posts

I'm not sure if this should go here or in PHP, but I'm having problems getting PHP to connect to a Progress DB.  I have IIS installed and configured on a Windows 2008 server and all seems to be fine on that front.  I can access the site, and I can run PHP code.  I can also access the MySQL databases we have.  When I try to access the Progress database, however, I get the following error:

 Warning: odbc_connect(): SQL error: Specified driver could not be loaded due to system error 5: Access is denied. (Progress OpenEdge 10.2A driver, \\share\path\to\file.dll)., SQL state IM003 in SQLConnect in C:\inetpub\phplib\ODBC.php on line 349

I created a system DSN on the webserver and I am able to successfully test connect from there.  I've also added full control for Everyone on the specified DLL (and the path to get to it) and still get the access denied error.

Any ideas or suggestions?

Thanks in advance for any help you can offer.

Link to comment
Share on other sites

I'm not sure how Windows permissions specifically work, but in addition to Everyone make sure that you have the IIS account also set up with permissions.  Maybe the IIS account specifically doesn't have read access and that overwrites the permissions for Everyone, but like I'm said I'm not sure specifically how it works in Windows.

Link to comment
Share on other sites

Seems like that was the problem.  Apparently Everyone doesn't include the IUSR...:huh:

I couldn't find a way to add the IUSR account to the share in AD, but I did figure out how to change the account used in anonymous authentication in IIS.

Link to comment
Share on other sites

  • 1 year later...

We're migrating to Windows Server 2019 (IIS 10) now and this issue has reappeared.  I've changed the account in anonymous authentication to the domain admin account as before, but the error is still showing up.  I tried creating a new account specifically to run PHP/IIS and gave the account access to the share/file.  I tried specifying this account in anonymous authentication and in the application pool identity (and setting anon auth to use the app pool identity), but nothing seems to work.  Any ideas on what else I can try?

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...