Connecting to mysql database in testcomplete

Hi,



You can use the ADO object. See the "ADO Command Object. Example" help topic.



You can get the correct connection string for MySQL DB from here.

This code probably works because TestComplete does not show errors, so the connection is probably ok?



TestProc function ()

(

var connection = new ActiveXObject ("ADODB.Connection");



var
ConnectionString = "Provider = ADsDSOObject; Password = MYPASS; User
ID =MYUSER; Encrypt Password = False; Data Source = 112.56.12.44;
Location = Products, Mode = Read; Bind Flags = 0; ADSI Flag =- 2147483648"



connection.Open (ConnectionString);

var rs = new ActiveXObject ("ADODB.Recordset");

 

connection.close;

}



Next question now is how to send a simple query? eg (select) here ?

Hi Bartosz,



The following links might be helpful:

http://www.automatedqa.com/support/viewarticle.aspx?aid=9013

http://www.automatedqa.com/newsgroups/d.cgi?cmd=article&group=automatedqa.public.testcomplete&item=35570&utag=

(http://www.automatedqa.com/newsgroups/d.cgi?utag=&cmd=xsearch&group=automatedqa.public.testcomplete&group=automatedqa.public.testcomplete&key=mySQL)