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
|
|
Is Remote Connector required to use a company file on the LAN |
Author |
Message |
|
Posted : 2008-06-20 04:30:11 |
Is it possible to use a company file on a common drive and access it via ODBC from other computers on the network with the standard driver setup? Oris Remote Connector required for ODBC to use a company file that is on the LAN? Does the normal driver set up only work when the Company file is located on the same machine running MS Access, for example?
Thanks. |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2008-06-20 07:47:12 |
QODBC only talks to QuickBooks - not the company file. QuickBooks opens and talks to the company file, so if QuickBooks is on the local machine, QuickBooks will open the company file on the LAN for you.
The QODBC Remote Connector is only used to talk to QuickBooks on another machine, where QuickBooks will open the company file. |
|
|
|
|
Posted : 2008-06-20 10:31:17 |
Thanks for the clarification.
I've been testing on a local company file with no issues, but now am testing against the 'live' company file which is in a common folder on the LAN. I am running from a machine with QuickBooks installed. I have had some pass through queries run successfully, but other times the same queries run into problems. QuickBooks throws an error that says the connection to the company file was lost and I have to Abort (Sorry I don't have the actual message).
Have you ever seen issues like that? Could it be anything related to the ODBC driver? Now seems like an issue with the local network. If I connect to ODBC with the settings that do not require Quickbooks to be open, will it reattempt to connect to the company file if the network connection is lost? Or will the query simply fail? |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2008-06-20 15:16:01 |
|
|
|
|