ADO.au3 UDF - BETA - Support Topic

[Zmylna]

ok, I already understand what you are writing about.
I need to use $oRecordset.getrows() to get the data from SQL.

This way it works correctly
On the SQL server side, only one query is shown - that was the point.
Thank you for your help.

[mLipok]

On 3/19/2019 at 4:21 PM, snoopie said:

    $sRecordset = _ADO_Recordset_ToString($oRecordset, "|", False)      ;Creates duplicate execution of $Query  
    
    $aRecordset = _ADO_Recordset_ToArray($oRecordset)                   ;Creates two more dublicates

pelase comment all 

$oRecordset.moveFirst()

and check again.

[mLipok]

after reading:

https://learn.microsoft.com/en-us/office/client-developer/access/desktop-database-reference/cursoroptionenum

Quote

adMovePrevious

0x200

Supports the MoveFirst and MovePrevious methods, and Move or GetRows methods to move the current record position backward without requiring bookmarks.

this change:

;~          $oRecordset.moveFirst()
            If $oRecordset.Supports($ADO_adMovePrevious) Then $oRecordset.moveFirst()

should be added.
please try it and say what results you have

Edited September 25, 2023 by mLipok

[MojoeB]

Hello everyone I just tested ADO.au3 for MySql because the latest MariaDB version does not work with the existing *DLL here in the form.

Unfortunately nothing happens with me in the example no errors but also no result in the console, username password ip etc is customized by me.

Is there a working example or can someone tell me what I am doing wrong, is this actually nothing else than the example from the udf?

((ip is not public is only here network internal!))

 

#include "ADO.au3"
#Tidy_Parameters=/sort_funcs /reel
#AutoIt3Wrapper_Run_AU3Check=Y
#AutoIt3Wrapper_Au3Check_Parameters=-d -w 1 -w 2 -w 3 -w 4 -w 5 -w 6 -w 7

#AutoIt3Wrapper_Run_Au3Stripper=Y
#Au3Stripper_Parameters=/RM

#include <Array.au3>
#include <MsgBoxConstants.au3>
#include <AutoItConstants.au3>

_Example_MySQL()

Func _Example_MySQL()
    ; Link to Windows MySQL ODBC drivers
    ; https://dev.mysql.com/downloads/connector/odbc/

    Local $sDriver = 'MySQL ODBC 8.2 Unicode Driver' ; 'MySQL ODBC 5.3 UNICODE Driver'
    Local $sServer = '11.45.4.73' ; change this string to YourServerLocation
    Local $sDatabase = 'TESTDB' ; change this string to YourDatabaseName
    Local $sPort = '3306' ; change this string to If your Server use non standard PORT
    Local $sUser = 'username' ; change this string to YourUserName
    Local $sPassword = 'password' ; change this string to YourPassword
    Local $sConnectionString = _ADO_ConnectionString_MySQL($sUser, $sPassword, $sDatabase, $sDriver, $sServer, $sPort)

    _Example_1_RecordsetToConsole($sConnectionString, "SELECT * FROM `t2`")
    _Example_1_RecordsetToConsole($sConnectionString, "SELECT * FROM t2")

    _Example_3_ConnectionProperties($sConnectionString)
    
   endfunc

 

Edited November 7, 2023 by MojoeB

[n3wbie]

First of all thanks for the udf i have been using it for multiple database connections and Odbc connections.

While trying to connect to access db i am not able to Read the database.

I will share the snippet here for reference

Local $sMDB_FileFullPath = "D:\CommonMIS.mdb" ;'Here put FileFullPath to your Access File'
    Local $sDriver = Default
    Local $sUser = Default
    Local $sPassword = Default

    Local $sConnectionString = _ADO_ConnectionString_Access($sMDB_FileFullPath, $sUser, $sPassword, $sDriver)

    _Example_1_RecordsetToConsole($sConnectionString, "SELECT static_MIS.* FROM static_MIS;")
    _Example_2_RecordsetDisplay($sConnectionString, "SELECT static_MIS.* FROM static_MIS;")
    _Example_3_ConnectionProperties($sConnectionString)

The Above Code is directly from example file. I havnt altered any of the code expect file path. Example functions are also from UDF example file directly without any modifications.Version used is latest one 2.1.19

I also Tried $sUser as "Admin" as the default value available after starting access is admin.

I am using ms access 10. for purpose of Driver i have user DSN as name MS access Database and Driver Microsoft Access Driver (*.mdb,*3.accdb)

in drivers tab i dont have anything related to Ms access.

I would be Thankful for Any help on this matter 

[n3wbie]

On 11/7/2023 at 3:02 PM, MojoeB said:

Hello everyone I just tested ADO.au3 for MySql because the latest MariaDB version does not work with the existing *DLL here in the form.

Unfortunately nothing happens with me in the example no errors but also no result in the console, username password ip etc is customized by me.

Is there a working example or can someone tell me what I am doing wrong, is this actually nothing else than the example from the udf?

((ip is not public is only here network internal!))

 

#include "ADO.au3"
#Tidy_Parameters=/sort_funcs /reel
#AutoIt3Wrapper_Run_AU3Check=Y
#AutoIt3Wrapper_Au3Check_Parameters=-d -w 1 -w 2 -w 3 -w 4 -w 5 -w 6 -w 7

#AutoIt3Wrapper_Run_Au3Stripper=Y
#Au3Stripper_Parameters=/RM

#include <Array.au3>
#include <MsgBoxConstants.au3>
#include <AutoItConstants.au3>

_Example_MySQL()

Func _Example_MySQL()
    ; Link to Windows MySQL ODBC drivers
    ; https://dev.mysql.com/downloads/connector/odbc/

    Local $sDriver = 'MySQL ODBC 8.2 Unicode Driver' ; 'MySQL ODBC 5.3 UNICODE Driver'
    Local $sServer = '11.45.4.73' ; change this string to YourServerLocation
    Local $sDatabase = 'TESTDB' ; change this string to YourDatabaseName
    Local $sPort = '3306' ; change this string to If your Server use non standard PORT
    Local $sUser = 'username' ; change this string to YourUserName
    Local $sPassword = 'password' ; change this string to YourPassword
    Local $sConnectionString = _ADO_ConnectionString_MySQL($sUser, $sPassword, $sDatabase, $sDriver, $sServer, $sPort)

    _Example_1_RecordsetToConsole($sConnectionString, "SELECT * FROM `t2`")
    _Example_1_RecordsetToConsole($sConnectionString, "SELECT * FROM t2")

    _Example_3_ConnectionProperties($sConnectionString)
    
   endfunc

 

1. What driver are you using 8.2?

go to start menu Search for ODBC connections.

There might be 64 and 32 Bit Options . Try to Open Both. 

Check the version and See What Odbc drivers u have.

Try Using All the Possible Combinations. For Me ANSI worked Well.

I know m too late to respond but i just hope not too late to respond

[mLipok]

I just found interestning portal:

https://dbfiddle.uk/BVFPxPRb

If you ask me I can say it is comparable to:

https://regex101.com/

but it works with SQL and not with RegExp

[jchd]

That site is based on MS SQL server.  <-- NO, my bad.

For those who look for a SQLite equivalent: https://sqlite.org/fiddle/index.html

Edited May 7 by jchd

[mLipok]

1 hour ago, jchd said:

That site is based on MS SQL server
For those who look for a SQLite ....

?

https://dbfiddle.uk/UHaCluaY

Edited May 7 by mLipok

[jchd]

You're right, I didn't look closely.

Yet SQLite v3.39.1 is almost 2 years old, current release is 3.45.3

[dsm-sas]

Hi,

I use ADO Version 2.1.15 Beta. Everything SUPER.

But now I want to use 2 databases and this doesn't work.

I tried with _ADO_CONNECTION_CLOSE but get allways: Object does not exist. Here is my small sub_func:

Func DB_disconnect()
    ; declaring static Connection String
    Local Static $sConnectionString = _ADO_API_ConnectionString()
    If @error then Return SetError(@error, @extended, Null)

    ; declaring static Connection Object
    Local Static $oConnection = _ADO_Connection_Create()
    If @error then Return SetError(@error, @extended, $ADO_RET_FAILURE)
    _ADO_Connection_Close($oConnection)

;;;;; and here I get the ERROR  "closed Object  can not be used"
EndFunc

 

IU also tried just make a new connect with new ConnectionString -> Still have the connect to the first db.

 

Anyone any ideas or tip or trick?

THX's

 

[Jos]

I do not see any open function first.