Why is there no answers to Error 1114 with asp?

[hugo_emond]

The following problem has been submitted several times in the past:

ERROR [IM003] Specified driver could not be loaded due to system error 1114 (MERANT 3.60 32-BIT Progress SQL92 v9.1C).

I could not find any real solution...
I'm experiencing it right now and it is quite painfull

I know this is an old version and all but I'm stuck with it and I absolutely have to connect to the database with asp.net.

So if somebody knows I will have a new personal hero!

Thank you,

Hugo

 

[hugo_emond]

If anyone is looking for an answer, here's what I got from Progress technical support :

CAUSE:
The problem is related to ownership / access rights to the .dll file.
FIX:
Start AdminService for Progress to start using user account that is
part of
the administrator group instead of the system account.

So, I changed the startup user for the service "AdminService for progress" and reboot.​

And it worked... Well, not entirely, I get those messages now:

ERROR [HYC00] [MERANT][ODBC PROGRESS driver]Optional feature not implemented.
ERROR [HY000] [MERANT][ODBC PROGRESS driver][PROGRESS]Database not started
ERROR [IM006] [MERANT][ODBC PROGRESS driver]Driver's SQLSetConnectAttr failed.

HELP would be appreciated !​

 

[Casper]

If you really want to work with SQL then the best thing to do is probably upgrade to 9.1E04 at least.

Do you have a sql broker running for your database?
Could you post you connection string here?

Regards,

casper.

 

[hugo_emond]

Hi,

Thank you for your help.

Here’s the situation:
I have to connect to the database with a dashboard developed in asp.net.

So I installed Progress 9.1C (full install) on my Desktop as well as the dashboard (for which I have the source code).
I use only one broker on my machine since I don’t have to run the 4GL here.
Here’s how I start the database:
proserve myDB –H 127.0.0.1–N TCP –S 5555

I first tried to connect whit the OBDC Admin and it worked well.
SQL Server's Linked Server also works.

Here's my ODBC connection string under .net :

DRIVER={MERANT 3.60 32-BIT Progress SQL92 v9.1C};HOST=127.0.0.1;DB=myDB;UID=sysprogress;PWD=sysprogress;Port=5555;

Here's what I tried:
1- Change the "AdminService" security context.
2- Add "C:\Program Files\Progress\bin" to the Path
3-Give unlimited rights to that same folder and subfiles to : ASPNET, IUSR..., etc.

Nothing seems to change anything.

Thank you!

Hugo