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
INSERT ALL Statment with OraOleDb.oracle
I need to insert in oracle db multiple rows with INSERT ALL statment. I note oraoledb.oracle provieder doesn't run with this statment. It needs Driver={Oracle in OraClient11g_home1} connection. It is correct?
Issue connection an ASP.Net site with two Oracle database on same server
Hi I've taken over a ASP.Net site using an Oracle back-end, I can get it to connect to the database on our development PCs but on the live server, I'm having an issue as follow and wonder if anyone could help as not an Oracle expert and the Oracle server was setup many years ago...
Issue connection an ASP.Net site with two Oracle database on same server
Hi I've taken over a ASP.Net site using an Oracle back-end, I can get it to connect to the database on our development PCs but on the live server, I'm having an issue as follow and wonder if anyone could help as not an Oracle expert and the Oracle server was setup many years ago...
Issue connection an ASP.Net site with two Oracle database on same server
Hi I've taken over a ASP.Net site using an Oracle back-end, I can get it to connect to the database on our development PCs but on the live server, I'm having an issue as follow and wonder if anyone could help as not an Oracle expert and the Oracle server was setup many years ago...
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.
- Load more posts