DB-Connect impossible after changing Oracle Parameter

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
romanFleischer
Posts: 18
Joined: Wed 02 Jun 2010 16:28

DB-Connect impossible after changing Oracle Parameter

Post by romanFleischer » Fri 04 May 2012 09:25

Hello,

our database provider has to set a special ORACLE parameter because of security issues.
The parameter is SQLNET.ALLOWED_LOGON_VERSION=11.
After seting this parameter it is no loger possible to connect to the database using our dotConnect (5.70.190.0). Do we need another version, or is this only a configuration problem?
We use this connection in our web.config

Code: Select all

<add name="ApplDataModel" connectionString="User Id=xxxx;Password=yyyy;Server=test.anywhere.com;Port=1521;Direct=True;Sid=Appl;Persist Security Info=True" providerName="Devart.Data.Oracle" />

<add name="dotConnect for Oracle" invariant="Devart.Data.Oracle" description="Devart dotConnect for Oracle" type="Devart.Data.Oracle.OracleProviderFactory, Devart.Data.Oracle, Version=5.70.190.0, Culture=neutral, PublicKeyToken=xxxxxxxxxx"/>
Thanks
Roman

Pinturiccio
Devart Team
Posts: 2192
Joined: Wed 02 Nov 2011 09:44

Re: DB-Connect impossible after changing Oracle Parameter

Post by Pinturiccio » Tue 15 May 2012 08:43

The SQLNET.ALLOWED_LOGON_VERSION=11 parameter specifies that only Oracle 11g authentication can be used. You use the Direct mode and dotConnect for Oracle 5.70.190.0, but support for Oracle 11g authentication in the Direct mode has been added in dotConnect for Oracle 6.70.293: ttp://www.devart.com/dotconnect/oracle/revision_history.html

We recommend you to upgrade to the latest version 6.80.350 of dotConnect for Oracle or use the OCI connection mode with your current version 5.70.190 of dotConnect for Oracle.

romanFleischer
Posts: 18
Joined: Wed 02 Jun 2010 16:28

Re: DB-Connect impossible after changing Oracle Parameter

Post by romanFleischer » Tue 15 May 2012 09:39

Thank You for the information. We installed the new version of dotConnect and now it works with the web.config. But again we can not connect to the Database with our databaseExplorer inside Visual Studio 2010. Is there also a new Version available?

Thanks
Roman

Post Reply