Can anyone help me out on connection between QTP & Teradata.
I am looking for the code in VB Script object creation and not database checkpoint.
As far as I know , there is no such VB code for connection between QTp and Teradata.
BTW what type of operation you want to perform ?
Certified HP consultant
Check below links http://www.w3schools.com/ADO/default.asp http://www.connectionstrings.com/teradata
i have never seen bugs sleeping
Use below snippet
Srvname= "DATA SOURCE=MyServerName; Persist Security Info=True;UID=MyUsid;PWD=MyPassWord"
This will work [img]/images/graemlins/smile.gif[/img]
objCon.Open "Data Source=Teradata_Connect; Database=*****; Persist Security Info=True; User ID=****; Password=****; Session Mode=ANSI;"
Set MyRecordset = objCon.Execute(QueryName)
Teradata_connect is my data source name.
For above code you need to have Teradata ODBC driver installed which comes with whole TERADATA INSTALALTION AND IT IS NOT FREE OF COST.