Re: Accessing other files was Re: news400 goes negative on IBM?

["Carel Teijgeler" <coteijgeler@xxxxxxxxx>]

Then I would like to add this question:

1) With ODBC I can create a Data Source (DS) that connects to my AS/400. The 
ODBC DS is the client, the AS/400 is the server.

2) On the AS/400 I can add a remote DB entry (WRKRDBDIRE) to our local database 
on  a PC network (OS: Novell) , give its IP address, using the default DRDA 
programme (listening to port 446). The AS/400  is the client, the PC-network is 
the server.

A connection with ODBC works,. the conection from the AS/400 not. 

So, what piece of software/services on the AS/400 are running to process the 
ODBC request? Or rather: why is link 1 possible?

The next question would be, of course, can this process not be reversed?

Just very curious.

Regards,
Carel Teijgeler.

*********** REPLY SEPARATOR  ***********

On 20-5-05 at 17:04 rob@xxxxxxxxx wrote:

>I don't necessarily need RPG native access to other databases.  Imbedded 
>SQL will get the job done.  But you cannot CONNECT TO a SQL server 
>database, as suggested.  Unless you purchase some other tool.  Now IBM has 
>a product that will allow you to do this.  Several third parties have 
>products that connect to sql server and others.  But instead of just 
>making a simple CONNECT TO work they have you call a bunch of apis to get 
>data off of the other systems.  Probably why IBM charges about 3 times what 
>the other people charge.