Hello all, hoping to get some help with the following problem...
When I try to connect to a Progress database from a classic ASP page using IIS I get the following error:
Specified driver could not be loaded due to system error 126 (MERANT 3.60 32-BIT Progress SQL92 v9.1D).
Config is as follows:
1. System DSN on webserver succesfully connects to database.
2. Webserver and database server are on different Windows 2003 servers.
3. Tried both a direct connection string and the DSN connection string - both fail with above error.
4. Both servers are in a domain.
Direct connect string:
"DRIVER=MERANT 3.60 32-BIT Progress SQL92 v9.1D;UID=sysprogress;PWD=sysprogress;DB=[DATABASE NAME];PORT=2525;HOST=[SERVER NAME]"
My goal is simply to read a single table and display results - read only access is all I need. Trying to display available gift card balance to customers via the web.
I am thinking this is related to the webservers IUSR account not being able to authenticate to the windows database server, but not sure how to provide it read access.
Any ideas? Any help you can provide is greatly appreciated.
Thanks
Chris
When I try to connect to a Progress database from a classic ASP page using IIS I get the following error:
Specified driver could not be loaded due to system error 126 (MERANT 3.60 32-BIT Progress SQL92 v9.1D).
Config is as follows:
1. System DSN on webserver succesfully connects to database.
2. Webserver and database server are on different Windows 2003 servers.
3. Tried both a direct connection string and the DSN connection string - both fail with above error.
4. Both servers are in a domain.
Direct connect string:
"DRIVER=MERANT 3.60 32-BIT Progress SQL92 v9.1D;UID=sysprogress;PWD=sysprogress;DB=[DATABASE NAME];PORT=2525;HOST=[SERVER NAME]"
My goal is simply to read a single table and display results - read only access is all I need. Trying to display available gift card balance to customers via the web.
I am thinking this is related to the webservers IUSR account not being able to authenticate to the windows database server, but not sure how to provide it read access.
Any ideas? Any help you can provide is greatly appreciated.
Thanks
Chris