Connect from SQLserver2000 to Other DataBase server

• fad_fbi

  Newbie

  Points: 1

  More actions

  July 31, 2009 at 8:08 am

  #140348

  Hi guys,

  Please I need help in this issue.

  is that possible to connect from SQLserver 2000 to other DataBase server as AS400?? in other way is that possible to run Sql statment thru SQL server 2000 and get records from other DataBase?

  thanks in advance

  Fad

• spaghettidba

  SSC Guru

  Points: 105732

  More actions

  July 31, 2009 at 10:01 am

  #1033046

  You can set up a Linked Server if you have the right OLEDB Provider.

  I use HitOLEDB400 from Hit Software, but you can use any one you like.

  I suggest you look for Linked Server in Books Online.

  Regards

  Gianluca

  -- Gianluca Sartori