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
1 answer
I am facing the same problem. Have you found any answer?? If so please share here.
Post an answer but please log in first
Similar Questions
connect from Oracle to MS SQL Server
I want to Connect from Oracle to MS SQL Server with a connection string to pass location (IP) / username / Password and SQL Database !
Difference between OraOLEDB.Oracle and OraOLEDB.Oracle.1
What is the different between these two connection strings? Provider=OraOLEDB.Oracle;Data Source=MyOracleDB;User Id=myUsername; Password=myPassword; Provider=OraOLEDB.Oracle.1;Data Source=MyOracleDB;User Id=myUsername;
Connecting to Oracle using python's pyodbc library
I am trying to connect to Oracle 12c R1 using the python library pyodbc. I am having zero luck. Can anybody help? thx in advance!
[ODBC Manager] Data Source Name too long
ODBC connection in Oracle . Have written a VB script which connects to an Oracle database using ODBC connection string. When trying to connect its gives me an error [Microsoft][ODBC Manager] Data Source Name too long.
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.
- Load more posts