Description
Description
Hi I want to use an oracle wallet as a part of my connection string but I can't seem to be able to get it to work with SqlDataProvider. Initially we were using the username and password credentials in the connection string to connect to the DB but have since switched to using a wallet and the library doesn't seem to support that.
type sql = SqlDataProvider<ConnectionString = "User Id=test_user;Password=test_password ;Data Source=test_db_connectionstring", ResolutionPath",
DatabaseVendor = Common.DatabaseProviderTypes.ORACLE>
When using the wallet, I try using a connection string similar to this:
https://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:9527479800346454884
I have tested the wallet on my machine and I am able to connect to it from the command prompt so there are no issues from the Oracle side.
Repro steps
Replace the original Oracle connection string with a wallet connection string and follow a syntax like this
type sql=SqlDataProvide<ConnectionString="Data Source=ORCL;User ID=/;Min Pool Size=4;Max Pool Size=4";ResolutionPath", DatabaseVendor = Common.DatabaseProviderTypes.ORACLE>
The wallet is created and has been added to tnsname.ora.
Expected behavior
We expect it to connect to the database using the Oracle wallet instead of the connection string with credentials.
Actual behavior
I get an error with invalid username/password;logon denied . I have tried pointing to the wallet_location in the connection string but I am still thrown this error:
Known workarounds
Using the username/password for the user works fine however, we would still like to use the Oracle wallet for our application.
Related information
- Oracle
- Windows 7
- .NET 4.5.2,