Forum Discussion

obaid_shirwani's avatar
obaid_shirwani
Contributor
7 years ago

Executing MySQL query to fetch records

Hi folks,

 

I have to execute many MySQL queries to Fetch/Delete/Insert/Update records in MySQL Database. I am unable to create a connection. How will all be done. (Suppose I have to execute 'SELECT * FROM myDataTable')

 

I am using Windows 7 64 Bit and have installed the MySQL ODBC 5.3 Connector.

 

I am trying to write the following code:

 

function extractFromMySqlServer2()
{
var aCon = ADO.CreateADOConnection();
aCon.ConnectionString = "Driver={MySQL ODBC 5.3 Driver};Server=10.80.11.196;Port=3306;Database=tksqa;USER=qauser;PASSWORD=qa123;Option=3;";
aCon.Open();
aCon.Close();
}

 

But it crashes on execution.

 

How to perform this task?

 

Regards,

 

Obaid Shirwani