Skip to Content
0
Former Member
Jun 11, 2011 at 08:27 AM

Connection to MySQL database, DBCO settings

1672 Views

Hi experts,

I need to connect to a MySQL database located on a different side.

I do have the IP and domain name (e.g. my.test.com), MySQL DB name (SAPtest), Username (SAPuser) and Password (*****).

I did following entries under DBCO:

Name: SQLtest

DBMS: MSS

User Name: SAPuser

DB-Password: *****

Env. Info: MSSQL_DNS=my.test.com

Connection Limit: -

Connection Optimum: -

I hope you see already, that I get the error message SQL Server does not exists or access denied.

I check already all kind of forum and posts, but couldn´t find a good and satisfying documentation for this case.

Yes, MSS is not MySQL, but different user say it is possible with this settings.

I am thankful for any help!