Plex 2E

Expand all | Collapse all

.NET Generator and PostGreSQL ODBC/OLEDB

  • 1.  .NET Generator and PostGreSQL ODBC/OLEDB

    Posted 19 days ago
    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)



  • 2.  RE: .NET Generator and PostGreSQL ODBC/OLEDB

    Posted 11 days ago
    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