time out expired

brettokumar

hi i ma using a query like to select country code using between query cause ip

if im using this query i will fetch value sometime but i will display time out expired error some time.

to over come this problem what can i to do

can share your ideas with me

my query is

SELECT countryShort FROM IPCITYLATLONGISP WHERE '3678433939' between ipFrom and ipTo

Sep 5 '08 #1

Delerna

Is it timing out at the Front end?
If so, does it time out if you run it from query analyser?
What are you using for the front end?

How many records are there in IPCITYLATLONGISP?
If lots. do you have an index on ipFrom and ipTo?

The query seems a little strange but I will say no more until I know a little more about what you are trying to do.

Sep 7 '08 #2

imtmub

Follow this steps.
1. Right click on Server on Enterprise Manager
2. Click Properties then select Connection Tab
3. Set query time out to 0 (O is unlimited)

Let me know the answer helped you

Imt

Sep 8 '08 #3