asp.net with MYSQL

•

What is DaniWeb IT Discussion Community?

You're currently browsing the ASP.NET section within the Web Development category of DaniWeb, a massive community of 391,767 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 3,196 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.

Join our community!

Please support our ASP.NET advertiser: Lunarpages ASP Web Hosting

Thread Tools Display Modes

Views: 505 | Replies: 1

•

Join Date: Aug 2007

Posts: 76

Reputation: anto_nee is an unknown quantity at this point

Rep Power: 2

Solved Threads: 4

anto_nee

Offline

Junior Poster in Training

asp.net with MYSQL

Aug 21st, 2007

Can anyone give me the step by step explanation for connecting asp.net with MYSQL

•

Join Date: Dec 2006

Location: United States

Posts: 612

Reputation: binoj_daniel is an unknown quantity at this point

Rep Power: 3

Solved Threads: 14

binoj_daniel binoj_daniel is offline

Offline

DaniWeb Expert

Re: asp.net with MYSQL

Aug 21st, 2007

You can use two approaches to connection to MySQL Database.

1.) MyODBC 3.51 Local database (using ODBC)
Driver={MySQL ODBC 3.51 Driver};Server=localhost;Database=myDataBase; User=myUsername;Password=myPassword;Option=3;

2.) OLE DB, OleDbConnection (.NET)
Provider=MySQLProv;Data Source=mydb;User Id=myUsername;Password=myPassword;

You can also try some open source MySQL Drivers but the above 2 are really reliable.

You can also read an article on using MS Access with ASP.NET here
You can also download the sample application by simply registeting.

Binoj Daniel
Best Place to hunt for Code | Quality Web Designing | Custom Software