Link

[jaimekash]

Can anyone tell me how to link an AS400 database into a SQL 2005 server using the iSeries Access ODBC Driver? It works perfectly to link into Access 2003, but I can't get it to link and I also can't get it to import data using the DTS package. Thank you.

 

[mrdenny]

You'll probably need to repost this in the AS/400 forum.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[jaimekash]

I will try that thank you.