1. Home
  2. Sample Coding
  3. ASP .NET OLEDB for MySQL

ASP .NET OLEDB for MySQL

Issue

Not sure with settings of  ASP .NET OLEDB for MySQL

Symptoms

None

Cause

Lack of knowledge with the ASP .NET OLEDB for MySQL

Workaround

STEP 1: Obtain the Sample Working Code from http://www.netonboard.com/download/OLEDBformysql.zip

STEP 2: There are 1 folder and 1 SQL file in the zip file.
Folder Name    : wwwroot
SQL File Name : oledbformysql.sql

STEP 3: Extract the zip file.

STEP 4: Create a Mysql Database via DotNetPanel by referring to http://www.supportchain.com/index.php?/Knowledgebase/Article/View/215/0/how-to-create-a-mysql-database-in-dotnetpanel

Database Name : mysqlsampledb
Database Username : YOURDATABASEUSERNAME
Database Password : YOURDATABASEPASSWORD

STEP 5: Import the MySQL structure in your newly created database with the following steps:

a) Login to http://mysql.YOURDOMAINNAME/
b) On the left panel, select the database that you wish to populate.
c) On the right panel, click on ‘SQL‘.
d) Paste the SQL Scripts that need to be imported in the ‘TextArea‘.
e) Click on the ‘Go‘ button to generate populate the database.

STEP 6: Edit the web.config file.

<add key=”ConnectionString” value=”Persist Security Info=False;database=mysqlsampledb;server=localhost;Connect Timeout=30;username=YOURDATABASEUSERNAME;password=YOURDATABASEPASSWORD”/>

Replace the database username and password with the correct credentials value.

STEP 7: Upload those files into your main domain or subdomain folder and ensuring that folders and files structure is in order.

STEP 8: Access the Uploaded Sample Code via http://YOURDOMAINAME/mysqlsample.aspx with web browser e.g: IE or Firefox.

Additional Information

If you are unable to resolve the problem above, kindly issue a ticket to Support Team. 

Updated on March 14, 2019

Was this article helpful?

Related Articles

Leave a Comment