dotConnect DirectMode
Posted: 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>
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>