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
|
|
QODBC, Vista, Windows 2003, and Remote Access |
Author |
Message |
|
Posted : 2008-02-22 05:45:49 |
I am trying to setup QODBC in a remote configuration, following the instructions at http://www.qdeveloper.com.au/forum.php?homeinclude=topicdetails&forum_id=1&category_id=2&post_id=48.
I am running the trial version of QODBC, Vista and QB 2007 on my local workstation, and Windows 2003 and CF8 on the server.
I went through the Vista setup instructions for QODBC and I can get the test and the VB demo to run if I am using a standard user account (not part of the admin group), and QuickBooks is running.
Problem #1: If I shut down QuickBooks, even after selecting all of the options to allow QODBC to work even it QuickBooks is not running. Also, after setting all of this up, will I be able to work under my usual Admin account, or will I always have to use the standard user account when making this connection?
Then, I setup the remote connector on the workstation and setup QODBC on the Windows 2003 server. I added the IP address, username, and password to the configuration on the server and I setup the DSN in ColdFusion.
Problem #2: When I run the TestDCOM.cfm script on the server, all 4 lines come back as failed. Running the DisplaySQL.cfm script comes back with no records (no CF errors).
So, is there anything obvious I have missed or any pointers to getting this working?
Thanks |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2008-02-22 08:22:55 |
|
|
|
|
Posted : 2008-02-22 08:27:30 |
"The QODBC/iBiz Remote Connector cannot be used on Microsoft Windows Vista."
So does this mean there is not a way with QODBC to setup a remote connection with another server when the workstation with QuickBooks installed is running Vista?
Thanks |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2008-02-22 08:36:27 |
|
|
|
|
Posted : 2008-02-22 16:34:39 |
Is this something that is being worked upon or is Vista going to be ignored as a supported OS? |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2008-02-22 18:11:36 |
The problem here is not QODBC, it's Intuit's requirement that the Intuit qbXML SDK must call QuickBooks in non-evelated (non-admin or system user) mode under Vista, meaning that items that run as a server can't communicate with QuickBooks. |
|
|
|
|