MCv Posted July 25, 2019 Share Posted July 25, 2019 Hi all, I'm trying to connect to an Oracle database at work. I have rights, I have TOAD but I want to automate some stuff. In the TOAD login windows, it says it is connecting using OraClient10g_home1 and this is a screenshot of the Oracle Homes when I click the 3 dots next to OraClient10g_home1: I can find all kinds of strings in the file tnsnames.ora, but so far none work. Anyone any ideas? I tried mLipok's _ADO_GetProvidersList, but there is no local installed Oracle client. The G drive is a network drive. Tried variants of "DRIVER={Oracle in OraClient10g_home1};Server=name;uid=login;pwd=pass;" and "SERVER=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=123.123.123.123)(PORT=1234))(CONNECT_DATA=(SID=xxxx)));uid=login;pwd=pass;" But so far.. nothing. Does anyone have a clue how I can use the TOAD settings and make them work for AutoIt? I suppose I can try automating TOAD itself, but that seems like a lot of unnecessary work. Link to comment Share on other sites More sharing options...
water Posted July 25, 2019 Share Posted July 25, 2019 Have a look at https://www.connectionstrings.com/ for the correct form of the connections tring. My UDFs and Tutorials: Spoiler UDFs:Active Directory (NEW 2022-02-19 - Version 1.6.1.0) - Download - General Help & Support - Example Scripts - WikiExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example ScriptsOutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - WikiOutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - DownloadOutlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - WikiPowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - WikiTask Scheduler (NEW 2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki Standard UDFs:Excel - Example Scripts - WikiWord - Wiki Tutorials:ADO - WikiWebDriver - Wiki Link to comment Share on other sites More sharing options...
MCv Posted July 25, 2019 Author Share Posted July 25, 2019 Thanks, already used those. I was hoping someone could point me in the right direction by telling me which settings from TOAD I should use. Trial and error didn't work so far. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now