What a small world we live in now. This month had me land a new software development using MySQL in an embedded PC that must boot up and start collecting data into the SQL database. No user interaction is possible.

To automate the logon, I use this VB code in my application:

conn.ConnectionString = "DRIVER={MySQL ODBC 3.51 Driver};" _
& "SERVER=" & sqlhost & ";" _
& "DATABASE=doorstatus;" _
& "UID=autodata;" _
& "PWD=autopass;" _
& "OPTION=" & 1 + 2 + 8 + 32 + 2048 + 16384

In short, I coded the application to allow this.

Answer? Change your code.

Bob