trying to connect to Progress database in vb.net with Merant 3.70

[tanyacakes]

Hello,

I am trying to connect to a version 9.1B Progress database from asp.net Visual Studio 2003 using Merant 3.70 32-bit ODBC progress driver.

When I try to connect to Progress through the system admin using Merant ODBC and the system DSN, it connects fine. (Start->Settings->Control Panel->Administrative Tools->Data Sources(ODBC)->System DSN->Configure) (on the Advanced tab in Configure, the Security Required is NOT selected so no password/username is required)

So far, all the forum postings I have seen for the following error message I am getting recommend the same thing yet I have tried the recommended solution and still get the following error.

ERROR HY000 MERANT ODBC Progress driver
insufficient information to connect to the data source

The stack trace from the following code
----------------
Catch objException As Odbc.OdbcException
Dim objError As Odbc.OdbcError
Console.WriteLine(" The Stack trace is " &
objException.StackTrace)
End Try
------------------

is The Stack trace is
System.Data.Odbc.OdbeConnection.Open()


My connection string is
DRIVER={MERANT 3.70 32-BIT PROGRESS}; DSN=OURDSN; UID=" "; PWD=" "; database=ourdatabase;

The forums say the error is from not having a UID and PWD parameter in the connection string. However, I DO have each of these. I read that the ASP-engine will(incorrectly) not pass on the UID/PWD parameters when the UID/PWD variable values are emtpy. Workaround: pass on a non-empty UID/PWD string filled with blanks.

So I changed my original connectionstring from UID=; to UID=" "; and from PWD=; to PWD=" ";

No improvement.

anybody know the connection string for Progress database in .net using Merant 3.70 driver?
Thanks.

 

[hrub]

Hi, i am facing same problem ,
Did you get any work around?
thank you.