topic MS SQL - connection ok but Failed dialog IM008 in QlikView

MS SQL - connection ok but Failed dialog IM008

Mon, 26 Jan 2026 18:19:17 GMT

HI,

I'm trying to execute a SQL request in QlikView in connection with a MS SQL Server database.

I've tested the connection to the database, it's a success but when I execute a SQL resquest, I obtain this error :

"Failed dialog - State : IM008"

What's the problem ?

Can tou help me please ?

Thx

MS SQL - connection ok but Failed dialog IM008

Thu, 27 Aug 2009 18:17:07 GMT

This error has something to do with connection, check the connection string again. Also, try to execute the query on some sql client using same userid and password.

Thanks

Amit

MS SQL - connection ok but Failed dialog IM008

Fri, 28 Aug 2009 04:26:53 GMT

network or firewall issue ... this is not related toqlikview

MS SQL - connection ok but Failed dialog IM008

Wed, 23 Sep 2009 23:13:09 GMT

No,

I have the same problem and it is qlik related, because the odbc test works!

MS SQL - connection ok but Failed dialog IM008

biester — Thu, 24 Sep 2009 00:14:32 GMT

Have you tried OLEDB instead of ODBC? Anyway, the error seems to come from the SQLDriverConnect-Function, and as reason for IM008 it says:

The driver attempted to display its login dialog box and failed.

WindowHandle was a null pointer, and DriverCompletion was not SQL_DRIVER_NO_PROMPT.

That means that a Dialog Box function call has failed. I'd say there's something wrong with the credentials ....

Rgds,
Joachim

MS SQL - connection ok but Failed dialog IM008

Thu, 24 Sep 2009 15:38:44 GMT

I've resolved the problem.

You must choose OLEDB instead of ODBC, like biester suggests it. Then select the good driver and it works.

Thx for your help all.

AW:MS SQL - connection ok but Failed dialog IM008

Wed, 04 Nov 2009 22:49:51 GMT

I had the same problem. In my case it was a misspelled user-password or a connection string without the user / user-password part.

I could read the DB-Schema and could import it into the script but when I tried to load the data the error occures.

Be care of the right spelling of the password and write it into the connection string. Then it should work.

Have Fun with QV

Alex