473,804 Members | 3,809 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

MySQL database connectivity

Hi,

I have a MySQL database on a remote server that I need to connect to. I
can't seem to figure out what the connectionstrin g should be? I've searched
through the help files, but all I can find is information for SQL server.

Thanks,

Steve
Nov 20 '05 #1
5 1311
Check out these page at the MySQL site:
http://www.mysql.com/articles/dotnet/
At present, one can access MySQL using the following 3 interfaces supported
by MySQL.
a.. The ODBC.NET Solution - MyODBC Driver.
b.. Using MySQL Native .NET Providers.
c.. Using the OLEDB.NET Solution - MyOLDDB Provider

--
Greetz,
Jan
_______________ _______________ ____
Read my weblog: http://weblogs.asp.net/jan
"Steven Caliendo" <sc*******@epio n.com> schreef in bericht
news:%2******** ********@TK2MSF TNGP10.phx.gbl. ..
Hi,

I have a MySQL database on a remote server that I need to connect to. I
can't seem to figure out what the connectionstrin g should be? I've searched through the help files, but all I can find is information for SQL server.

Thanks,

Steve

Nov 20 '05 #2
* "Steven Caliendo" <sc*******@epio n.com> scripsit:
I have a MySQL database on a remote server that I need to connect to. I
can't seem to figure out what the connectionstrin g should be? I've searched
through the help files, but all I can find is information for SQL server.


Did you have a look at <http://www.connections trings.com>?

--
Herfried K. Wagner [MVP]
<http://www.mvps.org/dotnet>
Nov 20 '05 #3
"Steven Caliendo" <sc*******@epio n.com> schrieb

I have a MySQL database on a remote server that I need to connect to.
I can't seem to figure out what the connectionstrin g should be?
I've searched
through the help files, but all I can find is information for SQL
server.

http://www.connectionstrings.com/

ADO.NET group: microsoft.publi c.dotnet.framew ork.adonet
--
Armin

http://www.plig.net/nnq/nquote.html
http://www.netmeister.org/news/learn2quote.html

Nov 20 '05 #4
Cor
Hi Steven,

I think the other links are enough, but here is another one

http://www.able-consulting.com/ADO_Conn.htm

Cor
Nov 20 '05 #5
connection strings are one thing, but when he dosnt have the ODBC or Ole
drivers for MySQL which are not there until you install them thats another
;)
"Herfried K. Wagner [MVP]" <hi************ ***@gmx.at> wrote in message
news:br******** ****@ID-208219.news.uni-berlin.de...
* "Steven Caliendo" <sc*******@epio n.com> scripsit:
I have a MySQL database on a remote server that I need to connect to. I
can't seem to figure out what the connectionstrin g should be? I've searched through the help files, but all I can find is information for SQL
server.
Did you have a look at <http://www.connections trings.com>?

--
Herfried K. Wagner [MVP]
<http://www.mvps.org/dotnet>

Nov 20 '05 #6

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

Similar topics

1
1487
by: Gaz Oakley | last post by:
Hi, I've looked through the mailing list archives trying to find the best ways of connecting to a MySQL database using Python. From what I've seen, people seem to be using http://sourceforge.net/projects/mysql-python/. First of all, is this the recommended method of connectivity? (I'm assuming it is). If it is, I've experienced a problem here. I'd ideally like to have Python 2.3 installed with MySQLdb. Following the instructions on...
2
1563
by: kimshapiro100 | last post by:
Question on PhP, MySQL I am thinking of a consumer internet business for which I will have to have a database driven site built. I am thinking of using PhP, MySQL as the main technologies amd Linux hosting( and some Dreamweaver). My question is:
20
1509
by: John Wells | last post by:
Yes, I know you've seen the above subject before, so please be gentle with the flamethrowers. I'm preparing to enter a discussion with management at my company regarding going forward as either a MySql shop or a Postgresql shop. It's my opinion that we should be using PG, because of the full ACID support, and the license involved. A consultant my company hired before bringing me in is pushing hard for MySql, citing speed and community...
6
1441
by: Steven Caliendo | last post by:
Hi, I have a MySQL database on a remote server that I need to connect to. I can't seem to figure out what the connectionstring should be? I've searched through the help files, but all I can find is information for SQL server. Thanks, Steve
5
15406
by: linuxlover992000 | last post by:
I am a newbie in the world of MySQL. In fact I enabled it in my Linux box only because it is required to run WordPress (the blogging software). I was trying to plan ahead and figure out a way to backup (and restore) a database, should my Linux machine ever goes belly up. I disovered that the databases are stored in subdirectories under /var/lib/mysql. My questions are basically three: (1) Why /var/lib? Why not some /home/mysql or...
13
1565
by: Auddog | last post by:
I have installed php on my server and can get the phpinfo page to display. I have installed mysql 5 and I'm able to get into the database and create data. I would like to be able to get php to pull the data. I have been reading on the internet as to what I need to do in php and have created a couple of pages. When I go to the page all I get is a blank screen - no data from the database. I edited my php.ini file to allow for mysql. I...
10
1486
by: bill | last post by:
I have a database of kennels. One page lists the kennels alphabetically by kennel name. I have a field for kennel name and an index with kennel name as the only field. Some of the kennels have the word "The" as the first word in the name and they do not want to be listed alphabetically by "The..." Is there a way that I can request that mysql ignore "The" in a kennel name when ordering it or must I create a new field for the
10
3403
rhitam30111985
by: rhitam30111985 | last post by:
hi all .. java/jdbc newbie here ... i cant seem to perform the most basic step for database connectivity using java . here is my code : import java.sql.*; public class connect { public static void main (String args) {
0
13851
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 LDAP connector for MySQL Community to connect to Active Directory. Alas, nothing. So I figured I'd try doing something similar. My business problem is/was as follows: I use Active Directory on Windows Server 2003 to manage my small corporate...
0
9706
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 usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
10325
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 captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
10315
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
10075
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...
1
7615
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 instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
6847
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
5519
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...
1
4295
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
2
3815
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

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.