Hello Everyone... I have an application running for many years with thousends of users all over the US. Recently I moved the application to run under MS Terminal Server environment. The data resides on file server and clients log in using MS Terminal Server connection to access the data via ODBC connection and Remote Views. Listed below is the structure of data directory.


SERVER: \data_1\*.dbf && data for company #1

\data_2\*.dbf && data for company #2


TERMINAL SERVER: \MAIN.EXE
\rdata\REMOTEVIEW.DBC


PROBLEM:

At startup, each user is prompted for a company# 1 or 2 which points to either data_1 or data_2 directory. A user can work with one database only.

First user logs in to company #1 which points to data_1 directory and the 2nd user login to company #2 which points to data_2 directory.... but they both using the same remoteview.dbc but pointing to 2 different databases residing in 2 different directories.

Sometimes, data from company #1 (data_1) will show up on user#2 screen who is working with company #2 (data_2) and vice versa.

I know the problem is with using the same RemoteView directory and pointing them to two different databases on two different connections.
When multiple users are logging in remotely, doesn't MS Terminal Server create a separate virtual session for each user?

Can someone shed some light on this issue. May be my network guy need to reconfigure the TS. Any help is greately appreciated.

Thank You In Advance...

Raza Malik