Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
All,
The problem is solved I uninstalled and reinstalled the MYSQL Driver which is 64 bit.
MySQL :: Download Connector/ODBC
Thanks
Kiran Kumar
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.
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
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
All,
The problem is solved I uninstalled and reinstalled the MYSQL Driver which is 64 bit.
MySQL :: Download Connector/ODBC
Thanks
Kiran Kumar