Connecting to mysql database in testcomplete
Hi all I'm trying to write a simple script in testcomplete, but I have some problems with it. How can I quickly and easily connect to the MySQL database and perform a simple select query...
Forum Discussion
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 ?
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 ?
