Member Avatar for anto_nee

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

  • 2 Contributors
  • 1 Reply
  • 67 Views
  • 17 Hours Discussion Span
  • Latest Post Latest Post by binoj_daniel
Member Avatar for binoj_daniel

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.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.