Consultor Eletrônico



Kbase P129089: ASP.NET application cannot connect using Merant 3.70 SQL-89 ODBC driver
Autor   Progress Software Corporation - Progress
Acesso   Público
Publicação   20/02/2008
Status: Unverified

FACT(s) (Environment):

Progress 9.1E
MERANT 3.70 32-BIT Progress SQL-89

SYMPTOM(s):

ASP.NET application is unable to connect using the SQL-89 ODBC driver

[MERANT][ODBC PROGRESS driver]Optional feature not implemented.

[MERANT][ODBC PROGRESS driver]Driver's SQLSetConnectAttr failed.

A regular .NET application is able to connect using the same ODBC driver

Identity impersonation is being used for the ASP.NET program

Setting identity impersonate="true" causes program to work

Setting identity impersonate="true" userName="domain\SomeUser" password="SomePassword" causes program not to work

Progress is installed on a network drive (mapped to a drive letter)

Progress environment variables DLC, IDLC, PROOIBRK and PROOIDRV all point to drive letter

CAUSE:

The exact cause is unknown at the time of this writing

FIX:

Change the DLC, IDLC, PROOIBRK and PROOIDRV environment variables to point to the UNC share rather than a mapped drive letter