Re: Oracle versus MS Sql Server

That's probably your problem. If you don't know what host variables are then you aren't using them. You need to enlighten yourself and read the Oracle application developer's guide. If you purchased Oracle in your native language then that documentation should be in your language. (Thus making reading the documentation easier.) If you want to use an OLE type interface then look at Oracle's OLE objects. It allows you to use host variables and even gives you some pointers at how to increase the performance and scalability of the application. The OLE/DB interface you are currently using is a Microsoft specification and is slanted towards MS SQLServer and thus does not include the Oracle optimizations. Since MS SQLServer and Oracle are worlds different as databases this causes problems and leads to people trying to treat a database as a database. When they are very different.

My advise would be to take a more team approach to product development, read the vendor's documentation, work with skilled professionals in other areas (DBA's, Data Modelers, etc.) and treat them as professionals. In return they will respect you, your product will be of professional quality, your customers will love you , you will learn a lot and get a great sense of accomplishment.
Jim

"Michael G. Schneider" <mgs_at_mgs-software.de> wrote in message news:9reug4$3vt$05$1_at_news.t-online.com...
> "Jim Kennedy" <kennedy-family_at_home.com> schrieb im Newsbeitrag
> news:xYBC7.1580$ib.998751_at_news1.sttln1.wa.home.com...
>
> > Databases differ from vendor to vendor. No they really do, they are not
> > commodities. How they handle concurrency (some handle it well some
> poorly)
> > , cursors (client side vs server side), and many many more. These are
> > application architecture issues. I agree with Galen, you are designing
an
> > application to use the lowest common denominator and ignoring the
dollars
> > the customer spent on their database.
>
> Interesting point. I do understand that.
>
> It is about the same as a software, which is written for many plattforms
at
> the same time, without using the specific operating system's potentials -
as
> for example ... Oracle Enterprise Manager?
>
>
> > My guess is you avoid using host variables. (which is going to
> > make scalability go down the tubes and no DBA can fix.)
>
> I do not quite understand, what made you guess this. Maybe it's my
> not-so-perfect English. Sorry.
>
> My programms are only targeted at the MS Windows plattform. So my way of
> talking to the database is through OLE/DB. I do not know a reason, why
this
> might hinder me in accessing the database in a performing way. I do not
know
> much about Oracle database administration, but you can be sure that I do
> know OLE/DB's capabilities and that I use all of them in the correct way.
>
> Michael G. Schneider
>
>
Received on Sat Oct 27 2001 - 14:08:51 CDT