RE: SQL SERVER/ISERIES INTEGRATION

Yep, basically like DDM.

DDM is the iSeries client side implementation of DRDA.  The iSeries can be
both a DRDA server and a DRDA client.  DRDA is an open standard for
accessing remote DBs.  OBDC is a result of the perversion of the DRDA
standard.

SQL server, among others can be DRDA clients but not DRDA servers.  So in
SQL server, a linked table is a DRDA connection from SQL server to the
iSeries.


HTH,

Charles Wilt
iSeries Systems Administrator / Developer
Mitsubishi Electric Automotive America
ph: 513-573-4343
fax: 513-398-1121
 

> -----Original Message-----
> From: Elvis Budimlic [mailto:ebudimlic@xxxxxxxxxxxxxxxxxxxxxxxxx]
> Sent: Tuesday, November 09, 2004 1:00 PM
> To: 'Midrange Systems Technical Discussion'
> Subject: RE: SQL SERVER/ISERIES INTEGRATION
> 
> 
> I haven't had a chance to actually use SQL Server, so I plead 
> full ignorance
> on "linked server" setup.  Is that like DDM?
> 
> -----Original Message-----
> Subject: RE: [SPAM] SQL SERVER/ISERIES INTEGRATION
> 
> Elvis,
> 
> The problem is the original poster is inserting from an SQL 
> server via a
> "linked server".
> 
> So she's not going to have the control over the connection 
> she would via
> ODBC/JDBC.
> 
> Charles Wilt
> 
> 
> --
> This is the Midrange Systems Technical Discussion 
> (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.
>