kk chowdary 12.Sep.11 05:44 AM a Web browser LC LSXAll ReleasesWindows
I'm trying to connect to MySQL using LcConnection and used the below code. Same code used to connect for many SQL db's and working fine. And now it fails to MySQL.
I'm trying in many ways.. but not able to thru'.
I can't install any odbc drivers on server.. pls let me know if there any options....
Dim con As New LCConnection("oledb")
'Getting and setting the SQL details to connect the con
con.Provider=ConfigDoc.FCON_SQLProvider(0)
con.Server=ConfigDoc.FCON_SQLServer(0)
con.Userid = ConfigDoc.FCON_SQLUserID(0)
con.Password = ConfigDoc.FCON_SQLPassword(0)
con.Database = ConfigDoc.FCON_SQLDatabase(0)