473,598 Members | 3,266 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

23 Feb 2004, Solution/tunning for "Time Out Expired" , Vb.net/Sql Server2000, connection object


Hello,

We developed an application that has many data entry forms and data
controls in Vb.net and Sql Server2000 as backend.
For this application we created connection object on load event of every
form. The application runs on Server machine with no errors.
We got some errors when the application/.exe run on client node, There is
no error till log-in happens, the log-in form uses connection object. After
that , when we click to open any form , typically we got error as "time out
expired". It seems it is happening when application starts fetching data
from Sql Server on server machine.

Any suggestions , comments and help are welcome.

We are not sure whether this is happening because of connection objects
created on every new form that user clicks.

Which one will take least resources and more reliable, faster
a. Create Connection object globally.
b. Create Connection object for every form that needs data connection.

Other Details :

Operating System : Windows Xp
Development Platform : Visual Basic.net Trial Edition
Database : Sql Server 2000(Mixed Mode is enabled)

Thanks in advance for your help.

Regards.
[Sham Shrinivas Yemul]
--
Visit following web site for Colored flame lamps
http://in.geocities.com/osyemul/index.html

*************** *************** *************** **
Intellisoft Computer Consultants Pvt. Ltd.
340 A Sakhar peth, Solapur - 413005
Phone : 91-(0)217-262 4713
http:\\intellis oft.netfirms.co m
Email : ye***@fusemail. com
*************** *************** *************** **
Jul 21 '05 #1
0 1501

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

16
15726
by: Dave Smithz | last post by:
Hi, In summary: I want to a form to submit information via a HTTP POST, however, when using Internet Explorer I want to be able to use the back button and all the information retained. Presently we get a "Page has expired" message. How can we avoid this? Full details: Having searched for postings on how to avoid the "Page has Expired" they are
3
2775
by: Ed Burns | last post by:
Hi. I am trying to disable a user from going back to a previous page and displaying information previously shown. I want to give them the typical "Page has Expired" warning message. I am using Win Server 2003. Does anyone know what you have to do so that the user can only see the page once and not to be able to click back and see a cached page. Thanks! Ed
1
1524
by: Patrick.O.Ige | last post by:
Hi All, How can i get rid of "Warning :Page has expired" Question after clicking on BACK button on the browser?I have an application that uploads a file to a Server and after "Confirmation that file is uploaded" i press the BACK button and it gives the error.. Any solution to this! Patrick
2
2383
by: Nils Magnus Englund | last post by:
Hi, I've made a HttpModule which deals with user authentication. On the first request in a users session, it fetches data from a SQL Server using the following code: using (SqlConnection connection = new SqlConnection(ConfigurationSettings.AppSettings)) {
3
13965
by: Nils Magnus Englund | last post by:
Hi, I've made a HttpModule which deals with user authentication. On the first request in a users session, it fetches data from a SQL Server using the following code: using (SqlConnection connection = new SqlConnection(ConfigurationSettings.AppSettings)) {
0
860
by: Sham Yemul | last post by:
Hello, We developed an application that has many data entry forms and data controls in Vb.net and Sql Server2000 as backend. For this application we created connection object on load event of every form. The application runs on Server machine with no errors. We got some errors when the application/.exe run on client node, There is no error till log-in happens, the log-in form uses connection object. After that , when we click to open...
3
1480
by: Agnes | last post by:
My client said when he got "Timeout Expired", once he press the button. whole applciation is quit. I want to "produce the same error " in my development environment but don't know how to do ? Thanks a lot .
4
5702
SndFX69
by: SndFX69 | last post by:
Hello All I'm trying to login to my hosting control panel and started getting this error message, "Sorry, your session key has expired, please login again" I have been troubleshooting this problem for 2 days and can't find anything on the internet, I've tried to use other browsers (Firefox, Netscape, etc.) but with no luck I get the message on all browsers. So, if you have ever faced this problem and found a solution for it, I...
1
3258
by: swatiminiyar | last post by:
Hi all, I am getting a problem of Page expiration in IE .I have searched a lot on web.I got many results but not able to resolve my problem. I have a a form where i will write a article.I will specify its contents and title ans category and subcategory.By clicking on upload button i go to the page (page2.php) where i can upload the images for articles.I have a return button on click of which i come to previous page (page1.php) On this...
0
7899
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 effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
1
8050
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 Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
8264
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 protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
6718
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
0
5438
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
3897
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 last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
3939
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
1504
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
1250
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

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.