By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,477 Members | 1,641 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,477 IT Pros & Developers. It's quick & easy.

Strange ODBC connection errors connecting to SQL Server

P: n/a
Hi all, hopefully someone can provide some advice.

I have an access application that uses SQL Server 2005 to serve data
via a DSN and linked tables. The front end runs on a Citrix server.

I created the DSN and it tested correctly. If I open the database on
the Citrix server I can open the tables and view/edit/insert data just
fine.

However, intermittantly I get a server doesn't exist or access denied
when opening simple recordsets in VBA. So I debug my SQL string in
the code and copy it to a new query and it works fine. But I get
either the Server does not exist or access is denied when attempting
to open the recordset or occaisionally I get the PreHandshake error or
General Network Issue error.

The application is over 10 years old and in use with a variety of
clients and works fine. I'm wondering if it's the Citrix platform
they are running it on. Authentication problems from Citrix perhaps?

If anyone has experience running Access apps on Citrix I'd love some
advice.


Nov 11 '08 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.