I'm trying the dotConnect for QuickBooks version 1.6.378.0 (trial version).
This is the error that I'm getting:
An example of the connection string that I'm passing looks like this:System.ArgumentException was unhandled by user code
HResult=-2147024809
Message=Keyword not supported: 'company id'.
Source=EntityFramework
StackTrace:
at System.Data.Entity.Core.EntityClient.Internal.DbConnectionOptions.ParseInternal(IDictionary`2 parsetable, String connectionString, IList`1 validKeywords)
at System.Data.Entity.Core.EntityClient.Internal.DbConnectionOptions..ctor(String connectionString, IList`1 validKeywords)
at System.Data.Entity.Core.EntityClient.EntityConnection.ChangeConnectionString(String newConnectionString)
at System.Data.Entity.Core.EntityClient.EntityConnection..ctor(String connectionString)
at System.Data.Entity.Core.Objects.ObjectContext.CreateEntityConnection(String connectionString)
at System.Data.Entity.Core.Objects.ObjectContext..ctor(String connectionString, String defaultContainerName)
at QuickBooksModel.QuickBooksEntities..ctor(String connectionString) in E:\Projects\Filopto\Version 10 Official\QuickBooks Connector\QuickBooksConnectorModule\FiloptoQB_Business_Logic_Library\QuickBooksDataModel.Designer.cs:line 96
at FiloptoQB_Business_Logic_Library.QBOPaymentAccountsViewModel.LoadData(String pDBServer, String pDBName) in E:\Projects\Filopto\Version 10 Official\QuickBooks Connector\QuickBooksConnectorModule\FiloptoQB_Business_Logic_Library\QBOPaymentAccountsViewModel.cs:line 60
at QuickBooksConnectorModule.QuickBooksMainScreen.SetupDatabaseConnection(String pDatabaseServer, String pDatabasename) in E:\Projects\Filopto\Version 10 Official\QuickBooks Connector\QuickBooksConnectorModule\QuickBooksConnectorModule\QuickBooksMainScreen.xaml.cs:line 157
at QuickBooksConnectorModule.QuickBooksPlugin.DisplayForm(Int32 Top, Int32 Left) in E:\Projects\Filopto\Version 10 Official\QuickBooks Connector\QuickBooksConnectorModule\QuickBooksConnectorModule\QuickBooksPlugin.cs:line 46
InnerException:
"Company Id=XXXX;Access Token=YYYY;Access Token Secret=YYYYsecret;Consumer Key=ZZZZ;Consumer Secret=ZZZZsecret;Sandbox=True"
I replaced the real values, to hide them. I'm using the QuickBooksConnectionStringBuilder to construct the connection string to pass to QuickBooksEntities.
Also, I added the Entity Framework 6 to the project using NuGet.
Any help would be appreciated.
Daniel Rail