Quickbooks Data in Web Apps

Posted by jesseplace on June 15, 2008, 9:52 am

Please log in for more thread options

I am looking for a relatively simple solution to access QB data in a
company file from an ODBC connection.

All I need it to be is read only. I would like a solution where I can
upload the files daily to my web server and allow clients to access
their invoice totals, etc.

I've seen some tools online, but they either seem overly complicated
or require QB actually running on the server.

Does anyone know of or have any experience connecting to a QB file
with ODBC?

THaks.

Posted by Karl on June 16, 2008, 11:22 am

Please log in for more thread options

See www.qodbc.com

>I am looking for a relatively simple solution to access QB data in a

> company file from an ODBC connection.

> All I need it to be is read only. I would like a solution where I can

> upload the files daily to my web server and allow clients to access

> their invoice totals, etc.

> I've seen some tools online, but they either seem overly complicated

> or require QB actually running on the server.

> Does anyone know of or have any experience connecting to a QB file

> with ODBC?

> THaks.

Posted by klunk on June 16, 2008, 12:40 pm

Please log in for more thread options

Even QODBC connects to the QB data file via the QB SDK,
which must connect to an instance of QuickBooks running
"somewhere" -- right?

As for a "simple" solution: setting up a secure way of allowing
multiple customers to view only their invoices over the web
is not a simple project. Unless someone else has already built
it and will sell it to you...

"Karl":

> See www.qodbc.com

> "jesseplace":

>>I am looking for a relatively simple solution to access QB data in a

>> company file from an ODBC connection.

>> All I need it to be is read only. I would like a solution where I can

>> upload the files daily to my web server and allow clients to access

>> their invoice totals, etc.

>> I've seen some tools online, but they either seem overly complicated

>> or require QB actually running on the server.

>> Does anyone know of or have any experience connecting to a QB file

>> with ODBC?

Posted by jesseplace on June 16, 2008, 1:14 pm

Please log in for more thread options

Yes, the concept of QODBC is what I want, but I would prefer a way
without it running an instance of QB. As for exporting, I need a
fully automated method - upload the company files and connect to them
using SQL.

> Even QODBC connects to the QB data file via the QB SDK,

> which must connect to an instance of QuickBooks running

> "somewhere" -- right?

> As for a "simple" solution: setting up a secure way of allowing

> multiple customers to view only their invoices over the web

> is not a simple project. Unless someone else has already built

> it and will sell it to you...

> "Karl":

> > Seewww.qodbc.com

> > "jesseplace":

> >>I am looking for a relatively simple solution to access QB data in a

> >> company file from an ODBC connection.

> >> All I need it to be is read only. =A0I would like a solution where I ca=

> >> upload the files daily to my web server and allow clients to access

> >> their invoice totals, etc.

> >> I've seen some tools online, but they either seem overly complicated

> >> or require QB actually running on the server.

> >> Does anyone know of or have any experience connecting to a QB file

> >> with ODBC?- Hide quoted text -

> - Show quoted text -

Posted by Golden California Girls on June 16, 2008, 7:18 pm

Please log in for more thread options

jesseplace wrote:

> Yes, the concept of QODBC is what I want, but I would prefer a way

> without it running an instance of QB. As for exporting, I need a

> fully automated method - upload the company files and connect to them

> using SQL.

QB runs on a closed version of SQL for a very $$ reason. If it ran on a open
version, someone would create an application to update the payroll deduction
table, thus denying QB a revenue stream.

>> Even QODBC connects to the QB data file via the QB SDK,

>> which must connect to an instance of QuickBooks running

>> "somewhere" -- right?

>> As for a "simple" solution: setting up a secure way of allowing

>> multiple customers to view only their invoices over the web

>> is not a simple project. Unless someone else has already built

>> it and will sell it to you...

>> "Karl":

>>> Seewww.qodbc.com

>>> "jesseplace":

>>>> I am looking for a relatively simple solution to access QB data in a

>>>> company file from an ODBC connection.

>>>> All I need it to be is read only. I would like a solution where I can

>>>> upload the files daily to my web server and allow clients to access

>>>> their invoice totals, etc.

>>>> I've seen some tools online, but they either seem overly complicated

>>>> or require QB actually running on the server.

>>>> Does anyone know of or have any experience connecting to a QB file

>>>> with ODBC?- Hide quoted text -

>> - Show quoted text -