QODBC Remotely

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
Richard KortsAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

JohnBusiness Consultant (Owner)Commented:
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
Richard KortsAuthor Commented:
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
JohnBusiness Consultant (Owner)Commented:
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Cloud Class® Course: Python 3 Fundamentals

This course will teach participants about installing and configuring Python, syntax, importing, statements, types, strings, booleans, files, lists, tuples, comprehensions, functions, and classes.

Richard KortsAuthor Commented:
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
JohnBusiness Consultant (Owner)Commented:
I have only heard of Open Sync, but I have never used it.
0
Richard KortsAuthor Commented:
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
Rajendra DewaniCommented:
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
QuickBooks

From novice to tech pro — start learning today.