Timeout Expired error while using in SELECT Query

Hi!
I am using SQL Server 2000 as a backend for a dotNet application that I have created. I get an error, "[Microsoft][ODBC SQL Server Driver] Timeout expired", while using a select query. I cannot provide you the query in full as it is too long so I am providing the query in part for presenting the exact picture. The User_Id used in the query are about 1300 in number. Can some one let me know what needs to be done?

Regards
Shankaran


SELECT Location_Name, User_ID
FROM Location_Info
WHERE User_Type = '1'
AND Location_Type = ''
AND User_ID IN ('a.balajikumar','a.chattopadhyay','a.krishnan','a .lall','a.navin','a.palanisamy','a.paul','a.sandee pkumar','a.srinagesh',
'a.vijayasarathi','aarbeenkumar.baruah','aashish.s ehgal','abdul.khan','abhai.pande','abhay.sonone',' abhayakumar.mishra','abhijeet.bose',
'abhijeet.chakraborty','abhijeet.das','abhijit.ban erjee','abhijit.das','abhijit.joshi','abhijit.maha patra','abhijit.saha','abhinaya.srivastava',
'abhishek.mathur','abinand.lahiri','achilesh.malvi ya','achinta.das','achintya.ghosh','aditya.chakrab orty','aditya.thakur','agnibesh.chakraborty',
'AJ.Menezes','ajay.bharti','ajay.bhatia','ajay.cha uhan','ajay.garg','ajay.gupta','ajay.khanna','ajay .lonkar','ajay.mudgal','ajay.suri','ajay.trivedi',
'ajay.wadhwa','ajit.kotnis','ajitkumar.nair','ajma l.fareed','ak.biju','ak.hajela','akshay.tiwari','a lak.pal','aldo.corda','alekhya.paul','alhad.joshi' ,
'alka.srivastava','alok.grover','alok.kumar','alok .kumar1','alok.saxena','alok.tandon','alpesh.upadh yay','aman.trikha','amaresh.sharma',
'amarpreet.singh','amartya.choudhury','amirineni.k rishna','amit.arvind','amit.bansal','amit.kaushik' ,'amit.khanna','amit.mehrotra','amit.mukherjee',
'amit.s','amit.sharma1','amit.yadav','amitabh.chou dhury','amitabh.sharma','amitav.chatterjee','amita va.das','amitava.dutta','amitava.ghosh',........

set lock_timeout = -1

SELECT Location_Name, User_ID
FROM Location_Info
WHERE User_Type = '1'
AND Location_Type = ''
AND User_ID IN ('a.balajikumar','a.chattopadhyay','a.krishnan','a .lall','a.navin','a.palanisamy','a.paul','a.sandee pkumar','a.srinagesh',
'a.vijayasarathi','aarbeenkumar.baruah','aashish.s ehgal','abdul.khan','abhai.pande','abhay.sonone',' abhayakumar.mishra','abhijeet.bose',
'abhijeet.chakraborty','abhijeet.das','abhijit.ban erjee','abhijit.das','abhijit.joshi','abhijit.maha patra','abhijit.saha','abhinaya.srivastava',
'abhishek.mathur','abinand.lahiri','achilesh.malvi ya','achinta.das','achintya.ghosh','aditya.chakrab orty','aditya.thakur','agnibesh.chakraborty',
'AJ.Menezes','ajay.bharti','ajay.bhatia','ajay.cha uhan','ajay.garg','ajay.gupta','ajay.khanna','ajay .lonkar','ajay.mudgal','ajay.suri','ajay.trivedi',
'ajay.wadhwa','ajit.kotnis','ajitkumar.nair','ajma l.fareed','ak.biju','ak.hajela','akshay.tiwari','a lak.pal','aldo.corda','alekhya.paul','alhad.joshi' ,
'alka.srivastava','alok.grover','alok.kumar','alok .kumar1','alok.saxena','alok.tandon','alpesh.upadh yay','aman.trikha','amaresh.sharma',
'amarpreet.singh','amartya.choudhury','amirineni.k rishna','amit.arvind','amit.bansal','amit.kaushik' ,'amit.khanna','amit.mehrotra','amit.mukherjee',
'amit.s','amit.sharma1','amit.yadav','amitabh.chou dhury','amitabh.sharma','amitav.chatterjee','amita va.das','amitava.dutta','amitava.ghosh',........