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
|
|
Multiple concurrent connections |
Author |
Message |
Ryan |
|
Group | : Members |
Posts | : 2 |
Joined | : 2007-03-03 |
|
Profile |
|
Posted : 2007-03-03 15:08:52 |
I'm trying to develop a 'consolidated' report that queries data from multiple QB data files. I want to use Excel to open concurrent connections to these data files where I can query and build my result set from mult. files. Is this possible with QODBC and if do I need the server version? Our QB environment is Enterprise 7.0. Thanks. |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2007-03-03 22:02:33 |
The problem here is that QuickBooks can only have one company file open at the one time. And while you can use QODBC Remote to connect to multiple computers running different company files in QuickBooks, it's far easier to read the data from company A using DSN A, close the connection, wait 10 seconds and open company B using DSN B and so on.
See: Can I access multiple companies at the same time? for more. |
|
|
|
Ryan |
|
Group | : Members |
Posts | : 2 |
Joined | : 2007-03-03 |
|
Profile |
|
Posted : 2007-03-07 06:31:25 |
Thanks the multiple DSNs is exactly what I want to try. Do I need the QODB Server Read/Write version to do this? I currently have just the Desktop Read only version of QODBC that came with Ent v7.0. Thanks again. |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2007-03-07 08:31:29 |
|
|
|
|