467,917 Members | 1,358 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 467,917 developers. It's quick & easy.

time out expired

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
  • viewed: 830
2 Replies
Expert 1GB
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
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

Sep 8 '08 #3

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

6 posts views Thread by Keith | last post: by
reply views Thread by Thotatri | last post: by
1 post views Thread by Dale | last post: by
reply views Thread by =?Utf-8?B?c3Jpbml2YXM=?= | last post: by
4 posts views Thread by joaotsetsemoita | last post: by
1 post views Thread by hackerbob | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.