dotConnect DirectMode

dotConnect DirectMode

Postby kamishetty » Wed 06 Jun 2012 19:58

Hi,

I have purchased dotConnect for Oracle and trying to use it in a .NET winforms and windows services application. I have added the Devart.Data.dll and Devart.Data.Oracle.dll references and generated the license.licx file. But at run time, when the app connects to oracle it fails with the following message. Please let me know what I am missing as I have already spent a day trying to fix this problem. - Thanks.

Error:
System.ArgumentException: Keyword not supported: 'direct'.
at System.Data.Common.DbConnectionOptions.ParseInternal(Hashtable parsetable, String connectionString, Boolean buildChain, Hashtable synonyms, Boolean firstKey)
at System.Data.Common.DbConnectionOptions..ctor(String connectionString, Hashtable synonyms, Boolean useOdbcRules)
at System.Data.OracleClient.OracleConnectionString..ctor(String connectionString)
at System.Data.OracleClient.OracleConnectionFactory.CreateConnectionOptions(String connectionOptions, DbConnectionOptions previous)
at System.Data.ProviderBase.DbConnectionFactory.GetConnectionPoolGroup(String connectionString, DbConnectionPoolGroupOptions poolOptions, DbConnectionOptions& userConnectionOptions)
at System.Data.OracleClient.OracleConnection.ConnectionString_Set(String value)
at System.Data.OracleClient.OracleConnection.set_ConnectionString(String value)
at Microsoft.Practices.EnterpriseLibrary.Data.Database.CreateConnection()

Connection String:

'User ID=testuser;Password=testpwd;Direct=true;Data Source =testsource;Port = 1234;SID=test'

Config:
<system.data>
<DbProviderFactories>
<remove invariant="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=6.80.350.0, Culture=neutral, PublicKeyToken=09af7300eec23701" />
</DbProviderFactories>
</system.data>
kamishetty
 
Posts: 1
Joined: Wed 06 Jun 2012 19:39

Re: dotConnect DirectMode

Postby Shalex » Thu 07 Jun 2012 10:05

kamishetty wrote:
Code: Select all
...
at System.Data.OracleClient.OracleConnectionString..ctor(String connectionString)
at System.Data.OracleClient.OracleConnectionFactory.CreateConnectionOptions(String connectionOptions, DbConnectionOptions previous)
...
at System.Data.OracleClient.OracleConnection.ConnectionString_Set(String value)
at System.Data.OracleClient.OracleConnection.set_ConnectionString(String value)
...

You are using Microsoft's provider (System.Data.OracleClient). Please create classes from the Devart.Data.Oracle namespace in your code.
Shalex
Devart Team
 
Posts: 7774
Joined: Thu 14 Aug 2008 12:44


Return to dotConnect for Oracle