obaid_shirwani
7 years agoContributor
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