Hi guys, i need a qodbc driver that will transfer data between a mysql database and the quickbooks database. I am using php as well as VB6. Any recommendations? Can i use the qodbc driver with php and visual basic6? Thanks Wes
There is no single ODBC driver that will access qb and mysql database formats. You use a separate driver for each - ODBC or otherwise.
The QODBC driver available here --
-- will handle the QuickBooks half of your needs. Your php or vb6 application will have to sit between that and the method you use to access mysql and pass data back and forth.
Also note: QODBC does not access the QB database directly. It uses the QB SDK interface and is subject to its limitations.
Klunk, could you tell me what are those limitations?
There are a lot of limitations -- too much to cover here -- and, frankly, I'm sure that I don't know all of them. The biggest holes are in payroll. Paychecks cannot be read, edited or created. Payroll Items expose only a small fraction of the fields associated with each item. And more...
If you need to work with non-payroll related data, you should be fine.
The forums at
The problem i am experiencing is getting my head wrapped around the tables in the Quick Books Database. There are many tables, and i want to INSERT into some, but it wont let me because i have to first read values from other tables. What is the extent of your knowledge in terms of the QODBC? Do you have any advice? Thanks Wes
wrote
I don't use QODBC. I've used IIF, OfficeQ and the SDK.
I think the support forums on the QODBC website would be the best place for you to get assistance.
BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.