How doI Link AS400 to SQL Server 2000 using Link Server

[Vince Lassiter via AccessMonster.com]

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

*****************************************
* This message was posted via http://www.accessmonster.com
*
* Report spam or abuse by clicking the following URL:
* http://www.accessmonster.com/Uwe/Abuse.aspx?aid=b307b82b89594b809d59bbe8f7d4ed5a
*****************************************

 

[Lynn Trapp]

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

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

 

[Mike Labosh]

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

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?"

 

[Jo K. Nash]

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