SQL ConnectionRead (WrapperRead()) Error

[tomschafer]

I have a page that uploads a file to the web server, it redirects back to itself and copies the file to the sql server and does a bcp to load the file into sql redirects back to itself again and runs a stored procedure on the sql box that joins the table populated by the uploaded file to another table with millions of records.

Here is the problem - the table with millions of records has a field populated with date (approx 300000 records per day). If I run the page for the current date there is no problem, if I go backwards at all I get the following error -

[Microsoft][ODBC SQL Server Driver][Named Pipes]ConnectionRead (WrapperRead()).

Any ideas???

 

[tomschafer]

I also forgot to mention the web server is using Basic Text authentication. The sql box (version 7.0) is using NT Authentication.