PostgreSQL Query

[MistakenSanity]

Can someone help me with returning a postgreSQL query?  I have gotten the code to connect to the database working, but I am unable to actually run a query, i just get an error return every time.  I have successfully done so with MySQL.  From looking at other examples the setup to do so is a bit different for postgreSQL, but when using those examples i get a failure.

 

expandcollapse popup

;====================  AUTOIT WRAPPER START  ====================
            #AutoIt3Wrapper_UseX64=n
;====================  AUTOIT WRAPPER STOP  ====================










;====================  INCLUDES START  ====================
            #include <Array.au3>
;====================  INCLUDES STOP  ====================










;====================  VARIABLES START  ====================
            $TEMP_QueryReturn = ObjCreate("ADODB.Recordset")

            Global $SETTING_Driver = "PostgreSQL Unicode"
            Global $SETTING_Server = "192.168.1.12"
            Global $SETTING_Port = "5432"
            Global $SETTING_DatabaseName = "test"
            GLobal $SETTING_Username = "test"
            Global $SETTING_Password = "test"
            Global $SETTING_Query = 'SELECT * FROM settings'

            $oMyError = ObjEvent("AutoIt.Error","MyErrFunc") ; Install a custom error handler
;====================  VARIABLES STOP  ====================










;====================  CONNECT TO DATABASE START  ====================
            Global $Connection = ObjCreate("ADODB.Connection")
;~          $Connection.open ("DRIVER=" & $SETTING_Driver & ";SERVER=" & $SETTING_Server & ";DATABASE=" & $SETTING_DatabaseName & ";UID=" & $SETTING_Username & ";PWD=" & $SETTING_Password & ";PORT=" & $SETTING_Port)
            $Connection.open ("DSN=PostgreSQL;DATABASE=test;SERVER=192.168.1.12;Port=5432;Uid=test;Pwd=test")
            If @error Then MsgBox(0,"","Error Opening Connection")
;====================  CONNECT TO DATABASE STOP  ====================










;====================  RUN QUERY START  ====================
            $TEMP_QueryReturn.open($SETTING_Query,$Connection,1,3)
            If @error Then MsgBox(0,"","Error Executing Query")
;====================  RUN QUERY STOP  ====================

 

Edited October 22, 2020 by MistakenSanity

[mLipok]

You shuold add COM ERROR HANDLER:
Check first example from here:

https://www.autoitscript.com/autoit3/docs/functions/ObjEvent.htm

 

but I I encourage you to use 

 

Also you could use:
_ADO_GetDSNList()
_ADO_GetProvidersList()

to check which Driver/Provider you have installed......

 

Edited October 22, 2020 by mLipok