MS SQL - connection ok but Failed dialog IM008

[#1]

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

[#2]

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

[#3]

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

[#4]

No,

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

[biester]

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

[#6]

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.

[#7]

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