Oracle OLE DB - Connection string without password
Hello,
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.
Best,
Alexis
0 answers
Post an answer but please login first
Similar Questions
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 mylogin/mypassword@database.
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 :
ODBC attribute query
hi What does MLD=0 represent in the attribute of a Odbc Connectstring? Thanks N
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".
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.
[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.
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:
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.
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.
- Load more posts