Re: Connection Timeout

Tech-Archive recommends: Fix windows errors by optimizing your registry

I had set timeout at following :
- web.config
- ISS 6.0
- ASP.Net page

But it is seem un-retrievable for millions record....

I also notice that MS SQL Server 2000 (Standard Edition) is capable to store
over millions but unable to retrieval via stored procedure or ADO.Net...

Could it possible that MS SQL Server 2000 (Standard Edition) have constraint
of retrieval millions record and only MS SQL Server 2000 (Enterprise
Edition) could do so...

Please advise...

"Marina" <someone@xxxxxxxxxx> wrote in message
news:OS1Rtn8gFHA.3124@xxxxxxxxxxxxxxxxxxxxxxx
> The default timeout for a command is 30 seconds. You need to set it to a
> larger timeout, if you need more time to execute your query.
>
> However, do you really need to retrieve 1 million records all at once?
>
> "sam" <samuellai@xxxxxxxxxxxx> wrote in message
> news:Od2Kq13gFHA.2644@xxxxxxxxxxxxxxxxxxxxxxx
>> When I use ASP.Net via ADO.Net to retrieve data from MS SQL Server 2000,
>> it is always prompt error message "Timeout" if the number record is
>> larger than 1 million.
>>
>> May I know what is the best practise for pool large records for my case,
>> please?
>>
>> Or it is limitation on ADO.Net or ASP.Net or .Net framework 1.1?
>>
>>
>> ASP.Net Coding
>> -----------------
>> Server.ScriptTimeout = 9000
>>
>> Dim constr_GL_3a_2 As String = "server='SQLSVR'; user id='sa';
>> password='sa'; Database='ERP_ARCHIVAL';Connect Timeout=1200"
>> Dim sqlcon_GL_3a_2 As System.Data.SqlClient.sqlconnection = New
>> System.Data.SqlClient.sqlconnection(constr_GL_3a_2)
>> Dim sqlcmd_GL_3a_2 As System.Data.SqlClient.SqlCommand = New
>> SqlCommand()
>> Dim sqlda_GL_3a_2 As New system.Data.SqlClient.sqldataAdapter()
>> Dim sqlprm1_GL_3a_2 As New system.Data.SqlClient.SqlParameter()
>> Dim sqlprm2_GL_3a_2 As New system.Data.SqlClient.SqlParameter()
>>
>> Try
>> sqlcmd_GL_3a_2 = sqlcon_GL_3a_2.CreateCommand
>>
>> sqlcmd_GL_3a_2.CommandText = "[General_Ledger]"
>>
>> sqlcmd_GL_3a_2.CommandType = commandtype.StoredProcedure
>>
>> sqlprm1_GL_3a_2 =
>> sqlcmd_GL_3a_2.Parameters.Add("@DateFrom",SqlDbType.Int,6)
>> sqlprm1_GL_3a_2.value = FlagFrDate
>>
>> sqlprm2_GL_3a_2 =
>> sqlcmd_GL_3a_2.Parameters.Add("@DateTo",SqlDbType.Int,6)
>> sqlprm2_GL_3a_2.value = FlagToDate
>>
>> sqlda_GL_3a_2.SelectCommand = sqlcmd_GL_3a_2
>> sqlcon_GL_3a_2.Open
>> sqlcmd_GL_3a_2.ExecuteNonQuery
>> Finally
>> sqlcon_GL_3a_2.Close()
>> sqlcon_GL_3a_2.Dispose()
>> End Try
>>
>> constr_GL_3a_2 = Nothing
>> sqlcon_GL_3a_2 = Nothing
>> sqlcmd_GL_3a_2 = Nothing
>> sqlda_GL_3a_2 = Nothing
>>
>>
>
>


.

Relevant Pages

  • Re: Connection Timeout
    ... the issue is the command timeout. ... SqlCommand object. ... So you should be able to retrieve 1 million records. ... > I also notice that MS SQL Server 2000 is capable to ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Check Linked Table Connection
    ... That will only test to make sure the connection is available. ... Run the query with a 20 second timeout. ... but I don't have any direct access to their SQL Server nor their ... I am an outside programmer that end-users contract, ...
    (comp.databases.ms-access)
  • Re: Timeout Expired
    ... So the timeout occurs during the bulk load operations? ... did you check the SQL Error Logs to see more clues about the timeout problem if there is any? ... locked for DML operations by SQL Server. ...
    (microsoft.public.sqlserver.server)
  • Re: Increase Connection Command timeout globally
    ... Hitchhiker's Guide to Visual Studio and SQL Server ... in Stored procs which is causing it to timeout. ... Connection and Command timeout settings are done on the client. ... I expect you'll have to visit each Command object declaration and set the ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: How does one set read-uncommitted on the entire DB?
    ... queries to determine if the locking will become less of a problem. ... All client APIs permit you to set the timeout, ... Note that query timeout is unrelated to SQL Server. ...
    (comp.databases.ms-sqlserver)