query timeout expired

7 Apr 2006 2:30 AM

Tlink

I am performing a update to 2m+ records, when it reaches 200 records it
times out ?

rsobj = db.execute("select * from Somefile where t2 is null;")
do while
    db.commantimeout = 0
    ******** newexp & newfactor are calculated *****
    SQLLine = "UPDATE Australia..InProgress SET t2 = '" & NewExp & "',t3
='" & NewFactor & "' where t1 = '" & business & "';"
    DBobj.Execute(SQLLine)
Loop

When I monitor the current processors they are all awaitting command

7 Apr 2006 2:37 AM

Uri Dimant

Hi
Define timeout value on an application level. Set it to default

Show quote

"Tlink" <Tlink@online.nospam> wrote in message
news:%23kBqCteWGHA.2080@TK2MSFTNGP05.phx.gbl...
>I am performing a update to 2m+ records, when it reaches 200 records it
>times out ?
>
> rsobj = db.execute("select * from Somefile where t2 is null;")
> do while
>    db.commantimeout = 0
>    ******** newexp & newfactor are calculated *****
>    SQLLine = "UPDATE Australia..InProgress SET t2 = '" & NewExp & "',t3
> ='" & NewFactor & "' where t1 = '" & business & "';"
>    DBobj.Execute(SQLLine)
> Loop
>
> When I monitor the current processors they are all awaitting command
>

7 Apr 2006 2:50 AM

Tlink

I am unsure as to what this means and how to do it.

Show quote

"Uri Dimant" <u***@iscar.co.il> wrote in message
news:uV6ceweWGHA.3864@TK2MSFTNGP04.phx.gbl...
> Hi
> Define timeout value on an application level. Set it to default
>
>
>
>
>
> "Tlink" <Tlink@online.nospam> wrote in message
> news:%23kBqCteWGHA.2080@TK2MSFTNGP05.phx.gbl...
>>I am performing a update to 2m+ records, when it reaches 200 records it
>>times out ?
>>
>> rsobj = db.execute("select * from Somefile where t2 is null;")
>> do while
>>    db.commantimeout = 0
>>    ******** newexp & newfactor are calculated *****
>>    SQLLine = "UPDATE Australia..InProgress SET t2 = '" & NewExp & "',t3
>> ='" & NewFactor & "' where t1 = '" & business & "';"
>>    DBobj.Execute(SQLLine)
>> Loop
>>
>> When I monitor the current processors they are all awaitting command
>>
>
>

7 Apr 2006 3:43 AM

Uri Dimant

Tlink
Set cnAdo = New ADODB.Connection
strConnect = "driver={SQL
Server};uid=...;pwd=...;server=..;database=.....;Network=dbmssocn"
    cnAdo.Provider = "SQLOLEDB"
    cnAdo.ConnectionString = strConnect
    cnAdo.CommandTimeout = 0---or what do you have here?
    cnAdo.CursorLocation = adUseServer
    cnAdo.Mode = adModeRead
    cnAdo.Open

Show quote

"Tlink" <Tlink@online.nospam> wrote in message
news:uUUdQ4eWGHA.3624@TK2MSFTNGP04.phx.gbl...
>I am unsure as to what this means and how to do it.
>
> "Uri Dimant" <u***@iscar.co.il> wrote in message
> news:uV6ceweWGHA.3864@TK2MSFTNGP04.phx.gbl...
>> Hi
>> Define timeout value on an application level. Set it to default
>>
>>
>>
>>
>>
>> "Tlink" <Tlink@online.nospam> wrote in message
>> news:%23kBqCteWGHA.2080@TK2MSFTNGP05.phx.gbl...
>>>I am performing a update to 2m+ records, when it reaches 200 records it
>>>times out ?
>>>
>>> rsobj = db.execute("select * from Somefile where t2 is null;")
>>> do while
>>>    db.commantimeout = 0
>>>    ******** newexp & newfactor are calculated *****
>>>    SQLLine = "UPDATE Australia..InProgress SET t2 = '" & NewExp & "',t3
>>> ='" & NewFactor & "' where t1 = '" & business & "';"
>>>    DBobj.Execute(SQLLine)
>>> Loop
>>>
>>> When I monitor the current processors they are all awaitting command
>>>
>>
>>
>
>

7 Apr 2006 5:09 AM

Omnibuzz

try this

SELECT subsnp_id,pop_id,allele_id
FROM AlleleFreqBySsPop as A,
    (SELECT Omim_No
    FROM av
    WHERE Description LIKE '%LIVER%'
    ORDER BY Omim_No ASC
    UNION ALL
    SELECT Omim_No
    FROM cs
    WHERE CS_Description LIKE '%LIVER%'
    OR CS_DATA LIKE '%LIVER%'
    ORDER BY Omim_No ASC
    UNION ALL
    SELECT Omim_No
    FROM ti
    WHERE Omim_Titles LIKE '%LIVER%'
    ORDER BY Omim_No ASC
    UNION ALL
    SELECT Omim_No
    FROM ti_alt_title
    WHERE Omim_Alt_Titles LIKE '%LIVER%'
    ORDER BY Omim_No ASC
    UNION ALL
    SELECT Omim_No
    FROM tx
    WHERE Omim_Text LIKE '%LIVER%' ) as B
WHERE A.source LIKE '%' + cast(B.Omim_no as varchar) + '%'

7 Apr 2006 5:14 AM

Uri Dimant

Hi Omnibuzz
I think you are confused about this thread. See ,what does the OP ask for ?
Show quote

:-))))))))))))))))

"Omnibuzz" <Omnib***@discussions.microsoft.com> wrote in message
news:4AF72CF7-A02E-423A-BF50-A1A95EF10D38@microsoft.com...
> try this
>
> SELECT subsnp_id,pop_id,allele_id
> FROM AlleleFreqBySsPop as A,
> (SELECT Omim_No
> FROM av
> WHERE Description LIKE '%LIVER%'
> ORDER BY Omim_No ASC
> UNION ALL
> SELECT Omim_No
> FROM cs
> WHERE CS_Description LIKE '%LIVER%'
> OR CS_DATA LIKE '%LIVER%'
> ORDER BY Omim_No ASC
> UNION ALL
> SELECT Omim_No
> FROM ti
> WHERE Omim_Titles LIKE '%LIVER%'
> ORDER BY Omim_No ASC
> UNION ALL
> SELECT Omim_No
> FROM ti_alt_title
> WHERE Omim_Alt_Titles LIKE '%LIVER%'
> ORDER BY Omim_No ASC
> UNION ALL
> SELECT Omim_No
> FROM tx
> WHERE Omim_Text LIKE '%LIVER%' ) as B
> WHERE A.source LIKE '%' + cast(B.Omim_no as varchar) + '%'
>

7 Apr 2006 5:36 AM

Omnibuzz

Oops.. sorry wrong number :)

Show quote

"Uri Dimant" wrote:

> Hi Omnibuzz
> I think you are confused about this thread. See ,what does the OP ask for ?
> :-))))))))))))))))
>
>
> "Omnibuzz" <Omnib***@discussions.microsoft.com> wrote in message
> news:4AF72CF7-A02E-423A-BF50-A1A95EF10D38@microsoft.com...
> > try this
> >
> > SELECT subsnp_id,pop_id,allele_id
> > FROM AlleleFreqBySsPop as A,
> > (SELECT Omim_No
> > FROM av
> > WHERE Description LIKE '%LIVER%'
> > ORDER BY Omim_No ASC
> > UNION ALL
> > SELECT Omim_No
> > FROM cs
> > WHERE CS_Description LIKE '%LIVER%'
> > OR CS_DATA LIKE '%LIVER%'
> > ORDER BY Omim_No ASC
> > UNION ALL
> > SELECT Omim_No
> > FROM ti
> > WHERE Omim_Titles LIKE '%LIVER%'
> > ORDER BY Omim_No ASC
> > UNION ALL
> > SELECT Omim_No
> > FROM ti_alt_title
> > WHERE Omim_Alt_Titles LIKE '%LIVER%'
> > ORDER BY Omim_No ASC
> > UNION ALL
> > SELECT Omim_No
> > FROM tx
> > WHERE Omim_Text LIKE '%LIVER%' ) as B
> > WHERE A.source LIKE '%' + cast(B.Omim_no as varchar) + '%'
> >
>
>
>

7 Apr 2006 6:50 AM

ML

Wrong query, too. :) Check out the correct post.

ML

---
http://milambda.blogspot.com/

7 Apr 2006 7:18 AM

Omnibuzz

Guess I better take a break for sometime :) Thanks for pointing it out.

7 Apr 2006 7:25 AM

ML

You'll feel better after a peaceful weekend. :)

ML

---
http://milambda.blogspot.com/

10 Apr 2006 11:46 PM

Tlink

Error is still present, this happens to all connection types is this an
error with .net 2.0 perhaps ?

Show quote

"Tlink" <Tlink@online.nospam> wrote in message
news:%23kBqCteWGHA.2080@TK2MSFTNGP05.phx.gbl...
>I am performing a update to 2m+ records, when it reaches 200 records it
>times out ?
>
> rsobj = db.execute("select * from Somefile where t2 is null;")
> do while
>    db.commantimeout = 0
>    ******** newexp & newfactor are calculated *****
>    SQLLine = "UPDATE Australia..InProgress SET t2 = '" & NewExp & "',t3
> ='" & NewFactor & "' where t1 = '" & business & "';"
>    DBobj.Execute(SQLLine)
> Loop
>
> When I monitor the current processors they are all awaitting command
>