Connecting MYSQL thru VB

• • Reply

  18 years ago

  by geetapm

  Geeta Matlani

  , India

  Joined 18 years ago

  how to connect MYSQL database through Visual Basic, its urgent.
  

  
  Thanx
  

  
  Bye

  Report abuse
• • Reply

  18 years ago

  by Apoc

  Michael Gagne

  Dallas/Fort Worth, TX, United States

  Joined 19 years ago

  Use ADO.  Add a project reference to Microsoft OLE DB ActiveX Data Objects 1.0 Library.  Then, use this code:
  

  
  

  Code:

  
  Dim conn1 as ADODB.Connection
  Dim rst1 as ADODB.Recordset
  Dim SQLConnect as String
  Dim SQLSelect as String
  

  
  SQLConnect = <connectionstring>     ' I'm not sure what the MySQL Connection string is...just do a search for "MySQL ADO Connection String"
  

  
  Set conn1 = new ADODB.Connection
  

  
  conn1.ConnectionString = SQLConnect
  conn1.Open
  

  
  Set rst1 = conn1.Execute(SQLSelect)
  

  
  

  
  That should get you started on your way.  Sorry I couldn't be more specific, but I was just going off the top of my head.  Hopefully that helped you out a little bit.  Good luck!
  

  
  

  
  

  
  

  Report abuse