Our product talks directly to QuickBooks, and it currently supports one company file open at a time. There are two solutions to this. One is to open, read and close each company file in sequence. Another is to use our remote feature to access several company files at the one time running on various machines around the office or across the Internet.

Hi Tom,

I am using QuickBooks Enterprise 2005 utilizing terminal services, multi-user access.  I have two company files on the same server.  I have two applications running on their own machines that will need to update the two company files respectively, possibly at the same time.  Is this possible with two copies of QODBC using the Remote feature?  Also, sometimes users will open the two company files at the same time.  What is the best way to handle this without having to install QuickBooks on two machines?

thanks,
Rob

"To connect to multiple company files at the same time, you need to setup QODBC servers for each company file"

When you say multiple company files, does that imply that the multiple company files are on different boxes (i.e. different QuickBooks installations)? 

I'm assuming what I am trying to accomplish is not possible, but I just wanted to clarify the answer.

thanks for all our help,
Robert

Yes, if for example I needed to connect to five company files at the same time, I would have five workstations running QuickBooks and the iBiz Remote Connector. Then using the IP for the each workstation, I could then setup a DSN for each company file or simply specify the connection string in my program like this:

DRIVER={QODBC Driver for QuickBooks};OptimizerDBFolder=C:\Program Files\QODBC Driver for QuickBooks\Optimizer;IBizRemotePWD=123456;IBizRemoteConnect=Yes;IBizRemoteURL=http://192.168.1.10:2080; IBizRemoteConnTimeOut=120;IBizRemotePromptForPWD=No;IBizRemoteForce2002_2003=Yes; OpenMode=M;DFQ=C:\QBOOKS\DW.QBW;OLE DB Service=-2

Tom, seeing that this thread is almost 2 years old, I just want to clarify and see if I understand  it. I have 2 companies in use simultaneously with QB Enterprise v9, with the DB running on a server. I want to have 2 ODBC DSNs on one Win2K computer for simultaneoous access to the 2 companies. So it sounds like I need:

2 PCs running QB, each with one of the companies open, and each running RDS server.

1 PC running RDS client, and with 2 DSNs added to ODBC Data Source Admin, each DSN pointing to the separate PCs running the QB company file.

Will this work? Is it the best solution?