Legacy_XI_MySQL

[Former Member]

Hi friends

Iam trying to access MySQL server from XI

I have done all the configuration.

My JDBC Driver in ID of XI is

<b>com.mysql.jdbc.Driver</b>

and my Connection is

<b>jdbc:mysql://172.25.5.127:3306/MSSQL</b>

where 172.25.5.127 is my system ip and MSSQL is the database name.

But it is giving me an error

<b>Receiver Adapter v1109 for Party '', Service 'TBIT40_SQLSERVER_BS':

Configured at 11:04:13 2005-10-10

Processing Error: Accessing database connection 'jdbc:mysql://172.25.5.127:3306/MSSQL' failed: java.sql.SQLException: null, message from server: "Host 'sapbl2.lntinfotech.com' is not allowed to connect to this MySQL server"

Addtional information: JDBC driver 'com.mysql.jdbc.Driver' loaded successfully, additional driver information:

Available JDBC drivers:

oracle.jdbc.driver.OracleDriver, 1.0 JDBC compliant

sun.jdbc.odbc.JdbcOdbcDriver, 2.1 JDBC compliant

com.mysql.jdbc.Driver, 3.1 NOT JDBC compliant</b>

where sapbl2.lntinfotech.com is my XI server.

What is the solution?

Thanks in Advance

[Former Member]

Hi,

Can you send me the receiver JDBC database connection parameters for connecting to mySQL.

JDBC Driver:

Connection:

Best Regards

Suresh Kasu