Re: Accessing SQL Server Data

["Beppe Costa" <beppecosta@xxxxxxxxxxx>]

I don't think so.
Maybe you should use jdbc with a suitable driver (Ms, jtds, etc...)


----- Original Message ----- 
From: "Fisher, Don" <dfisher@xxxxxxxxxxxxx>
To: "'Midrange Systems Technical Discussion'" <midrange-l@xxxxxxxxxxxx>
Sent: Friday, November 11, 2005 4:44 PM
Subject: RE: Accessing SQL Server Data


> In theory, one should be able to use embedded SQL to retrieve this data.
> The CONNECT keyword can be used to access the SQL Server database.  I
> believe it has to be defined using the WRKRDBDIRE command.
>
> Hope that helps.
>
> Donald R. Fisher, III
> Project Manager
> Roomstore Furniture Company
> (804) 784-7600 extension 2124
> DFisher@xxxxxxxxxxxxx
>
> <clip>
> I want to write a program on our iSeries that requires data from both
native
> files and tables in a SQL Server database.  Anyone know how to read SQL
> Server tables from the iSeries?
> <clip>
> -- 
> 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.
>