how to use mysql with asp.net

Question

2.33/5 (3 votes)

See more:

ASP.NET

MySQL

i want to use mysql with asp.net

Posted 22-Dec-11 5:36am

naren programmers

Updated 15-Jan-12 23:30pm

v3

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Wendelius · Accepted Answer · 2011-12-22T05:47:00

Solution 1

Few links to start with:
- A Step-by-Step Guide To Using MySQL with ASP.NET - Part 1[^]
- Using MySQL with ASP.NET - Part 1 [^]

And the list continues at here[^]

Posted 22-Dec-11 5:47am

Wendelius

Comments

Uday P.Singh 22-Dec-11 11:56am

5ed :)

Wendelius 22-Dec-11 12:06pm

Thanks Uday :)

Wendelius 22-Dec-11 12:05pm

You have to define the DSN using control panel / ODBC admin and use that DSN name. Note that if you're using 64 bit windows the DSN may have to be defined in 32 bit sources, see: http://support.microsoft.com/kb/942976[^]

Uday P.Singh 22-Dec-11 12:15pm

why not use the Connector/Net instead of ODBC. And refer this for implementation.

Wendelius 22-Dec-11 14:45pm

That's also a possibility

Sergey Alexandrovich Kryukov 22-Dec-11 12:39pm

My 5.
--SA

Wendelius 22-Dec-11 14:45pm

Thanks :)

Amir Mahfoozi 22-Dec-11 12:55pm

+5

Wendelius 22-Dec-11 14:45pm

Thanks :)

thatraja 22-Dec-11 13:02pm

5!

Wendelius 22-Dec-11 14:46pm

Thank you :)

thatraja 23-Dec-11 11:44am

Forgot to vote yours like Uday's, check it now.

Wendelius 23-Dec-11 11:47am

Thanks, didn't even notice... Yes I did... No I didn't... Darn, can't remember anymore :)

Monjurul Habib 24-Dec-11 2:47am

5!

Wendelius 24-Dec-11 3:09am

THank you :)

Uday P.Singh · Accepted Answer · 2011-12-22T05:58:00

Solution 2

Try this:

An ASP.NET Application Using a MySQL Database[^]

hope it helps :)

Posted 22-Dec-11 5:58am

Uday P.Singh

Comments

Wendelius 22-Dec-11 12:06pm

Good link, 5'd

Uday P.Singh 22-Dec-11 12:24pm

thank you Mika :)

naren programmers 22-Dec-11 12:16pm

i tried both i did not understand what to do becuse i did not get how to make it run i studied these before and uploaded this page on server
please see the page u will see connection string too
http://programmersvalley.com/default3.aspx
but error is
ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
if you see this url u can see the connection string also please see and revert back

please help

Uday P.Singh 22-Dec-11 12:24pm

refer my reply to your comment in Mika's answer.

Uday P.Singh 22-Dec-11 12:53pm

What is confusing? did you visit the link in my reply, it has the complete step by step explanation of using Connector/Net in your application. If you can't understand that, then I am afraid about your future as a good developer.

Sergey Alexandrovich Kryukov 22-Dec-11 12:40pm

My 5 for the answer. OP is hard to help...
--SA

Uday P.Singh 22-Dec-11 12:45pm

perhaps you are right, thanks for 5!

Amir Mahfoozi 22-Dec-11 12:55pm

+5

Uday P.Singh 22-Dec-11 13:01pm

thank you Amir :)

thatraja 22-Dec-11 13:02pm

5!

Uday P.Singh 23-Dec-11 11:30am

I think you forget to vote :(

thatraja 23-Dec-11 11:43am

Oops, Check it now. Sorry :) Also forgot to vote Mika's

Uday P.Singh 23-Dec-11 11:45am

thank you, it happens with me sometimes :)

Monjurul Habib 24-Dec-11 2:47am

5!

Uday P.Singh 26-Dec-11 1:57am

thank you Monjurul :)