topic Qlik View can not open a socket, why? in QlikView

Qlik View can not open a socket, why?

Mon, 30 Aug 2010 14:58:39 GMT

Hi everyone,

I am facing quite a strange issue with Qlik View 64 bits. I use it to connect to a database via an ODBC connection.

It worked for a while and suddenly, I started to get an error message when trying to reload a report. This message is:

SQL Error:Could not connect to the server;
Could not create Socket.
SQL State:08001
SQL SELECT id
FROM "db"."public".table

Nothing has changed from the ODBC connection and indeed, it is used successfully by other tools.

Would anyone know where this would be coming from?

Thank you.

Qlik View can not open a socket, why?

Clever_Anjos — Mon, 30 Aug 2010 15:01:44 GMT

Which database and driver are you using?

Qlik View can not open a socket, why?

Mon, 30 Aug 2010 15:11:34 GMT

The database is Postgresql 8.4 and the driver was taken here:

http://code.google.com/p/visionmap/wiki/psqlODBC

Qlik View can not open a socket, why?

Clever_Anjos — Mon, 30 Aug 2010 15:22:37 GMT

I´m not a great Postgre user.

Have checked the itens below?

1) Windows firewall

2) Postgre security: the user you´re using has the right to select that table?

Qlik View can not open a socket, why?

Mon, 30 Aug 2010 15:25:14 GMT

Yes, all these points have been checked.

I have one system ODBC connection defined and all the tools use the same.

The ODBC settings are so the same for all the tools and only Qlik View fails even if it has worked before.

Qlik View can not open a socket, why?

Mon, 06 Sep 2010 22:16:04 GMT

Have you checked for antivirus ? I used to have dropped connections when Kaspersky was running.

Qlik View can not open a socket, why?

Fri, 10 Sep 2010 11:03:58 GMT

There are no antivirus or firewalls on the way.

The application just randomly works for a while and then fire this error.

Nothing as moved in between. Didn't even reboot the computer.

I really don't understand.

Qlik View can not open a socket, why?

Miguel_Angel_Baeyens — Fri, 10 Sep 2010 11:44:08 GMT

Hello,

Did you try using this odbc driver instead? I'm using this in a Windows 7 x64 environment without problems for the time being.

Hope that helps

Qlik View can not open a socket, why?

Fri, 10 Sep 2010 12:05:20 GMT

Hi, I have tried indeed.

this is a 32 driver. It is usable under 64 Bits operating systems, but not with a 64 bits of Qlik View... Or I couldn't get it to work.

Qlik View can not open a socket, why?

Miguel_Angel_Baeyens — Fri, 10 Sep 2010 12:57:03 GMT

Sorry for not specifying.

You can create a user DSN running

%WINDIR%\SysWOW64\odbcad32.exe

Once you have set all necessary parameters, you will be able to access it normally from your ODBC Connect dialog in QlikView.

Hope that helps.

EDIT: It needs to be a user dsn. After trying with the driver you specified, it works better for me that the driver I posted, which actually worked on a Win 7 ultimate edition laptop connecting to two different 7 and 8 postgres servers. So I leave the comment just for information.

Qlik View can not open a socket, why?

Fri, 10 Sep 2010 13:14:53 GMT

I tried that method as well but none of the 64 bits tools that I use works with the DSN file created.

When selecting the file, it fails with this message "[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified".

When selected within Qlik View, there is no error message and nothing happens. It is like I have never selected anything.

Qlik View can not open a socket, why?

Miguel_Angel_Baeyens — Fri, 10 Sep 2010 13:17:26 GMT

Another workaround I haven't tested is using QlikView 32 bit edition (which supposedly will be able to load the 32 bit driver) and see if that works. Anyway, let's wait for some postgres experts in here to check for this!

Qlik View can not open a socket, why?

Fri, 10 Sep 2010 13:23:53 GMT

but then there would be limitations in the amount of memory that it can handle.

right?

Qlik View can not open a socket, why?

Miguel_Angel_Baeyens — Fri, 10 Sep 2010 13:44:31 GMT

Correct, it won't get more than 4Gb running in your 64bit system. Anyway, I don't know whether QlikView 32 bits supports large address aware, and if not, it won't handle more than 2 Gb.

Qlik View can not open a socket, why?

Tue, 21 Sep 2010 11:40:58 GMT

Well this is really weird.

I reinstalled QlickView to be sure. The problem is still the same.

I tried with an OLE DB driver.

It is possible and easy to define a .udl file which would be valide and would succeed at the test of connection. But within QlikView, entering the very same information would fail the connection test. Furthermore, copying the content of the udl file to the QlikView script for connection would produce a new error:

SQL error: Cannot open DB connection.
could not create socket: A (0x0000277B/10107)

SQL SELECT id

FROM db

Once again, it seems that QlikView can not create a socket, while anything else can. I would really like to know why or how to fix it.

Qlik View can not open a socket, why?

Miguel_Angel_Baeyens — Tue, 21 Sep 2010 12:15:10 GMT


rdordonne wrote:Well this is really weird.

Actually it is. Make a quick search for those error codes in Windows and the following comes up:

Error 0x0000277B: A system call that should never fail has failed.

Error 10107: A system call that should never fail has failed. This is a generic error code, returned under various conditions.

I've run out of ideas, but contacting both QlikTech and Microsoft support would be a good idea.

Note: In regards to postgres, I've read that uninstalling some firewall software avoided further errors...

Qlik View can not open a socket, why?

Wed, 12 Jan 2011 14:42:46 GMT

Probably already done, but upgrade your QV app to 9 SR6, regards.