EntityFrameworkCore.OpenEdge
EntityFrameworkCore.OpenEdge copied to clipboard
is OpenEdge 10.2 A version supported
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<myDTO>> 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.
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.