JohnComputerGuy Posted May 30, 2014 Share Posted May 30, 2014 Help I am trying to connect to servers that have multiple Oracle DB's. I was able to connect fine when I was connecting to just one DB on a server. This below code worked fine when DB admin only had one DB on a server. The only thing I have changed was names and passwords but this code worked fine before. Where do I pass the DB name? The Servers are running Oracle 11G and 9I and 10; The server OS is Linux. The autoIt script is running on XP 32 bit and is AutoIt 3 $ConnectionString = "Driver={Microsoft ODBC for Oracle};Server=ServerBox;Uid=UserID;Pwd=password" Link to comment Share on other sites More sharing options...
water Posted May 30, 2014 Share Posted May 30, 2014 Oracle Connection Strings can be found here. JohnComputerGuy 1 My UDFs and Tutorials: Spoiler UDFs: Active Directory (NEW 2024-07-28 - Version 1.6.3.0) - Download - General Help & Support - Example Scripts - Wiki ExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example Scripts OutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - Wiki OutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - Download Outlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - Wiki PowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - Wiki Task Scheduler (2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki Standard UDFs: Excel - Example Scripts - Wiki Word - Wiki Tutorials: ADO - Wiki WebDriver - Wiki Link to comment Share on other sites More sharing options...
Solution JohnComputerGuy Posted June 2, 2014 Author Solution Share Posted June 2, 2014 ConnectionString =("Provider='OraOLEDB.Oracle';Data Source='DBName';User Id='myUser';Password='myPassWord';") This turn out to be the Syntax for this problem; Thanks for the help I will bookmark the Oracle Dot Net documentation that was posted for future help. John Link to comment Share on other sites More sharing options...
water Posted June 2, 2014 Share Posted June 2, 2014 My UDFs and Tutorials: Spoiler UDFs: Active Directory (NEW 2024-07-28 - Version 1.6.3.0) - Download - General Help & Support - Example Scripts - Wiki ExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example Scripts OutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - Wiki OutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - Download Outlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - Wiki PowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - Wiki Task Scheduler (2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki Standard UDFs: Excel - Example Scripts - Wiki Word - Wiki Tutorials: ADO - Wiki WebDriver - Wiki 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