Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Access AS400 via linked server

Author  Topic 

beyonder422
Posting Yak Master

124 Posts

Posted - 2008-01-17 : 16:34:31
Is it possible to access an AS400 via a linked server?

Scenario:
We currently use a third party (HitOLEDB) driver to connect to an AS400, but we are getting ready to upgrade and I want to try to eliminate the need, or identify alternatives, for this third party package.

Does anyone have any experience in this situation? Is there a MS version of this type of driver I can download as a patch or plug-in?

I have just initiated my investigation and simply don't see a driver listed in MS SQL Server 2000, when I go to select the driver.

Any help appreciated,

B

www.beyonder422.com

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-01-20 : 00:10:31
Install client access express on sql server then create linked server to as400.
Go to Top of Page
   

- Advertisement -