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

Steve,
I use ADO and have made a Generic class--email me privately if you want to
try it out-
and I will zip if up and send it to you.You can use it Excel,VB etc
Will work with Oracle or MS SQL Server.For Oracle the catch is you have to
install
the Oracle Client --you wont be able to connect with out it even though the
class uses
Microsoft's OLE DB provider for Oracle.
One catch is that you will have to install MDAC2.5 --(MSDataAccess Compents)
unless you are running Win 2K.If you need MDAC I will give you the link for
a download.
For AS/400 I use Rumba APIs-although having said that I will be testing
Microsofts
OLE DB Provider that comes with Host Explorer of SNA Server 4 SP2
If you want some DTS code-I can show you how to use that--On e 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
cheers Dave



----- Original Message -----
From: "Steve Richter" <srichter@AutoCoder.com>
To: <midrange-l@midrange.com>
Sent: Monday, October 01, 2001 12:30 AM
Subject: Re: DB2/400 comparisons with other relational databases
(specifically Oracle and SQL Server)


> Server,
>
> Thanks for posting the contrary point of view.
>
> Based on my spotty knowledge of sql server and oracle, the comparison of
> db2/400 and sql server is a comparison of two different products.  Db2/400
> is designed and works best when used as a tightly integrated database
engine
> "serving" applications running on the same system as db2/400. oracle and
sql
> server are designed to serve applications running on remote systems and be
> interchangable with other database servers.
>
> Using db2/400 to access a local database file using the database api or
sql
> calls works very well, accessing a db2/400 file via an ODBC call works,
but
> is a historical slow performer.
>
> Does this square with what you know of sql server?  Can you give examples
of
> typical database io in a visual basic pgm or an excel spreadsheet
accessing
> a remote server's database?   Is ODBC used, what other database
connectivity
> options are there, how is the performance (nbr of database gets per
> minute ), local lan and remote.
>
>
> Thanks,
>
> Steve Richter
>
>
> ----- Original Message -----
> From: "Server Dave" <d2ba@xtra.co.nz>
> To: <midrange-l@midrange.com>
> Sent: Sunday, September 30, 2001 7:32 AM
> Subject: Re: DB2/400 comparisons with other relational databases
> (specifically Oracle and SQL Server)
>
>
> > Doug,Joe
> > I personally found Oracle 8 a pain to use--it has a rather primative
> SQL*Net
> > GUI-its
> > soft of like a old greyscale terminal emulator.SQL Server 7/2000 has the
> > Enterprise
> > Manager which is much more to my liking .A lot of Oracle developers use
> Toad
> > a third party product to work around Oracles lack of bells and whistles.
> > Another big advantage I found is DTS (Data transformation
services)-Oracle
> > has got
> > nothing like DTS.It lets you for example inport a text file-do some
> serious
> > manipulation
> > of it and then you can export it to the db of your choice ie
> > Oracle,DB2--pretty cool
> > huh-I hav eeven seen some DTS related posts on the midrange list.
> >
> > > Its aboubt as good as DB2/400 but is far cheaper and scales nicely at
a
> > fraction of
> > > the cost."
> > DB2/400 is built into the OS;SQL Server only runs on NT/2000
> Server -theres
> > got to
> > be advantages to build the database around the OS.
> > You said SQL Server 2000 Enterprise costs 20k --One proccessor Unlimited
> > Clients
> > costs 18k.
> > However you can do it cheaper--
> > and you can pick it  up from from  Discount Business Software for approx
> > 3.5k
> > http://www.ebaystores.com/id=4347834
> > Of course you have to add the cost of 2000 Server(Windows 2000 Advanced
> > Server 25 Clients ---$1395 )  and the hardware say 2k per Server.
> > We are looking just shy of 7K all up per box--What does 7K buy you in a
> used
> > or new i series.
> > Ebay Stores is also really good to get Intel based Servers-new boxed
with
> > warantry-there is usually a good supply of IBM Servers.
> >
> > My guess is the latest AS/400 boxs that can compete would cost a fortune
> in
> > comparison.Also as I said before SQL Server/VB Developers are cheaper
than
> > Java Developers so you get a saving in development costs.
> >
> > My own feeling here is that the small client would prefer cheaper
options
> > like I
> > have described here.
> >
> >
> > Dave
> >
> >
> > > "As a general rule from now on I would only recomend SQL2000
Enterprise
> > > for any new applications-It beats Oracle hands down,has all the bells
> and
> > > whistles management tools/dev enviroment  that Oracle has not got yet.
> Its
> > > aboubt as good as DB2/400 but is far cheaper and scales nicely at a
> > fraction of
> > > the cost."
> > >
> > > Excuse me if I fail to see the credibility in your position, based on
> your
> > posts
> > > thus far.  Please try again with verifiable substantiation to your
> claims.
> > >
> > > Doug
> > >
> > > _______________________________________________
> > > 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.
> >
> >
>
> _______________________________________________
> 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.
>