Informix

 View Only
  • 1.  Connect to legacy Informix Server using .NET Data Provider

    Posted 17 days ago

    I am creating an IfxConnection to connect to the legacy Informix server

    IfxConnection con = new IfxConnection("Host=localhost;Server=myserver;UID=user;Pwd=pswd;Service=9088;Database=sysmaster")

    Connection string with this set of parameters was working with some old Informix CSDK back then, but now con.Open() throws an exception "Invalid argument", and unfortunately does not say which argument exactly.

    I have tried to add/remove connection string parameters in many combinations, including using parameters like Persist Security Info, Authentication, DB_LOCALE, CLIENT_LOCALE, Protocol and so on, but no luck.

    Could anyone please provide a valid connection string or give me a hint what am I doing wrong?



    ------------------------------
    Anatoly Sova
    ------------------------------


  • 2.  RE: Connect to legacy Informix Server using .NET Data Provider
    Best Answer

    Posted 17 days ago

    I have found answer thanks to comment from StackOverflow
    There are two versions of IBM.Data.Informix.dll - one from DB2, and another from Informix CSDK, and I was accidentally using DB2 one, because it was installed in GAC in my machine.
    Version from Informix CSDK works just fine with the connection string provided.



    ------------------------------
    Anatoly Sova
    ------------------------------