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 Installation in two Server configuration |
Author |
Message |
|
Posted : 2006-07-15 06:08:22 |
I'm trying to configure QODBC Server Edition in a configuration that seems to be somewhat unique, and I'm not having any luck. Since I'm lost I'll just explain our situation and state our goals, and hopefully you will be able to shed some light on the best method...
We are dealing with two servers:
- Server 1: Windows 2003 64-bit Terminal Server on which the Quickbooks client is installed and accessed by multiple users.
- Server 2: Windows 2003 64-bit Server on which the Quickbooks data file, SQL Server 2000, and intranet web server reside.
I need simply to connect from Server 2 to the Quickbooks data file, which again is also on Server 2 even though the Quickbooks client is installed on Server 1. I need to be able to connect using both SQL Server Management Studio and the ColdFusion MX application server that both reside on Server 2.
Because I've seen the special instructions on your site for terminal services/Citrix, as well as the document about SQL Server and another document on Remote Connecions, I am at a loss. I'm not sure which of these instructions apply to our requirements.
I'd appreciate any direction you can provide...
-Paul |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2006-07-15 11:39:17 |
Firstly, QODBC talks to QuickBooks ... not the company file. We simply tell QuickBooks what company file we want to work with.
So to cut a long story short, you simply need to install a copy of QuickBooks on Server 2. Once that's done you can establish a direct connection to QuickBooks on the Server Console (local session) while logged in as the Server 2 administrator. |
|
|
|
|
Posted : 2006-07-15 12:39:09 |
Oh that is so much simpler than I was trying to make it. I'll give it a shot.
Thanks! |
|
|
|
|