Post reply

QuickBooks to SQL Server

  • March 14, 2006 at 2:52 pm

    #90976

    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

  • March 15, 2006 at 8:45 am

    #626796

    Try

    http://www.qodbc.com

    jg

  • March 15, 2006 at 8:47 am

    #626797

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

    jg

  • February 19, 2009 at 5:11 pm

    #947273

    Is that the version that comes with Quickbooks Enterprise or a purchased version?

  • February 27, 2009 at 11:21 am

    #951313

    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.

  • February 23, 2010 at 9:10 am

    #1123677

    Synergration offers a product that replicates QuickBooks to a SQL Server database. There web site is http://www.synergration.com

  • June 27, 2012 at 5:11 am

    #1506060

    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.

  • June 27, 2012 at 6:10 am

    #1506072

    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

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • February 19, 2013 at 3:33 pm

    #1589393

    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.

  • June 10, 2016 at 9:47 am

    #1884433

    I dont Know But I suggest you Quickbooks technical Support expert[/url]. They Solve your problem

  • March 31, 2018 at 1:31 pm

    This was removed by the editor as SPAM

  • March 31, 2018 at 1:32 pm

    This was removed by the editor as SPAM

  • March 31, 2018 at 1:33 pm

    This was removed by the editor as SPAM

  • March 31, 2018 at 1:41 pm

    This was removed by the editor as SPAM

  • April 1, 2018 at 8:45 am

    #1985151

    He he, funny seeing this popping up on the latest entries, only a 12 year old thingy, MDM would classify this as a "blast from the past"
    😎

Viewing 15 posts - 1 through 15 (of 26 total)

You must be logged in to reply to this topic. Login to reply