473,320 Members | 1,695 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Determining a mySQL servers status.


I am using vb.net and the myoledb provider.

I've run into a problem where what I need to do is open a database
connection to a mysql server, easy. The problem arrises in that I want
to, if the server cannot be found, open from a locally stored
encrypted XML file.

Works fine when the sever is present, but when I go to open the
connection and the database cannot be found, a dialog box pops up as to
fill in the connection string information. I do not want this, is there
any way I can intercept this dialog or skip past it so my try/catch
handles it?

Thanks.
--
Posted via http://dbforums.com
Jul 20 '05 #1
2 1872
"Iaiken" <me*********@dbforums.com> wrote in message
news:34****************@dbforums.com...

I am using vb.net and the myoledb provider.

I've run into a problem where what I need to do is open a database
connection to a mysql server, easy. The problem arrises in that I want
to, if the server cannot be found, open from a locally stored
encrypted XML file.

Works fine when the sever is present, but when I go to open the
connection and the database cannot be found, a dialog box pops up as to
fill in the connection string information. I do not want this, is there
any way I can intercept this dialog or skip past it so my try/catch
handles it?

Thanks.
--
Posted via http://dbforums.com


This is an MSSQL (Microsoft SQL Server) newsgroup, not a MySQL group...

Simon
Jul 20 '05 #2
Iaiken (me*********@dbforums.com) writes:
I've run into a problem where what I need to do is open a database
connection to a mysql server, easy. The problem arrises in that I want
to, if the server cannot be found, open from a locally stored
encrypted XML file.

Works fine when the sever is present, but when I go to open the
connection and the database cannot be found, a dialog box pops up as to
fill in the connection string information. I do not want this, is there
any way I can intercept this dialog or skip past it so my try/catch
handles it?


As Simon pointed out, this group is not for YourSQL but OurSQL. :-)

I don't know anything about the myoledb provider, but it sounds like
you are not feeding the provider with any server information at all.
It would be a funny provider that popped up a command dialog if you
fed it "Server-BOGUS".

But you get better response if you ask in a MySQL forum.
--
Erland Sommarskog, SQL Server MVP, so****@algonet.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp
Jul 20 '05 #3

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

Similar topics

1
by: Marc | last post by:
Hello, Newbie here..... Searching and working this for a week now. We too are having the same problems. Using MySql 4.0.14 and there are "no problems" at all.
12
by: Cliff Wells | last post by:
Hi, I'm writing an application that needs to know if an Internet connection is available. Basically, I want to have something similar to what a lot of email clients have, where the app can work...
0
by: Stefan Hinz | last post by:
Degan, jumping in to try and solve some problems that look pretty obvious to me ... > #options for default service (mysqld2) > (mysqld2) It should be , not (mysqld2).
0
by: Luc Foisy | last post by:
Last week many of our server and client servers had a power problem. Not = quite sure how the servers were handled, wasn't on site, but I don't = think some of these servers got shut down...
0
by: cjackson | last post by:
I'm having an odd problem while setting up one-way replication between 2 MySQL servers. The setup process seemed to go well, and when I examine everything, like processlists on both servers and the...
8
by: Fred | last post by:
Hello, Our website is currently developed in ASP/Mysql 4. The dedicated servers on which it is currently hosted arrive at saturation. Here is their configuration: - 1 server PIV 2,8Ghz 1GB...
3
by: menzies | last post by:
Hi, I"m new to this forum, but I have been trying all day to install DBD::mysql onto my Intel MacBook. I've read lots of forums pages and none have gotten me to a successful 'make test' or a...
0
JamieHowarth0
by: JamieHowarth0 | last post by:
I have been trying to find a solution to this on the Internet for months. Literally, ages and ages and ages, praying that someone in the open-source community has enough knowledge to put together an...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 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 former...

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.