Greetings,
I've ran into a problem and I can't seem to find enough info on the topic.
Here is the code snipet
Dim myTableName as String = Test
Dim connectionString = "User=userID; Password=password;Host=123.456.789.123;Database=database;"
Dim dataTable as New MySqlDataTable("Select * FROM & myTableName, connectionString)
try
dataTable.Active = true
msgbox("connected")
catch ex as Exception
msgbox("could not establish connection" & ex.message)
end try
This code loops through a list of datatables. At some point I get an exeption saying lost connection to mySql server.
Question is this: When does a connection to mySql server gets established - when I dimention the dataTable with my connection string, or when I say dataTable.active = true?
From what I see in the help, dataTable.active allows datatable to get populated with data from the data source. it doesnt say anything about the connection being activated.