database connection using testcomplete

Question

i need to connect to database and use the user login and password from db, how can i connect to sql and get data&nbsp;&nbsp;thanksMahender

nishera · Answer

This&nbsp;is what you need.building connection string could be tricky&nbsp;you can refer&nbsp;this

tristaanogre · Answer

karthick7's solution doesn't relate to the OP. &nbsp;NisHera&nbsp;has the correct documentation for doing a direct to DB ADO connection.
&nbsp;
If you intend to do something more on the lines of looping through a set of data records, you could use the DDT.ADODriver

colin_mccrae · Answer

I'm in agreement with NisHera&nbsp;and tristaanogre. (also that karthick7's answer has nothing to do with the question!)
&nbsp;
Also worth adding that if you're not sure about the connection string, speak to the development team rather than trying to guess. It's their database and they should understand, and so be able to tell you, it's connection requirements.
&nbsp;
Also, make sure you have the 32 bit drivers installed. See the note here: https://support.smartbear.com/testcomplete/docs/testing-with/advanced/working-with-external-data-sources/databases/index.html

karthick7 · Answer

try&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; {&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; //var excelName = "C:\TestData.xls"&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; var excelFileName = "Test"&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; var excelConnection = new Sys.OleObject("ADODB.Connection");&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; var str_Connection = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source = " + excelFileName + ";Persist Security Info=False;Extended Properties=Excel 8.0;"&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; excelConnection.Open(str_Connection);&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; var excel_recordSet = new Sys.OleObject("ADODB.Recordset");&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; var excelQuery = select * from login;(example)&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; excel_recordSet.Open(excelQuery, excelConnection);&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; if(!excel_recordSet.bof)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; {&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; try&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; {&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; resultValue = aqConvert.VarToStr(excel_recordSet.fields.Item(ColumnName));&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; }&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; catch(e)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; {&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; resultValue =&nbsp; undefined;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; }&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; }&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; excel_recordSet.Close();&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; excelConnection.Close();

karthick7 · Answer

Colin_McCraetristaanogrei view about ADODB Method,i just pasted that code for using ADODB CONNECTION.we can connect excel or database through ADODB method.just pasted code for excel connection,anyway logic is same

Forum Discussion

database connection using testcomplete

Related Content

Database Connection

database connection through groovy

How to connect to DBArtisan database?

TestComplete: Database connection error (SQL Server does not exist or access denied)

Cannot Connect to New Database Server using ADO

Recent Discussions

How is test complete using our data while using the inbuilt AI feature ?

Problems by validating a tooltip of a wpf application

Login for Zephyr is through Microsoft 365 and TestComplete can't complete login

Testing on a local iPad

Is it possible to add Device Info from a remote browser to the Log Folder?