topic Re: Error Code: 31004 in QlikView

Error Code: 31004

Anonymous — Wed, 02 May 2018 02:23:10 GMT

Hi,

Could any one assist me with the error code interpretation? I tried to create connection to external ODBC data source. Connection has failed and in the dialog window it stated as follow:

Connection Test Failed

SQL##f - SqlState: S1000, ErrorCode: 31004, ErrorMsg: [Jade Software Corporation][JADE ODBC Thin Client] Connection failed to connect

What is the Error Code 31004 mean?

Thank You

Re: Error Code: 31004

johnca — Wed, 02 May 2018 20:09:33 GMT

31004 Connection failed to connect Cause This error occurs if the TCP/IP layers fail to open the requested connections. JADEMsgs - 7.0.12

Action Check that the host name is mapped to the correct IP number in the host file. Check that its port number matches the port number of the target listener.

https://www.jadeworld.com/downloads/tech/manuals/70/JADEMsgs.pdf

Re: Error Code: 31004

Anonymous — Wed, 02 May 2018 23:53:48 GMT

Thanks so much for taking the time to provide this information John. Much appreciated.

Regards

Jeffry

Re: Error Code: 31004

johnca — Thu, 03 May 2018 13:43:47 GMT

Great. If this is the answer you sought then please mark it as correct so others will know too.

V/r,

John

Re: Error Code: 31004

diffeyj — Thu, 25 Jun 2020 23:33:32 GMT

For those who also have this issue, @johnca's response helped point me in the right direction. I had a similar issue where I had a production and test Jade environment on the same server, and it appeared they were setup the same. So this was really driving me crazy.

Turns out the firewall had been used to lock it all down, and the production port had been opened but the test had not. So your firewall settings could be a good place to check