ParthMagu's picture

Hi All ,

 

Unable to make connection from ARIS Mashzone to SQL databasse

I want to connect Aris Mashzone 2.3.1.0.1656 with My Sql Database .I have installed mysql-connector-java-5.1.5.jar and sqljdbc4.jar under jdbcdriver directory .

Database URL Used to connect to SQL database :

Driver :com.mysql.jdbc.Driver

Database URL :jdbc:mysql://address=(protocol=tcp)(host=******)(port=*****)(User=****)/DBname

It gives me below error while connecting to aris mashzone .

****"The following error occurred when connecting to database "QA_DB": Must specify at least one slave host to connect to for master/slave replication load-balancing functionality"****

Then I installed sqljdbc4.jar and placed it in jdbcdriver directory and restarted the server .

It is giving me different error .

PFB error

"The following error occurred when connecting to database "QA_DB": Communications link failure Last packet sent to the server was 0 ms ago."

Jar file which is placed in jdbcdrivers "sqljdbc4.jar"

Can anyone helps me out to get it set up or to provide details why this error is coming .

Regards

Parth Magu

 

Tags: MashZone