Connecting to a MYSQL database

Hi,

Based  on the database used you have to give connection string details accordingly. for ex

1. for mysql - https://www.connectionstrings.com/mysql-oledb-mysqlprov/

2. https://www.connectionstrings.com/sql-server-2008/

// MySQL connection string format is below

// Provider=MySQLProv; Data Source=mydb; User Id=myUsername; Password=myPassword
var connectionString = ""; // use above format with your server/db details and assign the string value to this variable
var objConnection = null;
var objRecordSet = null;
var query = "select * from table_1";  // your query on database

objConnection = Sys.OleObject("ADODB.Connection");
objConnection.ConnectionString = connectionString;
objConnection.Open();

objRecordSet = Sys.OleObject("ADODB.RecordSet");
objRecordSet.Source = query;
objRecordSet.ActiveConnection = objConnection;
objRecordSet.Open();
objRecordSet.MoveFirst();
while ( !objRecordSet.EOF ){
    intCount++;
    objRecordSet.MoveNext();
}

please let me know if it helps. thank you.