Odbcad32.exe Test Connection Passes But Program Connection Fails

[Steve Staple]

I am trying to get a connection string right, and using odbcad32.exe to test the connection.

The trouble is, I get Connection Established, regardless of what password I enter.

This seems pretty useless.

My .NET program fails with Data source name not found and no default driver specified even though odbcad32.exe has no problem getting the connection.

Data Source Name : Test_Blah Description: Test_Blah Host Name: blh-housing Port Number: 5060 Database name: ih User ID: administrator Driver: Progress OpenEdge 10.2b Driver Password: (space)

This is my connection string:

<add name="BlhConnection" connectionString="DSN=Test_Blah;UID=Administrator;PWD=' ' ;" />


Any ideas how I can get this working?

Continue reading...