Not able to connect to database from QMC scheduled qvw

[kkkumar82]

Hi all,

I have a qvw file reloading fine in QV Desktop (in server) but when I schedule in server as "on an external event" or as daily schedule or even none and pressing reload now it is failing and throwing the following error

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

I searched through the community and as per the guide lines , I have created the DSN (ODBC) in System User also.

Any thing I am missing .

Database is MYSQL

Thanks

Kiran Kumar

[jonathandienst]

It looks like the ODBC provider is not installed on the server, or the QV service account does not have access to the provider or to the database. Or the application is trying to use a 64 bit driver and there is only a 32 bit driver (or vice versa).

If you can remote onto the server, you could try running

     c:\Windows\System32\odbcad32.exe (64 bit ODBC)

     c:\Windows\SysWow64\odbcad32.exe (32 bit ODBC)

to verify the ODBC provider/source exist on the server.

[manojkulkarni]

If am correct, you are able to reload the application manually through QV Desktop in same machine where server is installed but failing when try to reload from server.

In that case, I think it has something to do with User privileges

[kkkumar82]

Hi Manoj,

reloading from Desktop with in the server is fine but when I am trying from QMC it is failing. Two months back it was working fine with the same ODBC Driver I don't know something went wrong.

Thanks

Kiran Kumar

[kkkumar82 · Accepted solution]

All,

The problem is solved I uninstalled and reinstalled the MYSQL Driver which is 64 bit.

MySQL :: Download Connector/ODBC

Thanks

Kiran Kumar