topic Re: Problem connexion ODBC QV server in QlikView

Problem connexion ODBC QV server

realpixel — Tue, 02 Apr 2013 14:12:05 GMT

Hello,

I have the following problem.

On the QV server, I created a ODBC connexion named 'INST', the connexion to the 'INST' is fine from the server.

But when I try to reload the document from the console serveur, I have failed error.

Error: SQL##f - SqlState: IM002, ErrorCode: 0, ErrorMsg: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

02/04/2013 15:00:58: General Script Error

02/04/2013 15:00:58: Execution Failed

02/04/2013 15:00:58: Execution finished.

I can open the document directly from the server with the QV personnal Edition witout error.

Anonymous — Tue, 02 Apr 2013 14:20:14 GMT

I think that your ODBC DSN is "user" DSN, and not available for the "user" that runs QV services. Try to use "system" DSN.

Regards,

Michael

realpixel — Tue, 02 Apr 2013 14:30:23 GMT

Thank Michael, It was the problem!

I have create ODBC driver like ''user'' and not ''system'', problem solved.

Thank you again.