By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,575 Members | 1,968 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,575 IT Pros & Developers. It's quick & easy.

time out expired

P: 31
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
Share this Question
Share on Google+
2 Replies

Expert 100+
P: 1,134
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

P: 112
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.