473,545 Members | 1,773 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

How to manually check for a DB connection at the Form Load event?

Tim
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
Message-ID: <u$************ **@TK2MSFTNGP09 .phx.gbl>
Newsgroups: microsoft.publi c.dotnet.langua ges.vb
NNTP-Posting-Host: dsl21.htonline. net 12.159.202.82
Lines: 1
Path: number1.nntp.dc a.giganews.com! internal1.nntp. sjc.giganews.co m!border2.nntp. sjc.giganews.co m!nntp.giganews .com!cyclone-sf.pbi.net!216. 218.192.242!new s.he.net!news-hog.berkeley.ed u!ucberkeley!en ews.sgi.com!msr newsc1!TK2MSFTN GP08.phx.gbl!TK 2MSFTNGP09.phx. gbl
Xref: number1.nntp.dc a.giganews.com microsoft.publi c.dotnet.langua ges.vb:214930

Hello.. I have VB.NET 2003 Standard or Pro edtion and today I thought
about using it to develop a Windows App that would allow my client to
update a database (SQL server 2000) that resides on my Dot Net Web
Hosting at a remote site. The Database has about 5 tables that hold
information that will be queried and written to a Data Grid on the Web
Form, but to do Inserts, and Updates, etc, I wanted to be able to use
VB. Well, I tried to use the Data Tools, and I received a message when I
was setting up my connection that my version of VB didn't allow any
connection to any SQL server except MSDE on my local machine.. So, I
know I can do it with code, but now I have to check to see if a
connection exists, and if it doesn't I need to maually connect to the
database I'm thinking when my first form loads / splash screen so that I
can load as much as possible right up front.. (Should I not do this? )..
I could of course connect to the Database manually in code with the a
button click to do an insert, edit, etc.. but I wanted to do so when the
app opens.. Any help in the approach or examples on the web would
greatly be apprecaited as I'm new to Dot Net, and VB.NET in paticular as
I'm an old ASP guy..

Thanks
Tim

Nov 20 '05 #1
0 1032

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

Similar topics

0
1497
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...
1
5983
by: Fred Zuckerman | last post by:
With Access2k, I have a text control on my startup form that uses dlookup() on an ODBC-linked table. The linked table is actually on SQL Server and the link uses a .dsn file Sometimes, when the SQL Server is down (or messed up somehow), the link is not working. When that happens the startup form doesn't load properly and there is a 30-45...
4
5611
by: GAVO-UK | last post by:
Hello everyone. Using Access 2003 and MSDE I just started experimenting using Access as the front end for SQL using *.adp, and would like to connect the front end to the back end remotely, purely through the internet to a remote computer, hosting the SQL Server (MSDE), but the problem is that I don't know where to start, the only thing I...
1
4113
by: Dan | last post by:
All, I have a form with a check box on it for which I have implemented a CheckedChange event. The form is the front end of a complex data entry system. When I load the form I check for previously entered data and load that into the form. If a certain value exists then I set the CheckBox Checked property to true. The problem that I have is...
6
1392
by: Karl Hungus | last post by:
Im using an xsl transformation so its not practical to use controls in the usual way, but I would still like to call methods in my codebehind class. usually Id just use onclick="<eventHandler>" say for something like a button control is there a way to manually call a method defined in a codebehind class, but is not called by a standard...
10
2124
by: Chad Miller | last post by:
I currently have a base form that I inherit. The base for has a custom event. The event will not raise threw the inherited form. I was wondering if events work threw inheritance or should I use some other method? -- Chad Miller President and Director of Software Development Predictive Concepts, Inc. www.predictiveconcepts.com...
2
1599
by: PH | last post by:
Hi; I got an application written in ASP.NET (VB.NET and C#) that uses connection pooling. The Max connections defined in the connection command are 50, and there are no more than 3 or 4 user using the application (intranet). I very carefully open the connections in the LOAD event and close them in the PreRender event. Usually I got only...
3
2229
by: mayur_hirpara | last post by:
Hi, I am writing a VB.NET application. It is a Windows application at the moment. The application contains a button. the click event of button perform a long running task. It needs to be started by windows task scheduler to carry out some operation. When I am testing the application I want to differentiate if the "differentiate between a...
3
4880
by: fniles | last post by:
In the Windows application (using VB.NET 2005) I use connection pooling like the following: In the main form load I open a connection using a connection string that I stored in a global variable g_sConnectionString and leave this connection open and not close it until it exits the application. Then on each thread/each subsequent sub that...
0
7457
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, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
0
7391
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...
0
7802
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 tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
0
7746
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...
1
5320
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes...
0
4941
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...
0
3443
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...
0
3438
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
1869
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 we have to send another system

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.