Access - SQL DB connections in Citrix (1 Viewer)

[Carl_R]

We have an Access 2003 front end that is linked to an SQL backend (via DSN). The front end is published across 7 Citrix servers.

When users start a session on (say) Citrix Server 1, all queries they run start a session on Citrix Server 7. Essentially, any user that starts a session on Servers 1-6 will all start sessions on Server 7 when they run queries. Consequently, we may see dozens of sessions active on Server 7.

We find this quite strange - why Server 7? It is the same build as all other Citrix servers...

The app has always been slow and we are wondering if this is the cause.

Any ideas on why we are seeing this would be appreciated.

 

[Banana]

Is the server 7 where you developed the application? If so, I'd wager that's where DSN is at. In the projects where we used Citrix, we elected to use DSN-less connection so there's no extra work in looking up the information in DSN and so forth.