Solved

QODBC Remotely

Posted on 2014-10-13
7
215 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 92

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 92

Accepted Solution

by:
John Hurst earned 500 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
Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

 

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 92

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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Suggested Solutions

Meet the world's only “Transparent Cloud™” from Superb Internet Corporation. Now, you can experience firsthand a cloud platform that consistently outperforms Amazon Web Services (AWS), IBM’s Softlayer, and Microsoft’s Azure when it comes to CPU and …
Any business that wants to seriously grow needs to keep the needs and desires of an international audience of their websites in mind. Making a website friendly to international users isn’t prohibitively expensive and can provide an incredible return…
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…
Learn how to create flexible layouts using relative units in CSS.  New relative units added in CSS3 include vw(viewports width), vh(viewports height), vmin(minimum of viewports height and width), and vmax (maximum of viewports height and width).

867 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

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now