Invalid File DSN

Please help me.
Recently I have been getting the following error more and more often:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
General error: Invalid file dsn 'C:\Program Files\Common Files\ODBC\Data
Sources\"name of dsn"
This doesn't occur all the time jsut every now and then, but like I said
this has been happening more often now. If i run an IISRESET on the web
server making the call to the SQL server the error goes away and everything
works fine. I have done some research and everything I have found so far
says not to use File DSNs. However, the web server has over 60 sites on it
and every single one uses a file DSN or two. I am not the developer so I
can not force them to change their coding only make suggestions, but they
don't really like the suggestion to remove FIle DSNs and make calls
directly. If anyone has any other suggestions PLEASE!! let me know.
--sean.
Unfortunately, that's the price you pay with DSNs -- they often end up
being more trouble than they're worth. If you can prevail on your
developers to use direct connection strings instead, you'll all be
much happier in the long run. Valid ODBC connection strings can be
found at www.able-consulting.com/ADO_Conn.htm and
www.connectionstrings.com.
--Mary
On Tue, 8 Feb 2005 15:30:10 -0500, "Sean Kirby"
<sean.kirby@.blazenet.com> wrote:

>Please help me.
>Recently I have been getting the following error more and more often:
>Microsoft OLE DB Provider for ODBC Drivers error '80004005'
>General error: Invalid file dsn 'C:\Program Files\Common Files\ODBC\Data
>Sources\"name of dsn"
>This doesn't occur all the time jsut every now and then, but like I said
>this has been happening more often now. If i run an IISRESET on the web
>server making the call to the SQL server the error goes away and everything
>works fine. I have done some research and everything I have found so far
>says not to use File DSNs. However, the web server has over 60 sites on it
>and every single one uses a file DSN or two. I am not the developer so I
>can not force them to change their coding only make suggestions, but they
>don't really like the suggestion to remove FIle DSNs and make calls
>directly. If anyone has any other suggestions PLEASE!! let me know.
>--sean.
>