asked on

ODBC Connection from IBM System i to Microsoft SQL 2008 R2

We need to make an ODBC connection from an IBM System i to a remote Microsoft SQL 2008 R2 database. I am having problems finding any documentation on connection setup for this on the i Series side.

lcohan

Please check out the following lkinks:

http://www-01.ibm.com/support/docview.wss?uid=nas1d7cd7e4509cc894c86257280005c65dc
http://social.msdn.microsoft.com/Forums/en-US/sqldatabaseengine/thread/9c9fcd68-0457-481f-9c06-57555a2b7fb0/

WH_Tech

ASKER

Those seem to the the only kind of articles I can find. I need to make the connection from the i Series side though to perform and insert/update and most of the articles talk about connecting from the MSSQL side.

lcohan

Ok...you could use a IBM ODBC driver (like below) to create a DSN data source to your SQL and run it from there if that's what you want:

http://www-01.ibm.com/support/docview.wss?uid=swg21265617

lcohan

And more details at:

http://publib.boulder.ibm.com/infocenter/iseries/v7r1m0/index.jsp?topic=%2Frzaii%2Frzaiiodbc17.htm
http://www.easysoft.com/applications/ibm-universe-unidata/odbc.html

ASKER CERTIFIED SOLUTION

mustaccio

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

Member_2_276102

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial