I'm not sure this is the right forum for this thread, but hopefully the Admins can move it if it isnt.

Here is my situation.

I had a web server with a web page that referenced an Excel spreadsheet.
(a href="c:\webservername\xyz.xls" target=main)

there is a query to retreive data in the ss from a Access Database.

I had to move the website from one server to another, which included moving the data from an Access Database to a SQL 2000 Database, which sits on a SQL Server.

There is a DSN created on the web server for the connection.
From the web server, I can open the Excel Sheet and it queries the database fine.

My issue is that now when someone hits the webpage from their computer, they get the spreadsheet, but since they dont have a DSN on thier machine, the get an error stating "[Microsoft][ODBC Driver Manager] Datasource name not found and no default driver specified."

Is there a way to specify to use the DSN on the web server so I wouldnt have to create a DSN on every machine that would need to access it?

TIA
IV