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