Re: as400
From: Raoul Laoyan (RaoulLaoyan_at_hotmail.com)
Date: 06/02/04
- Next message: Raoul Laoyan: "Restoring individual DTS Packages"
- Previous message: Simon Lenn: "Re: DTS designer error and all tasks are missing"
- Next in thread: Sean Gahan: "Re: as400"
- Reply: Sean Gahan: "Re: as400"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 1 Jun 2004 17:22:15 -0700
If this is just a straight import, look to using FTP if
the daemon is running on the AS/400. You may need to get
a userid/password on the AS/400 for this task.
If it's bidirectional interchange your looking for, look
into loading the AS/400 client with the database
connectivity packages onto the SQL Server itself. Talk
to your AS/400 systems administrator for this client.
Loading up Host Integration Server would be such a waste
of time and resource just for one particular task.
Good luck,
>-----Original Message-----
>Partha,
>Thank you very much for your response; I am aware that
the Host Integration
>Server will interface with as400, but can you give me
some information on
>how to link the servers programmatically? Additionally,
can you tell me
>where to get the oledb provider for db2?
>
>Regards,
>
>Sean Gahan
>
>"Partha Mandayam" <mcp111@hotmail.com> wrote in message
>news:e%23l4YMSREHA.1620@TK2MSFTNGP12.phx.gbl...
>> You should create a linked server to as400 using
Microsoft oledb
>> provider for db2 and then access the data using
openquery
>>
>> Regards
>>
>> Partha Mandayam
>> Software Consultant
>> Home page: http://partha.tripod.com
>>
>>
>> *** Sent via Developersdex
http://www.developersdex.com ***
>> Don't just participate in USENET...get rewarded for it!
>
>
>.
>
- Next message: Raoul Laoyan: "Restoring individual DTS Packages"
- Previous message: Simon Lenn: "Re: DTS designer error and all tasks are missing"
- Next in thread: Sean Gahan: "Re: as400"
- Reply: Sean Gahan: "Re: as400"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
