cancel
Showing results for 
Search instead for 
Did you mean: 

Connect to external SQL Server from Application server running on OS400

manoj2910
Participant
0 Kudos
165

Hi,

I have a situation where I need to connect to an external SQL server form SAP Application Server running on OS 400. I will be giving connection details at DBCO. Can and one suggest me how to configure ODBC and where do I find .so files for the connection.

Thanks in Advance

Manoj

View Entire Topic
christoph_ostrop
Active Contributor
0 Kudos
manoj2910
Participant
0 Kudos

Hi Chisrtoph,

Thanks for the links, I shall go through and come up with a solution ASAP.

meanwhile I also found this link which gave me an insight regarding this and which might help others - https://www.scottklement.com/presentations/External%20Databases%20from%20RPG.pdf

Regards,

Manoj

manoj2910
Participant
0 Kudos

Hi Christoph,

I cannot use UD-Connect since we don't have J2EE Server. We only have ABAP server as of now.

volker_gldenpfennig
Active Participant
0 Kudos

Hi Manoj,

ok, but it is pretty simple:

If you want to connect to MS SQL Server from System i, you do need either a J2EE Engine via UD-connect or a windows appl server via DB-Connect - nothing else will work ...

A windows appl server can always be installed additionally and does not need much horse power.

Regards,

Volker Gueldenpfennig, consolut international ag