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>
dotConnect DirectMode
Re: dotConnect DirectMode
You are using Microsoft's provider (System.Data.OracleClient). Please create classes from the Devart.Data.Oracle namespace in your code.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) ...