Re: Problem processing large files in my asp.net website

Yeah all the 6 files.. I can see all the uploaded files in the staging
database.. and the biggest Table is has 53133 records in it. the upload works
fine...

Hi,

       I am using the upload control to import 6 dbf files in to my staging
databse and then import them to the scrubbing database.. If the files sizes are
small it uploads processes them and then puts it to the production.. I am
calling a main stored procedure where it scrubbs and inserts it in to 3-4 tables
so all to in my main sproc i am calling 16 sprocs. If if the size of the data is
around 1MB or more it loads the data to the staging database and exceutes 9
sprocs and not the remaining..

So what should i do in order to processs all the sprocs.. I dont get any error
after doing it...I have set the Application time out to 7600secs in my asp.net
webconfig.. But it still doesnt finsh processing them..

Any help or ideas will be appreciated..

Regards,

Karen

Is the entire file being uploaded?

For script timeout, use something like:

Dim oldTimeout As Integer = Server.ScriptTimeout
Server.ScriptTimeout = 3600 ' 3600 second (1 hour) timeout
'  do your processing...
Server.ScriptTimeout = oldTimeout ' set it back 

Connection timeout (the length of time your script will wait on the database
server before giving up) will be set in your connection string.  Exactly how
depends upon the provider, primarily.  If you need further help with that, post
your connection string and I'll have a look.  It's a good idea to strip any
sensitive info (like server name, username/password) in the connection string
before you post it (for security purposes).

Well i am setting the connection string using App setting and here is the
connection string<appSettings>

<addkey="dbConnection"value="User ID =
Username;pwd=Password;Initial Catalog=Dbname;Data Source=IP" />

</appsetting><connectionStrings>

<addname="IConnString"connectionString="Data Source=IP;Initial
Catalog=DBname;Persist Security
Info=True"providerName="System.Data.SqlClient"/>

</connectionStrings>

 

Hope this helps..

Thanks,

Karen