473,670 Members | 2,307 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

accessing mySQL from asp.net

Are there class libraries available for accessing MySQL DBs from .net?
Coming from a SQL Server/MS shop this is a little new to me. Any other
resources would be helpful as well... thanks!

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Nov 16 '05 #1
4 1641
Phil,

I believe that you can download managed mySql data providers from the
mySql site. They would allow you to access mySql in a manner which you are
accustomed to in .NET with other data providers (connection, command, data
reader objects).

Hope this helps.
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard. caspershouse.co m

"Phil Townsend" <ph*******@yaho o.com> wrote in message
news:ue******** ********@TK2MSF TNGP12.phx.gbl. ..
Are there class libraries available for accessing MySQL DBs from .net?
Coming from a SQL Server/MS shop this is a little new to me. Any other
resources would be helpful as well... thanks!

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Nov 16 '05 #2


Phil Townsend wrote:
Are there class libraries available for accessing MySQL DBs from .net?


See
<http://www.mysql.com/products/connector/net/>
you can use ADO.NET classes with that.

--

Martin Honnen
http://JavaScript.FAQTs.com/
Nov 16 '05 #3
Phil,

In addition to what Nicholas wrote you can download providers from Seven
Objects and CoreLab. I have put the links below. If you do not like any of
those you can always use OleDb.

Good Luck
-------------------------------
http://www.crlab.com/mysqlnet/
http://www.sevenobjects.com/MySqlClient.aspx

"Phil Townsend" wrote:
Are there class libraries available for accessing MySQL DBs from .net?
Coming from a SQL Server/MS shop this is a little new to me. Any other
resources would be helpful as well... thanks!

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Nov 16 '05 #4
Brian Brown wrote:
Phil,

In addition to what Nicholas wrote you can download providers from Seven
Objects and CoreLab. I have put the links below. If you do not like any of
those you can always use OleDb.

CoreLab is a pretty good one, i've used their MySQL components for Delphi for years now
and no problems so far + excellent email support by their programmers, even if you just use a trial version.

Good Luck
-------------------------------
http://www.crlab.com/mysqlnet/
http://www.sevenobjects.com/MySqlClient.aspx

"Phil Townsend" wrote:

Are there class libraries available for accessing MySQL DBs from .net?
Coming from a SQL Server/MS shop this is a little new to me. Any other
resources would be helpful as well... thanks!

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Nov 16 '05 #5

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

Similar topics

0
1554
by: sanjay gupta | last post by:
Hi All, I have recently installes mysql -4.0.0.1 on my redhat 7.1 machine . After installing when enter into mysql it gives me message " Access denied for user root@local host .......using password yes" i have tried all the options like #mysql -u root -h localhost #mysql -u root -h localhost -p
0
1576
by: Bob M | last post by:
This question is about MySQL and how it can be accessed with OpenOffice (presumably the same issue would arise with MS Office, but I'm not sure about that). The problem I'm having is with the setup in OpenOffice. The database currently consists of a single table, located in c:\MySQL\data. The database is CD_Collection; the table name is Album. There is no password associated with the database/table. (I'm just getting started, and wanted...
4
144703
by: Spare Brain | last post by:
Hi, I am trying to run the MySQL DB on a Linux machine that is part of a home LAN (IP=192.168.0.3), while trying to access it from another WinXP machine (IP=192.168.0.5). I keep getting the following error: MySQL Error Number 1130 #HY000Host '192.168.0.5' is not allowed to this MySQL server Ping works fine.
3
4313
by: prodirect | last post by:
Hi all, I hope someone can help me. I've recently created a database and wanted to put it up on an ftp sight so that multiple people could access the same tables at the same time from different geographical locations. I have been completely unsucessful in acheiving this goal so far however. Things I have tried: Create a shortcut to ftp sight via browser then tried to map local drive to
1
1620
by: zMisc | last post by:
Is it possible to have a visual basic application running under windows and access MySQL database on a Linux box? Any extra drivers required for this? Any help greatly appreciated. Tks John
6
4164
by: Adam McCormack | last post by:
Good morning, I hope I'm not repeating a post, but I did try to search for the topic before asking. I am trying to resolve an issue that has come up as a result of planned migration from a single server solution to a distributed solution. A site (and interrelated batch processing scripts) has been running on a single server (IIS 6, win 2003) to two machines both are IIS 6, win 2003, the machines are as follows: box1: Webserver box2:...
4
2757
by: scout3014 | last post by:
Hi I am using WAMP5 to create web applications. I have a problem as far as accessing the database is concerned. This following code is used to access database: $con = mysql_connect("localhost", "root", ""); if (!con) { die('Could not Connect' . mysql_error()); }
19
2168
by: cj | last post by:
I'm getting terrible response times trying to pull data from VFP tables using .net--like 2 minutes! Can someone help? f:\arcust01 currently contains 187,728 records and is indexed on CUSTNO i:\btn currently contains 5,999,657 records and is indexed on BTN Imports System.Data.OleDb Public Class Form1
1
1452
by: afiroz | last post by:
Dear All, Plz let me know, how the field of mysql to be hyperlinked. I have mysql table in which there is some field, in which there is four letter code like "1aed" , it is to be access through php script, and it is accessing, when four lletter code is accessed, how it should be made hyperlinked to some url. thanks firoz
0
8469
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
8386
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 synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
8903
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
8661
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...
0
7419
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
6213
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
4211
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...
0
4391
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
2
2042
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.