Forum Discussion
mkirkland
11 years agoContributor
Can i have some assistance setting up a script to connect to the MySQL Database?
My scripts are in the jscript format, do i need to install ANYTHING 3rd party for this to connect? i.e. Oracle software
I think im confused on the connection string information
Here is what i am trying so far, but it fails:
function ado(){
var aCon;
// Creates ADO connection
aCon = ADO.CreateConnection();
// Sets up the connection parameters
aCon.ConnectionString = "Driver={MySQL ODBC 5.2 ANSI Driver};Server=192.168.0.128;"
"Port=3306;Option=4;Database=HealthCheck;Uid=testcomplete;Pwd=test;";
// Opens the connection
aCon.Open();
aCon.Close();
}
My scripts are in the jscript format, do i need to install ANYTHING 3rd party for this to connect? i.e. Oracle software
I think im confused on the connection string information
Here is what i am trying so far, but it fails:
function ado(){
var aCon;
// Creates ADO connection
aCon = ADO.CreateConnection();
// Sets up the connection parameters
aCon.ConnectionString = "Driver={MySQL ODBC 5.2 ANSI Driver};Server=192.168.0.128;"
"Port=3306;Option=4;Database=HealthCheck;Uid=testcomplete;Pwd=test;";
// Opens the connection
aCon.Open();
aCon.Close();
}
Related Content
- 4 years agoPUM-Prodat-SQL
- 7 years agoGaleG
Recent Discussions
- 5 hours agoSubhraDas
- 18 hours agoJacobjacob44