Announcement

Collapse
No announcement yet.

Connection string from SQL to mysql

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

    Connection string from SQL to mysql

    I would like to change the connection string from Microsoft SQL to MySQL, do you know what is the correct syntax?
    PHP Code:
         Dim Connection As New SqlConnection("Server=192.168.0.14\SQLEXPRESS;Database=HomeAutomationDB;User ID=SA;Password=xxxxxxx;Trusted_Connection=False;")
      
       
    'Dim Connection As New SqlConnection("Server=192.168.0.14:3306;Database=HomeAutomationDB;User ID=username;Password=password") 

    #2
    This is the entire script, any help will be greatly appreciated. I read many posts and sql connections. My challenge is that I can not run this script via an event, it needs to run from the startup.vb, I guess it want some parameters if I run it from the event.

    Thanks,
    Aldo
    Attached Files

    Comment

    Working...
    X