?
Solved

QODBC Remotely

Posted on 2014-10-13
7
Medium Priority
?
306 Views
Last Modified: 2014-10-20
Can QODBC be installed on a remote, Linux server and used to access a QB Database running on Windows 12? If so, can you point me to documentation on how to do so?

Thanks,

rkorts
0
Comment
Question by:Richard Korts
  • 3
  • 3
7 Comments
 
LVL 101

Expert Comment

by:John Hurst
ID: 40378160
QuickBooks is a very chatty client server database and remote access to it is generally not a good idea. It is really easy to damage the database with remote access. Can you install QODBC locally to QuickBooks and access the results locally?
0
 

Author Comment

by:Richard Korts
ID: 40378297
To John Hurst,

Yes, I could. But to what end?

My objective is to synchronize specific QB tables with corresponding tables on a web server. The web server database is MySQL. Do you know if I can create a MySQL database on the QB server, use QODBC to get data out (or put data in) QB & then figure out a way to synch that with the web server database? I have MySQL ODBC on the Quick Books server now because I was trying another "canned" solution that doesn't seem to work.
0
 
LVL 101

Accepted Solution

by:
John Hurst earned 2000 total points
ID: 40378338
Yes, I could. But to what end?  <-- The concern I have is possible damage to the database. Any tiny loss of connection or packet loss can lose a transaction.

About the only thing I can think of at this point is a packaged application from the Intuit Marketplace.
0
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 

Author Closing Comment

by:Richard Korts
ID: 40378393
Please stay tuned, I don;t see an easy solution.

Have you ever hear of OpenSynch?

I'm trying it but it appears not to work or the docs are poor or they are assuming a level of knowledge that I don;t have.
0
 
LVL 101

Expert Comment

by:John Hurst
ID: 40378403
I have only heard of Open Sync, but I have never used it.
0
 

Author Comment

by:Richard Korts
ID: 40378600
To John Hurst,

It now seems to be working in an odd sense..

Support & pre-sales seems pretty spotty, that scares me.

I will try to talk to them again (for the 4th or 5th time) tomorrow; they are EDT.

Thanks
0
 

Expert Comment

by:Rajendra Dewani
ID: 40391472
Hi,
For now, QODBC cannot be installed on Linux machine.

We are currently testing a linux client for QRemote which will connect to QuickBooks Data on the Windows machine. Please do let us know if you would like to have a beta test.  ( Raise a support ticket at http://support.flexquarters.com/esupport/index.php?/Tickets/Submit )

For now you can use a windows box at the remote site.

I would request you to refer
Accessing QuickBooks Data Remotely using QODBC & QRemote. (Video)
http://support.flexquarters.com/esupport/index.php?/Default/Knowledgebase/Article/View/2517/
&
http://support.flexquarters.com/esupport/index.php?/Default/Knowledgebase/Article/View/2483/0/using-quickbooks-data-remotely-via-qodbc

FAQ & Knowledge base : http://support.qodbc.com/

Regards
Rajendra Dewani
0

Featured Post

[Webinar] Kill tickets & tabs using PowerShell

Are you tired of cycling through the same browser tabs everyday to close the same repetitive tickets? In this webinar JumpCloud will show how you can leverage RESTful APIs to build your own PowerShell modules to kill tickets & tabs using the PowerShell command Invoke-RestMethod.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Choosing the right mix of apps is very much necessary for CPAs for making the most of the latest technology through which they can boost their growth.
Now many of you may wonder how you can reach great design with least number of essentials. Isn’t stuffing ‘more and more number of elements that speak for the purpose’ the right way to do it? Erm, not always, and in this write-up, you will see why.
Explain concepts important to validation of email addresses with regular expressions. Applies to most languages/tools that uses regular expressions. Consider email address RFCs: Look at HTML5 form input element (with type=email) regex pattern: T…
The viewer will learn how to look for a specific file type in a local or remote server directory using PHP.
Suggested Courses
Course of the Month4 days, 11 hours left to enroll

601 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question