Hi everybody.
Got a nice little problem here. I have a accessdatabase containing 100 000 rows. Im fetching these rows to a dataset and then inserting them, row by row, to a MSSQL dB. The dB and IIS is running on the same server. I also have full control over this webserver, so I pushed theServer.ScriptTimeout valueup to 3600 sec (both in IIS and in the c# code) but when executing this query (witch aprox. take me 8 minutes) I recieve aError Code: 408. The operation timed out. The remote server did not respond within the set time allowederror.
Someone got a clue for me? :)
-Thomas
Perhaps retrieving 100,000 rows and inserting them one at a time into another server, from a front end is not a good idea. Try looking into other options like (1) creating a text file from access and doing a BULK INSERT into SQL server or (2) creating a DTS package or (3) check if OPENROWSET works. Read up books on line for each of these options and see which works best for you.
|||Ok, I will do :) Thanks for the quick reply!
Got a tip on how to generate custom reports on this as well? Have a select statement based on a BETWEEN two DATETIME stamps, it take some time, but seems to work ok, but I'm always looking for a way to improve this :)
Appreciate it!
No comments:
Post a Comment