473,507 Members | 2,379 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

time out expired

31 New Member
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
2 929
Delerna
1,134 Recognized Expert Top Contributor
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
112 New Member
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

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

Similar topics

6
2532
by: Keith | last post by:
Is there any way of detecting whether a session variable does not exist because it expired or because it simply did not exist in the first place? Thanks
5
2147
by: Mark | last post by:
Hi All, This maybe a really simple question but I need some help. I have been having problems with security and thanks to the help received from a reply to an earlier post, I have found a...
1
5816
by: jdph40 | last post by:
I am using Access 2002. I downloaded the forms sample database FrmSmp97.mdb from Microsoft and used the following code in the timer event of a hidden form in order to close a database if no...
0
2128
by: Thotatri | last post by:
hi, I am facing a session time out problem once after installing .net framework 1.1 . The problem is session is getting expired on frequently say 5 mts like that.I have good configuration &...
1
5139
by: Dale | last post by:
Hi, I encountered this error when I debug my asp.net web application. What might be the reason? How can I resolve this? Thanks! Server Error in '/ETS' Application....
15
4713
by: Nathan | last post by:
I have an aspx page with a data grid, some textboxes, and an update button. This page also has one html input element with type=file (not inside the data grid and runat=server). The update...
4
5447
by: chiragcp | last post by:
Sir, I am VB programmer and using MS-SQL 2000.I am new to this forum. I am getting error "TIME OUT EXPIRED" Background ========= we are having 10 sites. and server is now located at...
0
897
by: =?Utf-8?B?c3Jpbml2YXM=?= | last post by:
Hi, I'm running an ASP.net application where i'm using session variables. The mode is 'InProc' and timeout is 30 mins <sessionState mode="InProc" timeout="30"/>. The application is working fine...
4
6810
by: joaotsetsemoita | last post by:
hello everyone. Im trying to time out a loot after a certain time. Probably 5 to 10 minutes. I have the following function Private Sub processFileCreation(ByVal source As Object, ByVal e As...
1
2716
by: hackerbob | last post by:
I'm trying to create a constant time event timer. Basically, a routine can set a callback to be called n ms from the current time, and the main event loop will wait until the delta between the...
0
7223
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
7111
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
7376
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
1
7031
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
7485
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
3191
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The...
0
3179
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
0
1542
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...
1
760
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.