I'm currently running a small business that requires users from different workstations to view, update data from quickbooks tables. (still indifferent whether to use Access Database or a web-based application as a user interface) Can I use QODBC the desktop edition to allow multiusers to access quickbooks data from a Quickbooks file located on the server, or do I have to use the web server edition?

I'm using Quickbooks 2007

please advise,

Thanks

QODBC talks to QuickBooks on the workstation which then talks to the company file on the server. So all you need is QuickBooks and QODBC on each workstation.

Thanks Tom,

what if I want to build a web-based application using IIS webserver where users can view and update quickbooks data, do I have to use the web server edition of QODBC? and if yes where does 1]Quickbooks Application 2]Quickbooks file  3]QODBC located? on the server or on the workstation? I'm currently using Web Matrix ASP.NET as a tool to build the web application and Microsoft SQL Server which will be linked with QODBC

Thanks again,

Does the evaluation version of QODBC support the DCOM server?  Currently I have QODBC V 8.0.0.236

I've added QODBC driver as a linked server in Microsoft SQL server. I'm going to create a database named QB as stated in one of the articles in this forum, and after that I have to link it with QODBC and load QODBC data into that new created database. My question is that, how can I create a link so that any data updated in QODBC will be reflected in the new created database (QB) in Microsoft SQL server and vice versa.  I'm going to use the remote connection method to view and update Quickbooks data using a web application

also I noticed that the QB database created in My SQL Server does not include tables' relationships!

If tables are not related how can we run queries?

Try looking at: Using DTS to Load QuickBooks Data into Microsoft SQL Server 

When using QODBC, all the transaction tables have most of the header columns contained within them, so there's no need for table relationships other than linking tables.

Basically you simply execute the query against the tables within a OpenQuery like this:

SELECT * FROM OPENQUERY(QODBC, 'SELECT InvoiceLine.TxnDate, InvoiceLine.RefNumber,
Customer.FullName, Customer.CompanyName, InvoiceLine.BillAddressAddr1,
InvoiceLine.BillAddressAddr2, InvoiceLine.BillAddressAddr3,
InvoiceLine.BillAddressAddr4, InvoiceLine.BillAddressCity, InvoiceLine.BillAddressPostalCode,
InvoiceLine.InvoiceLineDesc, InvoiceLine.InvoiceLineQuantity, InvoiceLine.InvoiceLineRate,
InvoiceLine.InvoiceLineAmount, TaxCode.Tax1Rate , Invoice.subTotal, Invoice.Tax1Total 
FROM Customer, InvoiceLine, TaxCode
WHERE InvoiceLine.CustomerRefFullName = Customer.FullName
AND InvoiceLine.InvoiceLineTaxCodeRefFullName = TaxCode.Name
AND InvoiceLine.RefNumber="1000"')

I'm using Visual studio to build my web application, how can I view the QODBC as a linked server with My SQL Server in order to apply the select, insert and update statements on the data directly?

At this point I have no idea whether you're using MS SQL Server or My SQL Server. Try the query again without a Invoice number:

SELECT InvoiceLine.TxnDate, InvoiceLine.RefNumber,
Customer.FullName, Customer.CompanyName, InvoiceLine.BillAddressAddr1,
InvoiceLine.BillAddressAddr2, InvoiceLine.BillAddressAddr3,
InvoiceLine.BillAddressAddr4, InvoiceLine.BillAddressCity, InvoiceLine.BillAddressPostalCode,
InvoiceLine.InvoiceLineDesc, InvoiceLine.InvoiceLineQuantity, InvoiceLine.InvoiceLineRate,
InvoiceLine.InvoiceLineAmount, TaxCode.Tax1Rate , Invoice.subTotal, Invoice.Tax1Total 
FROM Customer, InvoiceLine, TaxCode
WHERE InvoiceLine.CustomerRefFullName = Customer.FullName
AND InvoiceLine.InvoiceLineTaxCodeRefFullName = TaxCode.Name