Buy Support
Incidents |
If you can't find your answer
in the FREE PUBLIC QDeveloper Forum, require URGENT Priority Support, or you need to send us
private or confidential information: |
Click Here
|
If you can't
login and post questions or you are having trouble viewing forum posts:
Click Here
|
Callback
Support |
If you live in USA, UK, Canada, Australia or New
Zealand, you can leave us details on your question and request us to call you back and discuss
them with you personally (charges apply). |
Click Here
|
Buy Support
Incidents |
If you can't find your answer
in the FREE PUBLIC QDeveloper Forum, require URGENT Priority Support, or you need to send us
private or confidential information: |
Click Here
|
|
Can I use QuickBooks data via QODBC with PHP / PERL / Apache on Linux? |
Author |
Message |
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2006-02-22 12:18:19 |
Here is a solution provided by one of our users allowing Linux web servers and users to talk to QuickBooks data via the QODBC Driver. Please send us feedback on how this works for you so we can refine and enhance these instructions:
"On the windows machine, using ActiveState Perl:
http://activestate.com/
I set up a daemon using a Perl module called DBI::ProxyServer
http://www.perldoc.com/perl5.6.1/lib/DBI/ProxyServer.html
This part is relatively easy to set up. You then make a DOS batch script that calls your new perl script with the desired configuration options and put that in Start Up.
Then on your linux machine you write a script that connects to the ProxyServer using the DBD::Proxy module
http://www.perldoc.com/perl5.6.1/lib/DBD/Proxy.html
You pass your login information and the DSN that you are connecting to through the typical Perl DBI interface and then can interact with the QODBC driver from the linux machine in the same way you'd use DBI to communicate with any other database.
Additional information:
To use Perl from within PHP, use the following extension:
http://www.zend.com/php5/articles/php5-perl.php?print=1 |
|
|
|
|