Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

task failed in qmc

Hi,

I created the task in qmc which has failed however I am able to reload qvw manually without error, below is the error mentioned in log file

error:

Microsoft OLE DB Provider for ODBC Drivers, ErrorMsg: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

1 Solution

Accepted Solutions
Highlighted
Specialist
Specialist

Hi

Try to install the oracle client in your server to solve this, or install Qlik ODBC Connector and change your connection mode.

Márcio Rodrigo Campestrini

View solution in original post

11 Replies
Highlighted
Creator III
Creator III

Hi,

There is issue while extracting from database.

Please let us know how you are connecting to database and if it is connecting through ODBC, heve you created datasource?

Highlighted
Not applicable

QVW is connected to oracle database by using ODBC driver and DSN is also created, I am able to manually reload the qvw but task is failing while running in qmc

Highlighted

Strange, what error you are facing. Can I have the ligfile of that failed file.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Highlighted
Creator III
Creator III

Hi,

Can you please share the log file?

Highlighted
Master
Master

Hi,

have you set up the ODBC Connection from Your QMC server? Is Your desktop and QMC placed on the same server?

If not, Add the ODBC Connection on QMC server, if its on the same, be sure that the QMC server account have read Access to the database.

Highlighted

have you installed the driver in SERVER ?? have you create the ODBC connection with the same name in the server ??

Highlighted
MVP & Luminary
MVP & Luminary

Hi,

Did you created ODBC in the QMC server?  I think that is the issue, you have to create the ODBC in server also.

Regards,

jagan.

Highlighted
Specialist III
Specialist III

Hi, install ODBC driver and create the ODBC connection on server.

Regards!

Highlighted
Contributor III
Contributor III

Hello ,

Please ensure DSN should have been created in the QMC server also as you done in your local server where you have installed your qlikview client.