Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi Niharika,
Have you installed the driver on the server.
Also check if it is connected using the QlikView.
Regards,
Kaushik Solanki
might be helpful for you?
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
Any suggestions ?
Maybe I am missing something, but why not use the same Connection string in QMC as in Developer?
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
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);
But it does work in Developer on the same machine with the same user?
And you use OLEDB CONNECT32 in QMC also?
No. I have used ODBC CONNECT on QMC.