Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 


 
     
Recent Posts
   
Popular Topics
Home   
Search
    Members    Calendar    Who's On

Home » SQL Server 7,2000 » General » QuickBooks to SQL Server
Add to briefcase

QuickBooks to SQL Server Expand / Collapse
Rate Topic
Display Mode
Topic Options
Author
Message
Adam Campbell
Posted Tuesday, March 14, 2006 2:52 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Friday, October 02, 2009 2:42 PM
Points: 52, Visits: 18

Does anyone have any ideas of ways to communicate between SQL Server and Quickbooks?  I have found a couple of products out there, but does anyone have any recommendations?

Thanks,

Adam
Post #265734
Jeff Gray
Posted Wednesday, March 15, 2006 8:45 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Wednesday, May 15, 2013 8:57 AM
Points: 963, Visits: 346

Try

www.qodbc.com

jg
Post #265918
Jeff Gray
Posted Wednesday, March 15, 2006 8:47 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Wednesday, May 15, 2013 8:57 AM
Points: 963, Visits: 346

I suppose that I should mention:  I've used the QODBC driver and it did what I needed.

jg
Post #265919
jsmith-979014
Posted Thursday, February 19, 2009 5:11 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, June 07, 2011 5:40 PM
Points: 1, Visits: 10
Is that the version that comes with Quickbooks Enterprise or a purchased version?
Post #660999
Russ Riopelle
Posted Friday, February 27, 2009 11:21 AM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Tuesday, October 30, 2012 12:56 PM
Points: 605, Visits: 54
We just purchased the Server version of QODBC. If we try to extract data from QB using an OPENQUERY statement in a stored procedure using a linked server it runs just one time. It leaves an open SPID which cannot be killed(have to restart the server to kill!!). Just wondering if you have had this experience. I have researched this on line and what I have found is that it is a SQL problem. Any help would be appreciated.


Post #665907
tomc 99431
Posted Tuesday, February 23, 2010 9:10 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, February 23, 2010 9:32 AM
Points: 1, Visits: 1
Synergration offers a product that replicates QuickBooks to a SQL Server database. There web site is www.synergration.com
Post #871215
minu.mukkada
Posted Wednesday, June 27, 2012 5:11 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, August 07, 2012 9:34 AM
Points: 2, Visits: 15
Can you please tell us the steps you have used to connect QB to SQL server using QODBC. We have been working on this especially other solutions like OpenSync, but we are not having success. Any help would be great.
Post #1321792
Lowell
Posted Wednesday, June 27, 2012 6:10 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 1:43 PM
Points: 11,613, Visits: 27,666
i had used the quickbooks driver from http://www.rssbus.com/ado/quickbooks/ so i could connect via a .NET application;

They had a decent amount of examples, and it was pretty easy to connect and view the data; from there, i could put the data in a datatable in .NET, and do what i want with it after that, for example copy all the tables to SQL server for example.

When i did that is was the version 1.0 driver, and it did work well, but one specific thing that i was looking for, which was the Relations/ Foreign key equivilent for Payments Received-to-Invoices-Paid was not exposed; That was a critical piece for the process I was building, so I stopped investigating that.
Their driver is now labeled 2.0, but it was definteily straight forward if you are a programmer.

Lowell

--There is no spoon, and there's no default ORDER BY in sql server either.
Actually, Common Sense is so rare, it should be considered a Superpower. --my son
Post #1321809
rookpsu
Posted Tuesday, February 19, 2013 3:33 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, February 19, 2013 3:27 PM
Points: 1, Visits: 0
minu.mukkada (6/27/2012)
Can you please tell us the steps you have used to connect QB to SQL server using QODBC. We have been working on this especially other solutions like OpenSync, but we are not having success. Any help would be great.


Minu,

I work closely with the development team at Synergration. I'm curious, what issues did you experience with OpenSync that inhibited your success? I'm happy to assist and curious to know so we can enhance the product moving forward.
Post #1421875
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse

 
 
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.