Okay, I have the attached code which connects to a MSSQL server. What I want, if possible, is the most similar code I can that will connect to a mySQL server. I would like the syntax to be as similar as possible.
Set cConnection = CreateObject("ADODB.Connection")
DBConString = "Provider=SQLOLEDB.1;Data Source=servername;Initial Catalog=Portal_Test"
SQLstmt = "SELECT ServerName, Notes from ServerData"
Set RS = cConnection.Execute(SQLstmt)
Do While (not RS.EOF) and (intCount < 5)
intCount = intCount + 1