Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

ADODB Recordset with CSV File - No data

Status
Not open for further replies.

rexolio2008

Technical User
Apr 24, 2008
41
US
I don't want to repeat a lot of what was included in this thread: thread333-1504695 because I'm having pretty much the exact same problem, but no one responded to that one, so I'm hoping they will here.

I just need something to focus my attention on - I have no clue.

I have an ASP page that uploads a csv file, opens it, gets the number of records, than loops through those records and inserts each one into a SQL database.

This worked just fine up until a few weeks ago. With no changes made to the original file, suddenly, when you upload a csv file, the page is just blank. If you write out the number of records/lines in the csv, it tells you zero, as if it's not even opening it. I did some error testing and while the file does get uploaded, it doesn't process at all. The files have around 500 records in them. If I remove all but less than 100 records, the process works just fine. Seems like a server related issue or setting?

In summation - the script still works, but only when the file has but a few records/lines in it. This was not the case a mere month ago.

Any direction would be great - my code is very similar to the code on the aforementioned thread.

Thanks!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top