troubleshooting Question

How to declare relevant classes and instantiate MySqlConnection object for connection to MySQL DB in ASP.NET

Avatar of psk1
psk1 asked on
MySQL Server.NET Programming
15 Comments1 Solution612 ViewsLast Modified:
I'm just getting started with attempting to connect to a MySQL database from ASP.NET (VB, web app).  I need to know how to declare the relevant classes and initiate the connection.

The MySQL DB is on a different server on the same LAN and I'd like to use a named pipe to access it, though I would also accept code that will connect using TCP/IP to get started.

So, what do I declare at the top of the page, and what code do I then use to instantiate the MySqlConnection object?
ASKER CERTIFIED SOLUTION
Daniel Reynolds
Software Applications Developer / Integrator

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Log in to continue reading
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform for $9.99/mo
View membership options
Unlock 1 Answer and 15 Comments.
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
The Value of Experts Exchange in My Daily IT Life

Experts Exchange (EE) has become my company's go-to resource to get answers. I've used EE to make decisions, solve problems and even save customers. OutagesIO has been a challenging project and... Keep reading >>

Mike

Owner of Outages.IO
Phoenix, Arizona, United States
Member Since 2016
Join a full scale community that combines the best parts of other tools into one platform.
Unlock 1 Answer and 15 Comments.
View membership options
“All of life is about relationships, and EE has made a virtual community a real community. It lifts everyone's boat.”
William Peck

Member since 2004