Quickbooks Link

Questions and Answers about DataEase for Windows

Quickbooks Link

Postby shakerfish » Tue Nov 15, 2011 10:36 pm

Hi all,

I don't suppose you can use ODBC to link 7.x to Quickbooks can you? Just wondering what my options are in sharing and possibly writing data between the two applications.

Thanks
shakerfish
 
Posts: 3
Joined: Mon Jan 24, 2011 8:32 am
Has thanked: 0 time
Been thanked: 0 time
 

Re: Quickbooks Link

Postby Stewart Allen » Wed Nov 16, 2011 5:53 am

If there is an ODBC or OLEDB provider for Quickbooks then you should be able to connect.

The most convenient method is to use a Universal Data Link (UDL) file.

Create a new text file and change the extension to UDL.
eg: QB.UDL

Opening the UDL will allow you to define and test the connection to Quickbooks.
Put the UDL file in the DE folder or application folder.
Reference this UDL file in the DE Database links dialogue.
Stewart Allen
 
Posts: 88
Joined: Thu Sep 27, 2007 11:25 am
Has thanked: 0 time
Been thanked: 0 time
 

Re: Quickbooks Link

Postby Graham Smith » Wed Nov 16, 2011 1:28 pm

There is a custom ODBC driver called QODBC (or something similar), just Google it.

That said, I tried it once very long ago is there are two things that make it difficult to use:
1. There are some tables that either won't load or some fields that are problematical. This is because, like many other companies, QB uses table and field structures that does not recognize.
2. Unless you know how QB is structured, you will have a lot of trouble trying to navigate.

IF you do get connected and IF you can find what you want, do not try and add or modify data. You can write reports if you want, but no more than that.
Graham Smith
DataSmith, Delaware
"For every expert there is an equal and opposite expert.", Arthur C. Clarke (1917 - 2008)
"X-Clacks-Overhead: GNU Terry Pratchett"
User avatar
Graham Smith
 
Posts: 2501
Joined: Fri Sep 07, 2007 11:31 am
Location: Delaware, USA
Has thanked: 0 time
Been thanked: 1 time
 

Re: Quickbooks Link

Postby shakerfish » Wed Nov 16, 2011 3:11 pm

OK,

Thanks you've been a great help.
shakerfish
 
Posts: 3
Joined: Mon Jan 24, 2011 8:32 am
Has thanked: 0 time
Been thanked: 0 time
 
 

Return to DataEase for Windows

Who is online

Users browsing this forum: No registered users and 1 guest

cron