This is probably an old problem that most of you know how to fix (I hope!).
The scenario is that I have a web server running an ASP site that needs to
access a database on another server. The web servers ODBC connection are
set to access the database and this is confirmed by running Excel and
pulling back some data. The ASP scripts are set to use the same DSN but I
get the above error when the script runs. If I move the database local to
the web site ASP pages, then I get no problems.
I'm therefore ...