Hi,

  I am using QuickBook 2005 Pro (UK) With QODBC6 - things seems to work OK - but when I try to use QODBC as an ODBC connection in VS2005 (C#), it sets up OK and tests OK, but the setup cannot complete because of the  error below...

I have tried switching on/off ODBC compatibilty mode in QODBC but did not make any difference.

Does anybody know what this problem is and how to get around it?

Thanks for any help you can offer.

If you try to add a QODBC database as a datasource in the datasource box, you will get the message "An error occured while retrieving the information from the database: An item with the same key has already been added." as you show.

However if you go the dataset designer and add a tableadapter it will create the table and add it to the datasources.  Only problem with doing it this way is that the UPDATE, INSERT, and DELETE methods aren't created.  Appearently this is a bug in Visual Studio 2005.

The following code is the minimal code required to create a DataSet from the SQL statement and attaches the dataset to a DataGrid:

Dim cnQODBC As System.Data.Odbc.OdbcConnection
Dim daQODBC As System.Data.Odbc.OdbcDataAdapter
Dim dsQODBC As System.Data.DataSet

cnQODBC = New System.Data.Odbc.OdbcConnection("DSN=QuickBooks Data")
cnQODBC.Open()
daQODBC = New System.Data.Odbc.OdbcDataAdapter("SELECT ListID, FullName, CompanyName FROM Customer", cnQODBC)
dsQODBC = New System.Data.DataSet

daQODBC.Fill(dsQODBC)
dgDataGrid.DataSource = dsQODBC
dgDataGrid.DataBind() 'May or maynot be required depending on where you put this code.