Provide access to the OracleConfiguration

Open
#682 3 comments 0 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

Assessment

Difficulty
4/5
Estimated time
3-5 days
Newbie friendliness
35/100
Issue type
Feature
Clarity
Mostly clear
Activity status
Stale
Tech stack
fsharp, sql
Domain
databases

Research direction

Start by locating the data provider's connection setup and how OracleConfiguration is currently accessed. Determine the intended parameter shape and whether equivalent settings for other databases are in scope; done means username/password connections can override SQLNET.AUTHENTICATION_SERVICES without changing the environment.

Written by the indexing model from the issue text.

Description

enhancement Oracle

In my work environment the default SQLNET.ORA file has SQLNET.AUTHENTICATION_SERVICES set to nts and kerberos5 - these are the company standards and I can't do anything about them. When I want to connect to Oracle using Dotnet Core I have to use a username and password and in my own code I end up having to use OracleConfiguration to set SqlNetAuthenticationServices to "none". There's details on my question https://stackoverflow.com/questions/59424123/kerberos-error-when-connecting-to-oracle-database-in-net-core/59424124#59424124.

So with the data provider there is no way to override the authentication method as far as I can see. I can get around the problem by changing my environment before running VSCode so I have my own SQLNET.ORA but it's not an ideal situation.

Could an new parameter be added to the data provider that allows OracleConfiguration and the equivalents for other databases to be set before the data provider makes it's connection to the database?

Dominant language
F#
Stars
627
Forks
147
Avg merge
2h 2m
Merged PRs (30d)
1

Contributor guide

No contributing guide indexed for this repository

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

More from fsprojects/SQLProvider

All issues in fsprojects/SQLProvider

Similar issues

More Databases issues

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.