Re: DB2/400 comparisons with other relational databases (specifically Oracle and SQL Server)

Dave,

You are right.  Project Lightning is the as400 solution for what I was
asking about. It is officially called "Client Access OLE DB support"
http://www-1.ibm.com/servers/eserver/iseries/clientaccess/oledb/

Thanks for the info,

Steve Richter


----- Original Message -----
From: "Server Dave" <d2ba@xtra.co.nz>
To: <midrange-l@midrange.com>
Sent: Monday, October 01, 2001 3:05 PM
Subject: Re: DB2/400 comparisons with other relational databases
(specifically Oracle and SQL Server)


> Steve,
> Q1:Ans-Well yes and know-depends on how you separate the client code.I
like
> to try and keep the client "generic" so I switch between MS Access and SQL
> Server,Oracle.
>
> Q2:Can the Oracle or whatever server be replaced by an ISeries running
> > DB2/400?
> Not sure as Im really confused with the OLE DB Providers.
> IBM had a old Project Lightling Kit I think used ADO 2.0 -recently
ungraded
> to 2.5
> but I dont think you can get it as a download without purchasing CA
Express.
> Microsoft is worse-You have to get Host Explorer or SNA Server 4.0 SP2 to
> get
> the provider.
>
> Q3.> DTS?   DMO?  What pc components would be used to make your own
> Enterprise
> > Manager?You can install the client componants in SQL Server 7 or
> 2000--Developer Edition or MSDE CD that ships with VS 6.
> Use the Package and Deployment tool for the client
>
> Microsoft used the SQL DMO object model to make Enterprise Manager--there
is
> an Object libary that is very rich-you can even call wizards.
> I use the DTS object libary in a VB app I working on a the moment--I use
the
> Code generator in DTS 2000 and tweak that--In your VBP references are made
> to the DTS
> Object libary--Its as easy as that.
>
> cheers Dave
>
>
> ----- Original Message -----
> From: "Steve Richter" <srichter@AutoCoder.com>
> To: <midrange-l@midrange.com>
> Sent: Tuesday, October 02, 2001 12:58 AM
> Subject: Re: DB2/400 comparisons with other relational databases
> (specifically Oracle and SQL Server)
>
>
> > Dave,
> >
> > Thanks for the code offer. I am just looking for information.
> >
> > The question to you and others is:
> > 1. Can a VB appl, running on a client pc, that uses one of the NT based
> > servers like sql server or oracle, be switch easily from one server to
> > another. Can the Oracle server be unplugged and replaced with an
SQLServer
> > server or Informix?
> >
> > 2. Can the Oracle or whatever server be replaced by an ISeries running
> > DB2/400?
> >
> > You mention the Rumba api's. Does it provide the components needed so a
> COM
> > compliant application can be served by DB2/400?
> >
> > No lengthy explanation is needed. I am trying to understand what it
takes
> to
> > switch from one database server to another and if DB2/400 can
> realistically
> > compete in the database server market.
> >
> > You said:
> > > One advantage of SQL
> > > Server that I like is that all the Enterprise Managements objects can
be
> > > used in any
> > > COM compliant application--In theory you could make your own
Enterprise
> > > Manager using the DTS,DMO object libary that will work with DB2/400
> >
> > DTS?   DMO?  What pc components would be used to make your own
Enterprise
> > Manager?
> >
> > Thanks,
> >
> > Steve Richter
> >
> > _______________________________________________
> > This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
> list
> > To post a message email: MIDRANGE-L@midrange.com
> > To subscribe, unsubscribe, or change list options,
> > visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l
> > or email: MIDRANGE-L-request@midrange.com
> > 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@midrange.com
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l
> or email: MIDRANGE-L-request@midrange.com
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.
>
>