is OpenEdge 10.2 A version supported

[umityaz]

in appsettings.json file we have connection string as:

"ConnectionStrings": {
"OpenEdgeDbContextConnStr": "DRIVER={Progress OpenEdge 10.2A driver};host=localhost;port=12345;db=modhotel;uid=myUser;PWD=myPass;DIL=READ UNCOMMITTED;",
}

When we run the below code

public async Task<IEnumerable> GetTest()
{
using (var ctx = dbContext)
{
var test = ctx.o_kuradi.ToList();
...
}
}

we get the following error:

ERROR [IM003] Specified driver could not be loaded due to system error 193: (Progress OpenEdge 10.2A driver, C:\Progress\OpenEdge\bin\pgoe1023.dll).

Our OpenEdge version is 10.2A and our version is 32bit.

[alexwiese]

hi @umityaz

I personally haven't tested against 10.2A but the SQL interface hasn't changed a lot so the core functionality should be the same.
That error you see generally indicates a mismatch in bitness between the application and the ODBC driver.
Most likely you only have the 32-bit version of the ODBC driver installed on your system, but your .NET application is running as 64-bit.

You have two options:

• Change your .NET application to run as 32-bit
• Install the 64-bit version of the ODBC Client Driver

First thing I'd try is running your .NET application as 32-bit to see if that resolves the issue. Let me know how you get on.