Problem connexion ODBC QV server

[realpixel]

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 · Accepted solution]

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]

Thank Michael, It was the problem!

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

Thank you again.