Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Not applicable

MS SQL - connection ok but Failed dialog IM008

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

6 Replies
Not applicable

MS SQL - connection ok but Failed dialog IM008

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

Not applicable

MS SQL - connection ok but Failed dialog IM008

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

Not applicable

MS SQL - connection ok but Failed dialog IM008

No,

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

biester
Valued Contributor

MS SQL - connection ok but Failed dialog IM008

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



Not applicable

MS SQL - connection ok but Failed dialog IM008

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.

Not applicable

AW:MS SQL - connection ok but Failed dialog IM008

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

Community Browser