romanvo

romanvo

  • NA
  • 3
  • 0

Connect vb.NET to MySQL with SSL (mysql runs under Linux)

Jan 20 2005 8:48 PM
Hello! Does anyone know how to connect a vb.net application to a mysql database server using openssl?? I have mysql under Mandrake 10.1 with openssl. I connect this way: _____________________________ NOTE: DRIVER_ODBC is = "{MySQL ODBC 3.51 Driver}" con = New ADODB.Connection sentencia = "DRIVER=" & DRIVER_ODBC _ & ";SERVER=" & direccion _ & ";UID=" & usuario _ & ";PWD=" & contrasenya _ & ";DATABASE=" & nombre_bd con.Open(sentencia) _____________________________ Until now, what i tried is to give permissions to the users GRANT ALL ON DB.* to [email protected] IDENTIFIED BY 'hello'; with that works perfectly, but when i do GRANT ALL ON DB.* to [email protected] IDENTIFIED BY 'hello' REQUIRE SSL; it doesn't work. Please, does anyone know how to do it??? And please, if you answer, could you include "easy-to-understand" sample code? I know it's not nice to say that, but many times you receive just stupid answers that don't tell nothing. Ok!! Thanks , Roman.

Answers (1)