Db2

Db2

Connect with Db2, Informix, Netezza, open source, and other data experts to gain value from your data, share insights, and solve problems.

 View Only

  • 1.  Using ODBC DSN with NET 6.0 provider

    Posted Fri September 30, 2022 04:16 PM
    Is there a way to specify the old type of connection string using database, currentschema, uid and password, ommitting the server which is (in our case) specified under DSN's alternateserverlist.
    We have a DB2 running in HADR mode, and there are four servers specified in the alternateserverlist section of DSN.

    The way I see it in NET 6.0 DB2Connection class we only can provide a single DB server in the connection string.

    ------------------------------
    Ivan Švaljek
    ------------------------------

    #Db2


  • 2.  RE: Using ODBC DSN with NET 6.0 provider

    Posted Sat October 15, 2022 05:37 AM
    To answer my own question, it's possible just as in previous versions. But now each C# project has an IBM CLI driver folder which has its own config files which need to inlcude the DSN details for the targeted DB.

    A new question: is there a way to specify a global DSN, not in C# project folder, but in C:\ProgramData instead?

    ------------------------------
    Ivan Švaljek
    ------------------------------

    Original Message