The Wayback Machine - https://web.archive.org/web/20201110213526/https://github.com/fsprojects/SQLProvider/issues/682
Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Provide access to the OracleConfiguration #682

Open
rjmccann101 opened this issue Jun 10, 2020 · 3 comments
Open

Provide access to the OracleConfiguration #682

rjmccann101 opened this issue Jun 10, 2020 · 3 comments

Comments

@rjmccann101
Copy link

@rjmccann101 rjmccann101 commented Jun 10, 2020

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?

@Thorium
Copy link
Member

@Thorium Thorium commented Jun 10, 2020

Is this a design-time (static parameter) or runtime (parameter for GetDataContext-method) problem?

I don't have an access to Oracle DB, but I can accept the PR if someone else creates it.

@rjmccann101
Copy link
Author

@rjmccann101 rjmccann101 commented Jun 10, 2020

I think it needs to be design-time, the provider just reports an error in the editor right now.

@Thorium
Copy link
Member

@Thorium Thorium commented Jun 10, 2020

Just note static parameters have to be primitive types (string, enum, ...) and cannot be discriminated unions.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
2 participants
You can’t perform that action at this time.