InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 23 May 2013 17:39:23 GMT20http://www.sqlservercentral.com/Forums/Topic265734-9-1.aspx[quote][b]minu.mukkada (6/27/2012)[/b][hr]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.[/quote]Minu,I work closely with the development team at Synergration. I'm curious, what issues did you experience with [url=http://www.synergration.com]OpenSync[/url] that inhibited your success? I'm happy to assist and curious to know so we can enhance the product moving forward.Tue, 19 Feb 2013 15:33:45 GMTrookpsuhttp://www.sqlservercentral.com/Forums/Topic265734-9-1.aspxi had used the quickbooks driver from [url]http://www.rssbus.com/ado/quickbooks/[/url] 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.Wed, 27 Jun 2012 06:10:50 GMTLowellhttp://www.sqlservercentral.com/Forums/Topic265734-9-1.aspxCan 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.Wed, 27 Jun 2012 05:11:23 GMTminu.mukkadahttp://www.sqlservercentral.com/Forums/Topic265734-9-1.aspxSynergration offers a product that replicates QuickBooks to a SQL Server database. There web site is www.synergration.comTue, 23 Feb 2010 09:10:38 GMTtomc 99431http://www.sqlservercentral.com/Forums/Topic265734-9-1.aspxWe 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.Fri, 27 Feb 2009 11:21:41 GMTRuss Riopellehttp://www.sqlservercentral.com/Forums/Topic265734-9-1.aspxIs that the version that comes with Quickbooks Enterprise or a purchased version?Thu, 19 Feb 2009 17:11:26 GMTjsmith-979014http://www.sqlservercentral.com/Forums/Topic265734-9-1.aspx<P>I suppose that I should mention: I've used the QODBC driver and it did what I needed.</P><P>jg</P>Wed, 15 Mar 2006 08:47:00 GMTJeff Grayhttp://www.sqlservercentral.com/Forums/Topic265734-9-1.aspx<P>Try</P><P><A href="http://www.qodbc.com">www.qodbc.com</A></P><P>jg</P>Wed, 15 Mar 2006 08:45:00 GMTJeff Grayhttp://www.sqlservercentral.com/Forums/Topic265734-9-1.aspx<P>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?</P><P>Thanks,</P><P>Adam</P>Tue, 14 Mar 2006 14:52:00 GMTAdam Campbell