My Sql connection

[Rammanan]

Hi all ,

Below the code i use for insert data into Mysql. But show below error. Please advice if any thing wrong.

#include <Array.au3>
#include <File.au3>
#include <mysql.au3>

Func connectDB()
    $sqlCon = ObjCreate("ADODB.Connection")
    $sqlCon.Open = _MySQLConnect("Driver={MySQL ODBC 3.51 Driver};Server=" ";Port=3306;Database=" ";User=" ";Password=" ";Option=3;")

    Return $sqlCon
EndFunc
    $conn=connectDB()
    $results=$conn.Execute ("SELECT * FROM clotho_license",@LF)
msgbox(0,"test",$results)
if @error Then
    MsgBox(0, "ERROR", "Failed to connect to the database")
    Exit
Else
   _SQLite_Exec(-1, "INSERT INTO clotho_license(id,PC_Name,Mac_Address) VALUES ('c','2','World');") ; INSERT Data
EndIf

"C:\Users\int5217\Desktop\New AutoIt v3 Script (2).au3" (26) : ==> Incorrect number of parameters in function call.:
$sqlCon.Open = _MySQLConnect("Driver={MySQL ODBC 3.51 Driver};Server=" ";Port=3306;Database="  ";User=" ";Password=" ";Option=3;")
$sqlCon.Open = ^ ERROR

[Skeletor]

Read this post by @cdkid and you will get to see how they connect to the db. 
This ($sqlCon.Open) is wrong.

$sql = _MySQLConnect("sa","sa","mydb","mywebsite.com")

 

Edited November 15, 2018 by Skeletor

[mLipok]

Try my ADO.au3 UDF   .

Read also example about How To use COM ERROR HANDLER

 

[Rammanan]

@mLipok

This show MS sql connection, i'm trying MYSQL

[Rammanan]

I try below code but no error show also no output write at .txt file. Please advice.

#include <Array.au3>
#include <File.au3>
#include <mysql.au3>

$SQLInstance = _MySQLConnect ($UserName, $Password, $Database, $MySQLServerName)
If @error Then
    MsgBox(16, "Fail", "Couldn't connect to database")
 Else
    MsgBox(0, "Success!", "Connection to database successful!")
    Exit
EndIf

$SQLCode = "SELECT * FROM clotho_license WHERE PC_Name = 'PR-EG2001-46' "
$TableContents = _Query ($SQLInstance, $SQLCode)
With $TableContents
   While NOT .EOF
      FileWriteLine("C:\test\test.txt",.Fields("Description").value & @CRLF)
      .MoveNext
   WEnd
EndWith

 

[mLipok]

6 hours ago, Rammanan said:

@mLipok

This show MS sql connection, i'm trying MYSQL

The way how You should use ADO and COM Error Handler in AutoIt is the same for both data base system.

 

Edited November 16, 2018 by mLipok