.NET Generator and PostGreSQL ODBC/OLEDB

[WayneMorgan]

When attempting to utilize a .NET generated plex app and PostGreSQL Database  - I am getting the following Error 

[PLEX9999] The .Net Framework Data Provider for OLEDB (System.Data.OleDb) does not support the Microsoft OLE DB Provider for ODBC Drivers (MSDASQL). Use the .Net Framework Data Provider for ODBC (System.Data.Odbc).

Can plex Support this ? from what I have read it appear that the compiler directives need to be modified as well 

Using the same ODBC connection with WINC generated does work - but need to figure out how to get this working with the .NET app

Any Ideas?

attached udl and config (renamed as .docx to allow upload)


------------------------------
Wayne Morgan
Application Developer
SS&C Technologies
------------------------------

Attachment(s)

treasury.udl.docx   396 B 1 version

TreasuryUI.App.exe.config.docx   9 KB 1 version

[Kiyoshi]

Hi, there

Please get Native OLE Provider for PostGreSQL 
set ConnectionString to UDL file. bellow link will help.
https://www.connectionstrings.com/pgoledb/

I don't have env to confirm,
But I believe that is the way to go.

Kiyoshi