Xojo2016 MySQLCommunityServer ERROR

if you use the xojo216r3 version you must take into account that the plugin has a bug, it does not consider the .connect method.

then this will drive you crazy, because it will not connect to the DB on the web and will fail in db3.connect.

dim db3 as New MySQLCommunityServer 
  db3.host="149.xx.xxx.xxx"
  db3.port= 3306
  db3.databaseName="yourDbName"
  db3.userName="Admin"
  db3.Password="1234"
  db3.SSLMode = False
  if db3.Connect then //<-- Error
    dbFact = db3
  else
    MsgBox("DBFACT falla de conexión")
  end if

SOLUTION:

Copy a previous MySQLCommunityServer plugin and paste it above
C:\Program Files\Xojo\Xojo 2016r3\Plugins

2016 is too old. With time you will become incompatible with newer versions of DBs. For instance, can’t log in to newer PostgreSQL instances that uses SCRAM for authentication, that option wasn’t available in older Xojo versions. Consider upgrading to the most stable newer one as soon as you can.

1 Like

Upgrading is the solution, but those of us who live in South America have a terrible income gap with the USA and Europe, so we work with what we have.

I know. That’s why I said “as soon as you can”. That time may be very flexible.

1 Like