Question

Locked

Access front-end can't see SQL Server via Citrix

By bschaettle ·
I have an Access 2003 application that references linked tables that reside on a SQL Server database. When I run it from my desktop, it works fine. When I try to run it under Citrix, the ODBC connection to SQL Server fails. Any ideas?
=============================
UPDATE:
I may have found the problem: I was linking the tables using an ODBC File DSN that resides on a network share. I created a copy on the server's local drive and things have started working, not perfectly mind you...

This conversation is currently closed to new comments.

4 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Answers

Collapse -

silly question

by lowlands In reply to Access front-end can't se ...

but is the ODBC connection defined on the Citrix server. Preferably under the System DSN's

Collapse -

Yes, ODBC connection is defined on the server...

by bschaettle In reply to silly question

...but I'm going to re-visit that issue today anyway.

Collapse -

Hi, what do you mean when you said you created a copy on the server

by sluo In reply to Access front-end can't se ...

did you create a copy of the database on the citrix server? I appreciated your input; I am having the same issue:
when I try to use access 97 front-end to SQl via citrix server.

Many thanks,

Back to Networks Forum
4 total posts (Page 1 of 1)  

Hardware Forums