RE: Connecting to AS400 from MS SQL Enterprise Manager

At 04:10 PM 9/30/2005, you wrote:

What that means is

Systemname.serialnumber.libiary.file

So if you have a system that you can connect to by typing

Telnet Vernsiseries

And if has the serial number S10952MP

And your library is sysibm

And your file is sysdummy1

Then you would enter

Vernsiseries.s10952mp.sysibm.sysdummy1

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of
vhamberg@xxxxxxxxxxx
Sent: Friday, September 30, 2005 1:47 PM
To: Midrange Systems Technical Discussion
Subject: Re: Connecting to AS400 from MS SQL Enterprise Manager

Okay, I have a linked server now - can I execute SELECT statements in
Query Analyzer against this? What is the syntax - I admit freely to
being a raw newbie in SQL Server - almost. I've looked at the help and
see that a 4-part name is needed

provider.catalog.schema.object_name

What do I put in each place?

Thanks
Vern

-------------- Original message --------------

> Vern,
>
> Thanks. Yep, I am familiar with RJS's products. I had a chance to
> check out the booth at Common. Great stuff!
>
> If I was building an application that routinely accessed external data

> from the iSeries then I might purchase something like RPG2SQL, but
where
> SQL Enterprise Manager has an upper hand is that for quick, ad hoc
> stuff, it just has some nice tools right out of the box. That is where

> I get frustrated from time to time with the iSeries. As open as the
> iSeries is, we still lack built in tools that make doing some things
> easy (like accessing "external" data). I can do that with almost any
> other platform using ODBC, but with the iSeries, I have to roll my own

> using JDBC (for example) or purchase a tool like RPG2SQL.
>
> Not a big deal, really. I am pretty used to digging around for
> additional tools (some free, some not). But, someone coming from a
> MS-centric world might say: "What, I can't connected to an SQL
Database
> from the iSeries yet SQL can connect to an iSeries database? That
> doesn't sound very 'open' !"
>
> That would never cause me to move FROM an iSeries. I was just thinking

> about how nice it would be to have the same connectivity options as
SQL
> EM has on the iSeries "out of the box".
>
> RPG2SQL would be a good solution though.
>
> Pete
>
> Vernon Hamberg wrote:
>
> > Pete, et al.
> >
> > I too am glad for the info on EM - want to see that work on my PC at

> > work.
> >
> > But---
> >
> >
> > For easy connectivity from iSeries to other DB's you might consider
> > our RPG2SQL Integrator product for read/write capability. It looks
> > more like SQL CLI than embedded SQL in RPG but is very easy to use.
It
> > works with any DB for which an ODBC driver or OLEDB provider exists.
I
> > just recently had it working with XML files. Also have used it
against
> > PostgreSQL and MYSQL. It also contains functions that communicate
> > directly to Excel via OLE automation, not SQL. It's not DRDA but,
> > unlike DRDA, it is possible to maintain multiple open connections,
> > although not joining across them.
> >
> > Check out www.rjssoftware.com or call me at 952.898.3038
> >
> >
> > P.S. Blatant misspelling was on purpose - sic!
> >
> > At 05:34 PM 9/29/2005, you wrote:
> >
> >> Thanks Jim. Great info...
> >>
> >> Not sure what Mike was trying to do with the iSeries connection in
> >> SQL EM but looks like you covered all the bases.
> >>
> >> Wish it were as easy going the other way (iSeries connecting to to
> >> other DB's)...
> >>
> >> Pete
> >
> >
> --
> 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.
>
--
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.


--
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.