DB-Connect impossible after changing Oracle Parameter

DB-Connect impossible after changing Oracle Parameter

Postby 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
romanFleischer
 
Posts: 18
Joined: Wed 02 Jun 2010 16:28

Re: DB-Connect impossible after changing Oracle Parameter

Postby 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.
Pinturiccio
Devart Team
 
Posts: 1978
Joined: Wed 02 Nov 2011 09:44

Re: DB-Connect impossible after changing Oracle Parameter

Postby 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
romanFleischer
 
Posts: 18
Joined: Wed 02 Jun 2010 16:28


Return to dotConnect for Oracle