469,647 Members | 1,711 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

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

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


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.

[Sham Shrinivas Yemul]
Visit following web site for Colored flame lamps

Intellisoft Computer Consultants Pvt. Ltd.
340 A Sakhar peth, Solapur - 413005
Phone : 91-(0)217-262 4713
Email : ye***@fusemail.com
Jul 21 '05 #1
0 1339

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Patrick.O.Ige | last post: by
2 posts views Thread by Nils Magnus Englund | last post: by
3 posts views Thread by Nils Magnus Englund | last post: by
3 posts views Thread by Agnes | last post: by
1 post views Thread by swatiminiyar | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.