tomschafer
Technical User
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()).
The web server is using basic text authentication and the sql server is using nt authentication.
Any ideas???
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()).
The web server is using basic text authentication and the sql server is using nt authentication.
Any ideas???
