2
Answers

Server Application Unavailable -Access huge data

kavita

kavita

17y
1.8k
1
hi This is kavita. I am accessing huge amount of data) aroun 4 lakh).my code is: Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click Dim cnOLE As OleDbConnection Dim ds As DataSet = New DataSet Dim daole As OleDbDataAdapter cnOLE = New OleDbConnection("Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Registry Path=;Jet OLEDB:Database Locking Mode=1;Data Source=C:\DATABASE.mdb;Password=;Jet OLEDB:Engine Type=5;Jet OLEDB:Global Bulk Transactions=1;Provider=Microsoft.Jet.OLEDB.4.0;Jet OLEDB:System database=;Jet OLEDB:SFP=False;Extended Properties=;Mode=Share Deny None;Jet OLEDB:New Database Password=;Jet OLEDB:Create System Database=False;Jet OLEDB:Compact Without Replica Repair=False;User ID=Admin;Jet OLEDB:Encrypt Database=False") cnOLE.Open() daole = New OleDbDataAdapter("SELECT * FROM tender_detail", cnOLE) daole.Fill(ds) DataGrid1.DataSource = ds DataGrid1.DataBind() End Sub but it give this ERROR--> Server Application Unavailable The web application you are attempting to access on this web server is currently unavailable. Please hit the "Refresh" button in your web browser to retry your request. I have change machine.config element responseDeadlockInterval like this and
Answers (2)