DB-Connect impossible after changing Oracle Parameter

[romanFleischer]

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]

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]

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