I have a potential client who wants to use ODBC to access data tables for reporting from our application. This will be used by several users
concurrently on a Citrix box. How can I arrange things so the DSN Private Directory is different for each user, to avoid possible temporary table
name clashes?

TIA

Charles

Charles,

<< I have a potential client who wants to use ODBC to access data tables for
reporting from our application. This will be used by several users
concurrently on a Citrix box. How can I arrange things so the DSN Private
Directory is different for each user, to avoid possible temporary table name
clashes? >>

Using the same private directory won't be an issue.  The DBISAM Database
Server uses the same temporary files directory for multiple sessions without
issue.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim,

<<Using the same private directory won't be an issue.  The DBISAM Database
Server uses the same temporary files directory for multiple sessions without
issue.>>

We're using local sessions, not DBISAM server sessions. We don't have any customers deployed using the server. With our now ancient code,
we've found it performs rather much better with local sessions over a LAN than with C/S.

Rgds,

Charles

Charles,

<< We're using local sessions, not DBISAM server sessions. >>

Sorry for not being clearer - at that level of the engine the functionality
is the same, so you will be fine doing the same as the server.

--
Tim Young
Elevate Software
www.elevatesoft.com

"Tim Young [Elevate Software]" wrote:

<<Sorry for not being clearer - at that level of the engine the functionality
is the same, so you will be fine doing the same as the server.>>

Thanks Tim!