Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
10 years ago
Solved

Connecting to Informix

I am trying to setup an Informix dataset and have no clue whats wrong since its in beta and cant find much community questions.

It asked me for my server and database when I was setting it up. I put those in and then I typed in a username and password. When I click the conenct button I receive this error. 

 

Details: "Microsoft Informix Client: No such host is known SQLSTATE=08S01 SQLCODE=-1037"

  • arify's avatar
    arify
    10 years ago

    Hi, a few things worth mentioning:

     

    • The default port number is 9089. If the server isn't on that port, can you make sure specifying the correct port number?
    • Can you make sure you can connect to your Informix server from your machine using TCP/IP? Also can you make sure the server name can be resolved by dns?
    • Can you make sure you're not specifying the server name with "http://" at the beginning?
    • It could be a firewall issue on the server, can you check that as well?

     

    It looks like a connection issue and there must be some configuration mistake somewhere, but with the very limited details I have, I can't point you to a specific direction.

     

    Thanks

8 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    10 years ago

    Any ideas anyone?

    • arify's avatar
      arify
      Microsoft Employee
      10 years ago

      Hi, are you sure this is not a firewall issue? Can you show us how you're trying to type the host name?

      • Anonymous's avatar
        Anonymous
        Not applicable
        10 years ago

        I am asked to provide the server name and database name. I type in the name of those and then proceed to go to the next window and type in my credentials. Then I get the error above.

  • DavidM's avatar
    DavidM
    New Member
    9 years ago

    Hello Arify,

    We are experiencing a similar issue when trying create a data connection using Power BI (Version: 2.47.4766.542 64-bit (June 2017) ).

    Following the prescribed recommendations in this post, we opened port 9089 and then proceeded to connect to a Pronto Xi IBM Informix database using our IP with port :9089 appended e.g. 10.123.10.456:9089 and then selecting the relevant database. This connection seems to be working to some extent because we can then proceed to the next step of actually seeing all the Pronto database obects (tables) to choose from.

    However, once we select a table and continue we are thrown the following error...

     

    "Load pronto sales_order Failed to save modifications to the server. Error returned: 'OLE DB or ODBC error: [DataSource.Error] Microsoft Informix Client Method not found: ' System.String.String.Format(System.FormatProvider, System.String, System.Object)'. SQLSTATE = HY000 SQLCODE = -343. '."

     

    Note: At no time were were asked to provide a username and password.

     

    Hoping there is a solution to resolve this issue so we can create a successful connection.

     

    Thank You,