connecting to mysql in vb.net
Good day.
I have a problem in connecting to mysql in vb.net. I created a udl file that connects to a mysql data source using odbc.
--
Dim ftpcon As New System.Data.Odbc.OdbcConnection
Dim ftpcom As New System.Data.Odbc.OdbcCommand
Dim ftpdatareader As Odbc.OdbcDataReader
sub init
ftpcon.ConnectionString = "File Name=" & Application.StartupPath.ToString & _
"\cgcserver.udl"
ftpcom.Connection = ftpcon
ftpcon.open
end sub
--
when i just initialize the following code, it generates an error stating, "keyword not supported, file name" . but in other connections, such as oledb it works just fine. doest odbc.net doesnt support udl's? im using visual studio.net 2003
any help would be greatly appreciated. thank you very much,.