Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator II
Creator II

Error while connecting to Teradata in QMC

Hi All,

I have created a task in QMC- System - Supporting Tasks - Database Command and connecting to Teradata which is installed in the machine in below format

Provider=Teradata;DBCName=MyDbcName;Database=myDataBase;Uid=myUsername;Pwd=myPassword;

But upon running the task, I get a error as below

QDSMain.Exceptions.TaskFailedException: Task failed ---> System.InvalidOperationException: The 'Teradata' provider is not registered on the local machine.

Can anyone help me with this.

Thanks,

Niharika

Tags (1)
11 Replies
Highlighted
MVP & Luminary
MVP & Luminary

Re: Error while connecting to Teradata in QMC

Hi Niharika,

Have you installed the driver on the server.

Also check if it is connected using the QlikView.

Regards,

Kaushik Solanki

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".
Highlighted
Champion
Champion

Re: Error while connecting to Teradata in QMC

Highlighted
Creator II
Creator II

Re: Error while connecting to Teradata in QMC

Hi Kaushik,

Teradata Driver is installed in the server and a ODBC connection is created for the required Datasource.

Now in QlikView I am using Database as OLEDB and selecting Provider as Microsoft OLEDB Provider for ODBC drivers and selecting the Datasource which is created. Then the connection is successful in Qlikview.

The connection string which is generated is in below format

OLEDB CONNECT32 TO [Provider=MSDASQL.1;Persist Security Info=False;User ID=userid;Data Source=mydatasource;Extended Properties="DSN=mydatasource;UID=userid; "];

Now, I have created a task in QMC(same server)- System - Supporting Tasks - Database Command and connecting to Teradata in below format:

Provider=TDOLEDB;Data Source=mydatasource;Persist Security Info=True;User ID=userid;Password=mypassword;Session Mode=ANSI;

But I am getting an error that

System.InvalidOperationException: The 'TDOLEDB' provider is not registered on the local machine. ||

Kindly help me with this.

Regards,

Niharika

Highlighted
Creator II
Creator II

Re: Error while connecting to Teradata in QMC

Any suggestions ?

Highlighted
Partner
Partner

Re: Error while connecting to Teradata in QMC

Maybe I am missing something, but why not use the same Connection string in QMC as in Developer?

Highlighted
Creator II
Creator II

Re: Error while connecting to Teradata in QMC

Hi Jerry,

I have even tried using

Provider=MSDASQL.1;Persist Security Info=False;User ID=userid;Data Source=mydatasource;Extended Properties="DSN=mydatasource;UID=userid; " in QMC,

but it is throwing an error that

The .Net Framework Data Provider for OLEDB (System.Data.OleDb) does not support the Microsoft OLE DB Provider for ODBC Drivers (MSDASQL). Use the .Net Framework Data Provider for ODBC (System.Data.Odbc).

Regards,

Niharika

Highlighted
Creator
Creator

Re: Error while connecting to Teradata in QMC

I am not really sure about what you are looking for. but I have tried steps below and it works fine for me:

1. On QMC server Control Panel -> Administrative Tools -> Data Source(ODBC) -> System DSN -> Add DataSourceName with specifications to connect to database.

2. And in Qlikview script , below code to connect to database:

ODBC CONNECT TO DataSourceName(XUserId is userId XPassword is password);

Highlighted
Partner
Partner

Re: Error while connecting to Teradata in QMC

But it does work in Developer on the same machine with the same user?

And you use OLEDB CONNECT32 in QMC also?

Highlighted
Creator
Creator

Re: Error while connecting to Teradata in QMC

No. I have used ODBC CONNECT on QMC.