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
Oracle Provider for OLE DB connection strings pool
Oracle Provider for OLE DB connection strings can use connection pool?
Escaping a semicolon in Oracle Connection String
Hi, I hope you can help me with my (hopefully) easy problem :) I am using the following connectionstring to connect to the Database in VBA: strCon2 = "Driver={Oracle in OraClient11g_home2};Dbq=MY_SERVICE_NAME;" & _
Oracle ODBC x86 and x84 on Excel 32bits.
I have the Oracle Runtime 11g 32 bits and the 12c Runtime 64bits instaled on my system, and i would like to know if is possible to use the 32bits Oracle 11g(11.2.0.1) ODBC driver on my Excel.
Can't connect to local Oracle 11g express
Hello. I have an Oracle 11g Express installation on my personal Windows 7 PC. Its DB name is the default - XE. I can connect to it in sqlplus just fine.
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...
- Load more posts