Unable to connect to Teradata from Qlikview Management Console

Connectivity

Unable to connect to Teradata from Qlikview Management Console

Hi All,

I am trying to connect to teradata from Qlikview Management Console. The connection String I have written is 

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

But It is throwing an error as :

The 'Teradata' provider is not registered on the local machine

Note: ODBC Driver is installed in server.

what might be the possible reasons for this error?

Thanks,

Saugat

6 REPLIES
Teradata Employee

Re: Unable to connect to Teradata from Qlikview Management Console

An ODBC driver is not a "provider".

If you want to connect via ODBC without a predefined DSN, specify Driver={Teradata} instead of Provider=Teradata.

Re: Unable to connect to Teradata from Qlikview Management Console

Hi,

if i am giving

Driver={Teradata};DBCName=MyDbcName; Database=myDataBase;Uid=myUsername;Pwd=myPassword;

It is throwing an error as :

Keyword not supported: 'driver'.

Could you Please provide the solution?

Teradata Employee

Re: Unable to connect to Teradata from Qlikview Management Console

Looks like QlikView's ODBC CONNECT ... expects a predefined Data Source Name (DSN).

Either use ODBC Control Panel to create a DSN or try OLEDB CONNECT with Provider=MSDASQL,Driver={Teradata}

Teradata Employee

Re: Unable to connect to Teradata from Qlikview Management Console

Or a better approach: don't use ODBC. Install the Teradata OLEDB Provider and use Provider=TDOLEDB.

Re: Unable to connect to Teradata from Qlikview Management Console

Hi Fred,

As per ur suggestion I have also tried

PROVIDER=MSDASQL;DRIVER={Teradata};DBCName=myDBCName;User ID=myUserID;Password=myPassword;

but i am getting the error as:

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

Thanks,

Saugat

Enthusiast

Re: Unable to connect to Teradata from Qlikview Management Console

Great!

Now I can connect!

 

Thanks a lot!