Forum Discussion
Connecting to Informix DataBase with instance name
Hello, how can I put the instance name on a informix connection.
At sever field I put: myserver:myPort
At DataBase I put: myDataBaseName
But I couldn't found where I can put the instance server name.
For example, in a JDBC connection I can put everything in a single line:
jdbc:informix-sqli://myHostServerName:myPort/myDataBaseName:INFORMIXSERVER=myInstanceServerName
But I don't know how do this at connection wizard of Power BI.
Without a instance server name, the connection will target a default instance name which my login doesn't have access privileges.
So I can't perform authentication.
5 Replies
Anonymous,
In server field you can input: ServerName/InstanceName: Port
In Database field you can input: DatabaseName
Regards,
Jimmy Tao
v-yuta-msft, it doesn't work. Power BI try to resolve "hostname/instance" as a hostname, so a I receive a message unknown host. This works like a charm with others db's like Oracle.
Anonymous,
In your senario, I would recommend you to use ODBC connector with connection string instead and try again. For more details about ODBC, please refer to: https://docs.microsoft.com/en-us/power-bi/desktop-connect-using-generic-interfaces#data-sources-accessible-through-odbc.
Regards,
Jimmy Tao
