Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Qlik View can not open a socket, why?

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.

16 Replies
Clever_Anjos
Employee
Employee

Which database and driver are you using?

Not applicable
Author

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

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

Clever_Anjos
Employee
Employee

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?

Not applicable
Author

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.

Not applicable
Author

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

Not applicable
Author

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.

Miguel_Angel_Baeyens

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

Not applicable
Author

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.

Miguel_Angel_Baeyens

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.