odbc mysql 5.3 connection problem

[mLipok]

Please show screenshot from "Driver" tab.

 

[faustf]

is  very strange  because  in odbc  i see  and   also in registry   if i go in 

HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\ODBC Drivers

[faustf]

also my installed program 

[mLipok]

Can you test connection via "User DSN" configuration ?

Try also this:

https://www.connectionstrings.com/dsn/

System DSN

DSN=myDsn;Uid=myUsername;Pwd=;

[faustf]

so in  this  time  i  just  create  a  clean virtual machine  with  windows  7 ,  and  i reinstall all  first  install  vcredist_x64.exe =  visual c++ redistri....  for 64bit platform 

and  after install only  connector mysql 64bit  mysql-connector-odbc-5.3.4-winx64 ,  and  after  , instal  bitnami prestashop , bitnami-prestashop-1.6.1.4-0-windows-installer , i use autoit 32bit 

my script ofcourse not  run the  same  and  the  wiki first script  give  me thesmae  , mor or less

HKCR\CLSID\{0C7FF16C-38E3-11d0-97AB-00C04FC2AD98}|SQLOLEDB|Microsoft OLE DB Provider for SQL Server
HKCR\CLSID\{9E175B8B-F52A-11D8-B9A5-505054503030}|Windows Search Data Source|Microsoft OLE DB Provider for Search
HKCR\CLSID\{c8b522cb-5cf3-11ce-ade5-00aa0044773d}|MSDASQL|Microsoft OLE DB Provider for ODBC Drivers
HKCR\CLSID\{dee35070-506b-11cf-b1aa-00aa00b8de95}|Microsoft.Jet.OLEDB.4.0|Microsoft Jet 4.0 OLE DB Provider
HKCR\CLSID\{dfc8bdc0-e378-11d0-9b30-0080c7e9fe95}|MSDAOSP|Microsoft OLE DB Simple Provider
HKCR\CLSID\{e8cc4cbe-fdff-11d0-b865-00a0c9081c1d}|MSDAORA|Microsoft OLE DB Provider for Oracle
HKCR\CLSID\{FB4CDF30-A741-421d-BCFA-6CC530D053FB}|Microsoft.SQLLITE.MOBILE.OLEDB.3.0|

also try in 32  bit machine 

 

Edited February 18, 2016 by faustf

[faustf]

finally  with   windows 7 32bit  and  connector  32bit   and  autoit 32bit , the script  work good  

 

i must  use a autoit 64bit ??? 

what  you  think?? 

 

[faustf]

is  autoit  32bit  and  64bit system , for  work i must  use  a  64 bit autoit  i  did do this  last test , modify my  script  

in this mode

expandcollapse popup

#cs ----------------------------------------------------------------------------

 AutoIt Version: 3.3.14.2
 Author:         myName

 Script Function:
    Template AutoIt script.

#ce ----------------------------------------------------------------------------

; Script Start - Add your code below here
; Only for SQL server
;Global $oMyError = ObjEvent("AutoIt.Error", "MyErrFunc")
If @AutoItX64 Then
     MsgBox(64, "64-bit", "Running 64-bit AutoIt.")
Else
     MsgBox(16, "32-bit", "Not running 64-bit AutoIt.")
EndIf

_MySQLConnect()
#cs
$objConn = ObjCreate("ADODB.Connection")
;$objConn.Open('DRIVER={MySQL ODBC 5.3 ANSI Driver};SERVER=127.0.0.1;DATABASE=bitnami_prestashop;UID=root;PWD=kronos123;PORT=3306')
$objConn.Open('Provider=MSDASQL;Driver={MySQL ODBC 5.3 ANSI Driver};Server=127.0.0.1;Port=3306;Database=bitnami_prestashop;User=root;Password=kronos123;Option=3;')
$rsCustomers = $objConn.Execute("SELECT * FROM ps_address")
With $rsCustomers
    While Not .EOF
        ConsoleWrite(.Fields("company").Value & " - " & .Fields("last_name").Value & @LF)
        .MoveNext
    WEnd
    .Close
EndWith
#ce



Func _MySQLConnect()
 Local $oErrorHandler = ObjEvent("AutoIt.Error", "_ErrFunc")
Local $sUsername='root'
Local $sPassword='xxxxxxx'
Local $sDatabase='bitnami_prestashop'
Local $sServer='127.0.0.1'
Local $sDriver = "{MySQL ODBC 5.3 ANSI Driver}"
Local $iPort=3306



    $ObjConn = ObjCreate("ADODB.Connection")
    $ObjConn.ConnectionString="DRIVER=" & $sDriver & ";SERVER=" & $sServer & ";DATABASE=" & $sDatabase & ";UID=" & $sUsername & ";PWD=" & $sPassword & ";PORT="&$iPort
    $Objconn.open ()


    $rsCustomers = $objConn.Execute("SELECT * FROM ps_address")
With $rsCustomers
    While Not .EOF
        ;ConsoleWrite(.Fields("company").Value & " - " & .Fields("last_name").Value & @LF)
        MsgBox(0,'',.Fields("company").Value & " - " & .Fields("last_name").Value & @LF)
        .MoveNext
    WEnd
    .Close
EndWith
    $objConn.Close
EndFunc   ;==>_MySQLConnect




Func _ErrFunc($oError)
    ; Do anything here.
    ConsoleWrite(@ScriptName & " (" & $oError.scriptline & ") : ==> COM Error intercepted !" & @CRLF & _
            @TAB & "err.number is: " & @TAB & @TAB & "0x" & Hex($oError.number) & @CRLF & _
            @TAB & "err.windescription:" & @TAB & $oError.windescription & @CRLF & _
            @TAB & "err.description is: " & @TAB & $oError.description & @CRLF & _
            @TAB & "err.source is: " & @TAB & @TAB & $oError.source & @CRLF & _
            @TAB & "err.helpfile is: " & @TAB & $oError.helpfile & @CRLF & _
            @TAB & "err.helpcontext is: " & @TAB & $oError.helpcontext & @CRLF & _
            @TAB & "err.lastdllerror is: " & @TAB & $oError.lastdllerror & @CRLF & _
            @TAB & "err.scriptline is: " & @TAB & $oError.scriptline & @CRLF & _
            @TAB & "err.retcode is: " & @TAB & "0x" & Hex($oError.retcode) & @CRLF & @CRLF)
EndFunc   ;==>_ErrFunc


;Global $sConnectionString = 'Dsn=PostgreSQL30;database=bitnami_openerp;server=127.0.0.1;port=5432;uid=postgres;pwd=kronos123'

and  save  and  right click , and  run 64bit , and  work all good

  but  now  i have another  questions       , how  set scite  for use 64 bit autoit ? 

i open also  another tread  i think is  much better , thankz  at  all for support 

you are  the  best community for programming

 

Edited February 18, 2016 by faustf

[faustf]

i  answer me  i find  in forum is simple   use at top 

this  #AutoIt3Wrapper_UseX64=Y