Oracle OLE DB - Connection string without password
I'm working on programmatic queries relying on the Oracle provider for OLE DB (in VB script).
I can successfully query my database using the standard syntax: Provider=OraOLEDB.Oracle;Data Source=MyOracleDB;User Id=myUsername;Password=myPassword;
But how can I make it work without disclosing the password? I have Oracle Wallet running on my server. How could I integrate it with my script? Any other idea?
OS authentication won't work here.
Thank you very much in advance for your suggestions.
re: Having hard time with Microsoft ODBC connection to Oracle
Hello, Could anyone please tell me what do I need to do in order to connect to Oracle 11g through VB script. I already had my tnsnames.ora file set up on my machine and I was able to TNSPING to the Oracle 11g database and I was also able to SQLPLUS firstname.lastname@example.org votes1 answerminh tran3 months ago
Connect UiPath with oracle database 12c
Hi, I want to connect UiPath(Robotic Process Automation) with oralce data base 12c. i tried alot to find the solution via google, but no success. please post your suggestion. I tried with the following string :0 votes1 answerJawad Shirzai5 months ago
ODBC attribute query
hi What does MLD=0 represent in the attribute of a Odbc Connectstring? Thanks N0 votes0 answersN M6 months ago
Oracle SQL Developer version 1.2.1 connection issue
hi, I am using Oracle SQL Developer version 1.2.1. I want to connect to the Database server using VBScript. I wrote the below code but getting an Error "database source not found and no default driver specified".0 votes0 answersSrashti11 months ago
VBA Excel to send data to Oracle..need help
I have a project where I have to send data from an Excel spreadsheet to an Oracle database. I have installed the latest Oracle client and the ODBC drivers.0 votes1 answerHenry Forteon Jan 28, 2017
[ODBC question] I have a question about ODBC connection
Hi everyone I am writing to you to help about connecting Oracle using the ODBC. I have to connect to an Oracle Database that is RAC Environment using a SID. I currently try to connect to an Oracle database using ODBC in C, linux.0 votes0 answersJOO CHon Nov 03, 2016
Error with Oracle ODBC Connection String
We use an ODBC Connection string to connect a SQL database pulling in demographic data from our Oracle student record system. We just upgraded our PeopleTools and changed to a higher version of the Oracle driver which was the only change. The connection string was as follows:0 votes0 answersSue Plankon Oct 03, 2016
Connection string for connecting via LDAP
I want to connect to Oracle Database via c# code using LDAP. Please provide me the connection string which includes server name, service name, user name and password.0 votes0 answersNanditaon Mar 15, 2016
SQL Server Reporting Services 2012 ODBC Connection String
Hi, I am trying to make a new ODBC connection to our company's SQL Server Reporting Services 2012 server to reach an Oracle db, however I've been unsuccessful trying to create the connection string.0 votes2 answersAdam Con Jul 16, 2015
- Load more posts