B4J Question B4Packager11 and SQL [SOLVED]

The error mentions sqlite driver, are you sure you've told it to use the mysql driver?

Daestrum said:

The error mentions sqlite driver, are you sure you've told it to use the mysql driver?

Click to expand...

Yes I use both SQLite and MySQL in my program . It works perfectly from the B4j environment but does not work once compiled

#AdditionalJar: sqlite-jdbc-3.7.2
#AdditionalJar: mysql-connector-java-5.1.47-bin

It uses the sqlite first and loads those local files perfectly as can be seen by the Province Log.
and my declarations are

Private Sql2 As SQL
Private sql1 As SQL

This is the error line

Sql2.Initialize2("com.mysql.jdbc.Driver", "jdbc:mysql://162.215.252.76:3306/weed_quiz", "weed_abcd", "password") which again works perfectly thru b4J

I also did a sql1.close before this line just to check and still the same problem

I found the problem

Due to cable breaks on our WASC cable to connect from South Africa to the World, our ISP was using a different path and different pool addresses. Once I could see that using an old version of the SKD (Shows the IP address problem access denied. I jumped onto MySQL server config and added the new range and now everything works ok.

Thank you for your advise