<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.
>