May 8, 2013 at 7:01 am
Hi all,
We have a DB400 (DB2 based AS400 platform) database and I'd like to pull data from it using SQL Server, I'm sure can I can do this using OPENROWSET but could anyone advise how please i.e. do I need specific drivers etc?
KR, M
email: info@weekendwebdesign.co.uk
Personal Website: http://markallen.co.uk/
Business Website: https://www.weekendwebdesign.co.uk
May 9, 2013 at 5:39 am
What we did in a similar situation is to create a linked server to the As400 db. To do this you need to install the ibm client on your sql server and then create an odbc connection to the as400 db. Then create a linked server using the odbc and from there you can query the as400 directly within sql.
May 9, 2013 at 6:12 am
paul.whiteside (5/9/2013)
What we did in a similar situation is to create a linked server to the As400 db. To do this you need to install the ibm client on your sql server and then create an odbc connection to the as400 db. Then create a linked server using the odbc and from there you can query the as400 directly within sql.
Thanks Paul, that's pretty much how I was thinking of going about it, just needed a bit of reassurance as this would be the first time we've actually had a practical use for linking servers in the business.
Thanks again.
M
email: info@weekendwebdesign.co.uk
Personal Website: http://markallen.co.uk/
Business Website: https://www.weekendwebdesign.co.uk
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply