Oracle connection

Hi I am revisiting Autoit after a year hiatus and would like some help, I am trying to connect to my Oracle 11g server 'DVA' so that I can remotely create user accounts from AutoIT. I have searched for connections to Oracle but seem to be going in circles, admittedly I am not a big fan of COM and ADO objects and dont fully understand them. I have gotten the code below from the forums but I cannot get it to work for me, please see error below the code. I have a local Oracle client in

By ositstomc, January 31, 2017
2 replies

use my ADO.au3 UDF and this function: _ADO_GetProvidersList() And show which provider names are avalaible in your system. And second thoughts: .ConnectionString =("Provider='OraOLEDB.Oracle';Data Source='DVA';User Id='system';Password='mypass';") this looks wrong for me. Quick look here: https://www.connectionstrings.com/oracle-provider-for-ole-db-oraoledb/ And here is my guess: .ConnectionString ="Provider=OraOLEDB.Oracle;Data Source=DVA;U