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

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

P: n/a
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
Message-ID: <u$**************@TK2MSFTNGP09.phx.gbl>
Newsgroups: microsoft.public.dotnet.languages.vb
Lines: 1
Path:!internal1.nntp.sjc.g!!nntp.gig!!!!!ucberkeley!!msrnewsc 1!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP09.phx.gbl
Xref: microsoft.public.dotnet.languages.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..


Nov 20 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.