Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

connection String to connect to Teradata

Hi All,

I need to connect to Teradata. So in QMC I need to write the connection string in following path:--

QMC-->System-->Supporting Tasks-->Database Command (Within the General tab)

Could you please provide the standard format of connection string to connect to Teradata?

Note:  Teradata Driver is  installed in the server.

Thanks,

Saugat

3 Replies
Kushal_Chawda

Not applicable
Author

T have written the connection string as:

Provider=Teradata;DBCName=MyDBCName;Database=MyDatabase;Uid=MyUId;Pwd=MyPwd;

But I am getting the follwing error.Also teradata driver is installed in the server and configured as well.


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



Thanks