How doI Link AS400 to SQL Server 2000 using Link Server

  • Thread starter Thread starter Vince Lassiter via AccessMonster.com
  • Start date Start date
V

Vince Lassiter via AccessMonster.com

You should ask your question in one of the SQL Server newsgroups. This
newsgroup is for MS Access.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm


Vince Lassiter via AccessMonster.com said:
I need to get data from the AS400 into SQL Server 2000 for reporting.
I would like to use Link Server, but I cant get it to work, I have tried
Click to expand...
using both OleDB and Odbc. I just dont know how to set it up
 
I need to get data from the AS400 into SQL Server 2000 for reporting.
I would like to use Link Server, but I cant get it to work, I have tried
using both OleDB and Odbc. I just dont know how to set it up
Click to expand...

1. This group is about Microsoft Access, and you won't find a whole lot of
AS400 people here. Try posting in microsoft.public.sqlserver.programming

2. You will need to talk to one of your IT people. You can link your AS400
as a linked server, but the AS400 must be configured for ODBC or OLE-DB, and
you have to have a ODBC Driver or OLE-DB Provider installed on the SQL
Server, and then you have to have authentication credentials that the SQL
Server can use to get into the AS400.

3. Any company that has an AS400 and a SQL Server should also be able to
afford Microsoft Host Integration Server http://www.microsoft.com/hiserver/
because that's what it's for.
--
Peace & happy computing,

Mike Labosh, MCSD

"It's 4:30 am. Do you know where your stack pointer is?"
 
Informatica or Pervasive (Data Junction) can solve this one for you.
Fast simple and easy. Informatica is the more expensive option (for
good reason), Pervasive less expensive (for good reason)

Jo K
 
Back
Top