Having worked with JET and Access my entire life!, I have finally decided to take a look at SQL - in particular MySQL Sever version 4.1, MySQL Connector Net 1.0 (Net 1.1 , Visual Basic 2003).
Many examples I have seen have used ODBC to connect but I am currently looking at using the .NET reference provided with MySQL - perhaps some-one can tell me the Pros and Cons of these two methods - but that's an aside really.
My current problem is that this code simply does not connect. On the con.Open() command I get the exception: "specified cast is not valid."
Here's the code:
Dim Con As New MySqlConnection
Dim cmd As MySqlCommand
Con.ConnectionString = "server=localhost;database=smrs;uid=root;"
Catch ex As Exception
MsgBox("Can't open the database" & vbCr & ex.Message, MsgBoxStyle.Critical, "Error!")