on 10-29-2009 2:55 PM
Hi,
I have read the solution given from Gudmundur to Pedro Gallardo about connect SAP to mySQL external database.
It seems easy as long I can see, but I canu2019t make it work.
My system: SAP kernel 4.6D, with library dbmssslib.dll installed on my windows appserver
As Gudmundur say:
MSSQL_DSN should work. You should create your DSN using the ODBC Data Source Administrator (in Administrative Tools). Test it and make sure it works to the server and database you need.
Ok, all fine and ready. Created on our appserver using driver ODBC from
mysql-connector-odbc-5.1.5-win32.
Then create the DBCON (in transaction DBCO) with DBMS=MSS and your MySQL User/passwd.
The Conn. info (field CON_ENV) should only contain:
MSSQL_DSN=<your_dsn_name>
Ok. I have tried it using different notations, all of them failed:
dsnname
appserver\dsnname
appserver\dsname
ip_appserver\dsnname
That's all - IF you're using the ODBC DBSL interface on your application server.
Mmm, at this point, I hesitate a little. What do you mean exactly? I think my SAP
have installed DBSL but not ODBC. Is it possible?
If you're using the older OLEDB DBSL (7.00 on sql2005 or older), then you must in addition put MSSQL_DATASOURCE=<your_dsn_name> in the CON_ENV field.
Tested and failed too.
Perhaps itu2019s something missed on my appserver?
You probably need to install the ODBC drive for MySQL on your system first. The you can verify in the ODBC area whether you can reach the MySQL DB from this system.
J. Haynes
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanku2019s for yor answer Joe, but your indications were just done, and the problem persists.
My appserver (and also the client PC), have ODBC for MySql installed. Itu2019s a open software downloaded from http://dev.mysql.com.
Using Windows ODBC Data Source Administrator (in Administrative Tools), the connection was established and tested with no problems between SAP appserv and MySQL. I can reach DB in MySQL system.
I think the problem is that my SAP system never reaches the Windows ODBC connection. If I turn on traces on ODBC Data Source Adm., and test the connection using the same Windows ODBC, a log file is created containing successful connection strings. But if I test my ABAP program, or DBCO configuration, no traces were made.
Thanku2019s again for your interest.
User | Count |
---|---|
87 | |
10 | |
10 | |
10 | |
7 | |
6 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.