MySQL - MS SQL Connection help need

[fenyoster]

I need help in setting up connection to MySQL server and (or) MS SQL. What am I need to download for MS SQL, how to setting up driver class, connection string, etc.
When I want to connect to MySQL database i get error: class java.sql.SQLException: No suitable driver found for jdbc:mysql:<host name>/<db>

[phildunlap]

Hi fenyoster,

I assume this is about the SQL Data Source. You can find the driver class in the help dialogue for that data source. The little blue question mark (?) is next to the title "SQL Properties" on the SQL data source's edit page. The driver for mysql is com.mysql.jdbc.Driver

It looks like you're getting that error because the url is malformed. Your connection string should look more like jdbc:mysql://<host name>:<port>/<db> and the default port for MySQL is 3306

I have not attempted to use MSSQL, but if you wish to connect with it you'll need to find a jdbc driver jar, place it somewhere on the classpath for Mango (I recommend Mango/overrides/lib/ for that) and restart Mango (edit: restart may not be needed). Then you should be able to reference its Driver class (Googling suggests this may be the driver class: com.microsoft.sqlserver.jdbc.SQLServerDriver ) and connect to it (Googling suggests: jdbc:sqlserver:// is the prefix).

[fenyoster]

@phildunlap said in MySQL - MS SQL Connection help need:

com.mysql.jdbc.Driver

I`m updated the configuration as you said, and even further i get the error:
class java.sql.SQLException: No suitable driver found for jdbc:mysql:<host name>:3306/<db>

I entered the fields driver class name, connection string username, password. Is there something that must be set?

[phildunlap]

Does your connection string begin with jdbc:mysql://?

[fenyoster]

This post is deleted!

[fenyoster]

@fenyoster That was the problem, as you said! The double slash is failed!

jdbc:mysql://

Many Thanks!

Best Regards,
Fenyo