database connection using testcomplete
i need to connect to database and use the user login and password from db, how can i connect to sql and get data thanks Mahender
Forum Discussion
karthick7's solution doesn't relate to the OP. NisHera has the correct documentation for doing a direct to DB ADO connection.
If you intend to do something more on the lines of looping through a set of data records, you could use the DDT.ADODriver
I'm in agreement with NisHera and tristaanogre. (also that karthick7's answer has nothing to do with the question!)
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.
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
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
