connecting Autoit and mysql

[Subin]

how to connect auto it and mysql.

i tried the below code. but gtting error in line no 15"(15) : ==> Variable must be of type "Object".:"

Global $adCN

$constrim="DRIVER={MySQL ODBC 5.1 Driver};SERVER=172.16.194.12;DATABASE=crossref;uid=tester;pwd=tester;PORT=3306"
$adCN = ObjCreate ("ADODB.Connection")
$adCN.Open ($constrim)
MsgBox(0,"",$constrim )
if @error Then
    MsgBox(0, "ERROR", "Failed to connect to the database")
    Exit
Else
   MsgBox(0, "Success!", "Connection to database successful!")
EndIf
$sQuery= "SELECT sku FROM products WHERE manufacturer_part_number ='W67003' AND supplier_part_number ='W67003' AND price ='10' AND uom = 'EA'"
$result = $adCN.Execute($sQuery)
MsgBox(0, "",$result.Fields( "sku" ).Value)
$adCN.Close ; ==> Close the database


 

[JohnOne]

I've not done it,but you should take some time to look through the example scripts forum, there are some User Defined Functions there which will help you.

[JLogan3o13]

Such as the mysql UDF at this link:

[Subin]

whats problem on this query

 

Global $adCN

$constrim="DRIVER={MySQL ODBC 5.1 Driver};SERVER=172.16.194.12;DATABASE=crossref;uid=tester;pwd=tester;PORT=3306"
$adCN = ObjCreate ("ADODB.Connection")
$adCN.Open ($constrim)
MsgBox(0,"",$constrim )
if @error Then
    MsgBox(0, "ERROR", "Failed to connect to the database")
    Exit
Else
   MsgBox(0, "Success!", "Connection to database successful!")
EndIf
$sQuery= "SELECT sku FROM products WHERE manufacturer_part_number ='W67003' AND supplier_part_number ='W67003' AND price ='10' AND uom = 'EA'"
$result = $adCN.Execute($sQuery)
MsgBox(0, "",$result.Fields( "sku" ).Value)
$adCN.Close ; ==> Close the database

Edited January 5, 2015 by Subin

[SmOke_N]

Did you actually download the driver?

[Subin]

i am coonecting using MySQL ODBC 3.51 Driver

[water]

You need to add some error handling to see what goes wrong.

Have a look at ObjEvent how to add a COM error handler to your script.

[bogQ]

I used EzMySql in the past from JLogan3o13 link on post #3 with no problems in Wamp so i did not need to mess with installing ODBC Driver.

My question is if have code "DRIVER={MySQL ODBC 5.1 Driver};

and he is using ODBC 3.51 to connect shouldnt that cause some problems?

Edited January 5, 2015 by bogQ

[water]

Or even easier to get better error information add the following code at the top of your script:

#include <Debug.au3>
_DebugSetup()
_DebugCOMError()