Re: AW: Experiences with Oracle and MS .Net data providers

2003-11-25 Thread Mogens N?rgaard
Several of the Miracle guys are getting ready to be certified in SQL 
Server. They have a ball with the 1000-page books, which talk about 
"alternative operating systems" - meaning Windows 95, Windows X, Windows 
y,  :;-)

Stefan Jahnke wrote:

Hi Mladen

Nice metaphor. Did you intentionally use zum Donnerwetter as a little word
play on MS's "Hailstorm" - project (R.I.P.) ?. That get's pretty close to
obscene language, too. I guess I was actually gullible enough to believe
that .NET might be comparable to the Java world. Maybe not ;). Or maybe I
have to keep playing with MONO.
Stefan

-Ursprungliche Nachricht-
Von: Mladen Gogala [mailto:[EMAIL PROTECTED]
Gesendet: Dienstag, 25. November 2003 15:39
An: Multiple recipients of list ORACLE-L
Betreff: Re: Experiences with Oracle and MS .Net data providers


On 11/25/2003 07:39:30 AM, Stefan Jahnke wrote:
 

Hi 

How is it, that data
providers  can be in incompatible in .NET ?
Stefan
   

Stefan, lets talk about obscene language. As you know, obscene
language is not always the same. The phrase "zum Donnerwetter" can
and will be understood as swearing, despite the fact that it's utterly
incomprehensible to me why would someone use bad weather as a swearing
phrase. 
Two obscene words in Redmond, WA are "compatible" and "standards", which
are used much in the same way as the phrase "zum Donnerwetter" is 
used in German language. You should know that .NET is incompatibility
elevated to the level of art. Did you really expect MS product to be
compatible withe anything else except with another MS product? MS products
are not compatible, they are .NET compatible or contemptible, for short.
Your question should be rephrased as: how can anybody realistically expect 
.NET provider to be compatible with a non-MS database like Oracle?

Mladen Gogala
Oracle DBA


Note:
This message is for the named person's use only.  It may contain
confidential, proprietary or legally privileged information.  No
confidentiality or privilege is waived or lost by any mistransmission.  If
you receive this message in error, please immediately delete it and all
copies of it from your system, destroy any hard copies of it and notify the
sender.  You must not, directly or indirectly, use, disclose, distribute,
print, or copy any part of this message if you are not the intended
recipient. Wang Trading LLC and any of its subsidiaries each reserve the
right to monitor all e-mail communications through its networks.
Any views expressed in this message are those of the individual sender,
except where the message states otherwise and the sender is authorized to
state them to be the views of any such entity.
 

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: =?KOI8-R?Q?Mogens_N=3Frgaard?=
 INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).


AW: Experiences with Oracle and MS .Net data providers

2003-11-25 Thread Stefan Jahnke
I have to remember that as a good example for my wife's German classes.

Stefan

-Ursprungliche Nachricht-
Von: Mladen Gogala [mailto:[EMAIL PROTECTED]
Gesendet: Dienstag, 25. November 2003 16:20
An: Multiple recipients of list ORACLE-L
Betreff: Re: Experiences with Oracle and MS .Net data providers


Actually, it was a deliberate word play, just to remind you
that not all MS projects are successful. They were talking about
porting .NOT to Unix, but gave up. It's a MS-only world.

On 11/25/2003 09:54:51 AM, Stefan Jahnke wrote:
> Hi Mladen
> 
> Nice metaphor. Did you intentionally use zum Donnerwetter as a little word
> play on MS's "Hailstorm" - project (R.I.P.) ?. That get's pretty close to
> obscene language, too. I guess I was actually gullible enough to believe
> that .NET might be comparable to the Java world. Maybe not ;). Or maybe I
> have to keep playing with MONO.
> 
> Stefan
> 
> 
> -Ursprungliche Nachricht-
> Von: Mladen Gogala [mailto:[EMAIL PROTECTED]
> Gesendet: Dienstag, 25. November 2003 15:39
> An: Multiple recipients of list ORACLE-L
> Betreff: Re: Experiences with Oracle and MS .Net data providers
> 
> 
> 
> On 11/25/2003 07:39:30 AM, Stefan Jahnke wrote:
> > Hi 
> > 
> >How is it, that data
> > providers  can be in incompatible in .NET ?
> > 
> > Stefan
> 
> Stefan, lets talk about obscene language. As you know, obscene
> language is not always the same. The phrase "zum Donnerwetter" can
> and will be understood as swearing, despite the fact that it's utterly
> incomprehensible to me why would someone use bad weather as a swearing
> phrase. 
> Two obscene words in Redmond, WA are "compatible" and "standards", which
> are used much in the same way as the phrase "zum Donnerwetter" is 
> used in German language. You should know that .NET is incompatibility
> elevated to the level of art. Did you really expect MS product to be
> compatible withe anything else except with another MS product? MS products
> are not compatible, they are .NET compatible or contemptible, for short.
> Your question should be rephrased as: how can anybody realistically expect

> .NET provider to be compatible with a non-MS database like Oracle?
> 
> Mladen Gogala
> Oracle DBA
> 
> 
> 
> Note:
> This message is for the named person's use only.  It may contain
> confidential, proprietary or legally privileged information.  No
> confidentiality or privilege is waived or lost by any mistransmission.  If
> you receive this message in error, please immediately delete it and all
> copies of it from your system, destroy any hard copies of it and notify
the
> sender.  You must not, directly or indirectly, use, disclose, distribute,
> print, or copy any part of this message if you are not the intended
> recipient. Wang Trading LLC and any of its subsidiaries each reserve the
> right to monitor all e-mail communications through its networks.
> Any views expressed in this message are those of the individual sender,
> except where the message states otherwise and the sender is authorized to
> state them to be the views of any such entity.
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Mladen Gogala
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 
> 
>  
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Stefan Jahnke
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 

Mladen Gogala
Oracle DBA



Note:
This message is for the named person's use only.  It may contain
confidential, proprietary or l

RE: [***SPAM***] - Experiences with Oracle and MS .Net data providers - Found word(s) to be removed remove based list e-mail in the Text body.

2003-11-25 Thread Tony Johnson
We are using the latest ODP.net provider and up until we upgraded to 92040 had few and 
minor problems with it. Mostly it was differences between all of the different drivers 
that our programmers were using based on either the cycles of the moon or which team 
won the World Series. Since we went to ODP.NET things are much smoother and I dont 
hear any complaining about things WAY out of my control.

When we upgraded to 92040 something changed where one column in one database is now 
appearing to have a different numeric format than prior to the upgrade. I think that 
there is this issue with this one column(which is set up in a way that I cant recreate 
) and we will fix it soon but overall it is working very well. 

-Original Message-
Sent: Monday, November 24, 2003 10:59 PM
To: Multiple recipients of list ORACLE-L


Hi all,

Would really like to hear any feedback regarding anyone comparing these two .Net data 
providers (or even some of the others out there - Datadirect, etc.).

We're at decision making time, and things like the differences in calling stored 
procs, returning Ref Cursors, are starting to mean we need to pick one.  My gut says 
go with the Oracle one (keep the technology stack based on the one vendor), but they 
kludge too many things.  (just like in ADO, where they ignored the standard for stored 
proc calling).

Anyway, any comments about your use, likes and dislikes of either would be much 
appreciated.

Ciao
Fuzzy
:-)

--
The contents of this post are my opinions only
  If swallowed seek medical advice 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Grant Allen
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Tony Johnson
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).


Re: Experiences with Oracle and MS .Net data providers

2003-11-25 Thread Mladen Gogala
Actually, it was a deliberate word play, just to remind you
that not all MS projects are successful. They were talking about
porting .NOT to Unix, but gave up. It's a MS-only world.

On 11/25/2003 09:54:51 AM, Stefan Jahnke wrote:
> Hi Mladen
> 
> Nice metaphor. Did you intentionally use zum Donnerwetter as a little word
> play on MS's "Hailstorm" - project (R.I.P.) ?. That get's pretty close to
> obscene language, too. I guess I was actually gullible enough to believe
> that .NET might be comparable to the Java world. Maybe not ;). Or maybe I
> have to keep playing with MONO.
> 
> Stefan
> 
> 
> -Ursprungliche Nachricht-
> Von: Mladen Gogala [mailto:[EMAIL PROTECTED]
> Gesendet: Dienstag, 25. November 2003 15:39
> An: Multiple recipients of list ORACLE-L
> Betreff: Re: Experiences with Oracle and MS .Net data providers
> 
> 
> 
> On 11/25/2003 07:39:30 AM, Stefan Jahnke wrote:
> > Hi 
> > 
> >How is it, that data
> > providers  can be in incompatible in .NET ?
> > 
> > Stefan
> 
> Stefan, lets talk about obscene language. As you know, obscene
> language is not always the same. The phrase "zum Donnerwetter" can
> and will be understood as swearing, despite the fact that it's utterly
> incomprehensible to me why would someone use bad weather as a swearing
> phrase. 
> Two obscene words in Redmond, WA are "compatible" and "standards", which
> are used much in the same way as the phrase "zum Donnerwetter" is 
> used in German language. You should know that .NET is incompatibility
> elevated to the level of art. Did you really expect MS product to be
> compatible withe anything else except with another MS product? MS products
> are not compatible, they are .NET compatible or contemptible, for short.
> Your question should be rephrased as: how can anybody realistically expect 
> .NET provider to be compatible with a non-MS database like Oracle?
> 
> Mladen Gogala
> Oracle DBA
> 
> 
> 
> Note:
> This message is for the named person's use only.  It may contain
> confidential, proprietary or legally privileged information.  No
> confidentiality or privilege is waived or lost by any mistransmission.  If
> you receive this message in error, please immediately delete it and all
> copies of it from your system, destroy any hard copies of it and notify the
> sender.  You must not, directly or indirectly, use, disclose, distribute,
> print, or copy any part of this message if you are not the intended
> recipient. Wang Trading LLC and any of its subsidiaries each reserve the
> right to monitor all e-mail communications through its networks.
> Any views expressed in this message are those of the individual sender,
> except where the message states otherwise and the sender is authorized to
> state them to be the views of any such entity.
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Mladen Gogala
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 
> 
>  
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Stefan Jahnke
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 

Mladen Gogala
Oracle DBA



Note:
This message is for the named person's use only.  It may contain confidential, 
proprietary or legally privileged information.  No confidentiality or privilege is 
waived or lost by any mistransmission.  If you receive this message in error, please 
immediately delete it and all copies of it from your system, destroy any hard copies 
of it and notify the sender.  You must not, directly or indirectly, use, 

AW: Experiences with Oracle and MS .Net data providers

2003-11-25 Thread Stefan Jahnke
Hi Mladen

Nice metaphor. Did you intentionally use zum Donnerwetter as a little word
play on MS's "Hailstorm" - project (R.I.P.) ?. That get's pretty close to
obscene language, too. I guess I was actually gullible enough to believe
that .NET might be comparable to the Java world. Maybe not ;). Or maybe I
have to keep playing with MONO.

Stefan


-Ursprungliche Nachricht-
Von: Mladen Gogala [mailto:[EMAIL PROTECTED]
Gesendet: Dienstag, 25. November 2003 15:39
An: Multiple recipients of list ORACLE-L
Betreff: Re: Experiences with Oracle and MS .Net data providers



On 11/25/2003 07:39:30 AM, Stefan Jahnke wrote:
> Hi 
> 
>How is it, that data
> providers  can be in incompatible in .NET ?
> 
> Stefan

Stefan, lets talk about obscene language. As you know, obscene
language is not always the same. The phrase "zum Donnerwetter" can
and will be understood as swearing, despite the fact that it's utterly
incomprehensible to me why would someone use bad weather as a swearing
phrase. 
Two obscene words in Redmond, WA are "compatible" and "standards", which
are used much in the same way as the phrase "zum Donnerwetter" is 
used in German language. You should know that .NET is incompatibility
elevated to the level of art. Did you really expect MS product to be
compatible withe anything else except with another MS product? MS products
are not compatible, they are .NET compatible or contemptible, for short.
Your question should be rephrased as: how can anybody realistically expect 
.NET provider to be compatible with a non-MS database like Oracle?

Mladen Gogala
Oracle DBA



Note:
This message is for the named person's use only.  It may contain
confidential, proprietary or legally privileged information.  No
confidentiality or privilege is waived or lost by any mistransmission.  If
you receive this message in error, please immediately delete it and all
copies of it from your system, destroy any hard copies of it and notify the
sender.  You must not, directly or indirectly, use, disclose, distribute,
print, or copy any part of this message if you are not the intended
recipient. Wang Trading LLC and any of its subsidiaries each reserve the
right to monitor all e-mail communications through its networks.
Any views expressed in this message are those of the individual sender,
except where the message states otherwise and the sender is authorized to
state them to be the views of any such entity.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Mladen Gogala
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).


 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Stefan Jahnke
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).


Re: Experiences with Oracle and MS .Net data providers

2003-11-25 Thread Mladen Gogala

On 11/25/2003 07:39:30 AM, Stefan Jahnke wrote:
> Hi 
> 
>How is it, that data
> providers  can be in incompatible in .NET ?
> 
> Stefan

Stefan, lets talk about obscene language. As you know, obscene
language is not always the same. The phrase "zum Donnerwetter" can
and will be understood as swearing, despite the fact that it's utterly
incomprehensible to me why would someone use bad weather as a swearing
phrase. 
Two obscene words in Redmond, WA are "compatible" and "standards", which
are used much in the same way as the phrase "zum Donnerwetter" is 
used in German language. You should know that .NET is incompatibility
elevated to the level of art. Did you really expect MS product to be
compatible withe anything else except with another MS product? MS products
are not compatible, they are .NET compatible or contemptible, for short.
Your question should be rephrased as: how can anybody realistically expect 
.NET provider to be compatible with a non-MS database like Oracle?

Mladen Gogala
Oracle DBA



Note:
This message is for the named person's use only.  It may contain confidential, 
proprietary or legally privileged information.  No confidentiality or privilege is 
waived or lost by any mistransmission.  If you receive this message in error, please 
immediately delete it and all copies of it from your system, destroy any hard copies 
of it and notify the sender.  You must not, directly or indirectly, use, disclose, 
distribute, print, or copy any part of this message if you are not the intended 
recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to 
monitor all e-mail communications through its networks.
Any views expressed in this message are those of the individual sender, except where 
the message states otherwise and the sender is authorized to state them to be the 
views of any such entity.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Mladen Gogala
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).


AW: Experiences with Oracle and MS .Net data providers

2003-11-25 Thread Stefan Jahnke
Hi 

Some coworkers implemented an application using C# and the MS .NET provider
for Oracle (9.0.1 DB).
One thing I can remember: Mapping C#'s float datatype to Oracle FLOAT (or
NUMBER(...)) somehow didn't work that great.
Another thing was that they could not use transaction processing via the
underlying COM+ components correctly. Something with the threading went
wrong. It did work though for SQL*Server, so they assumed the MS provider
for Oracle screwed up.
Switching to the Oracle provider wasn't an option anymore either, since the
interfaces weren't 100% compatible.

I don't know about that since I don't know .NET, but I was surprised that
that could be the case. I thought it would work like in Java, where the JDBC
driver supplier "just" implements a certain set of interfaces. If you don't
downcast an ResultSet into for example an OracleResultSet and stick to the
methods the standard inteface provides, ... no probs. How is it, that data
providers  can be in incompatible in .NET ?

Stefan

-Ursprungliche Nachricht-
Von: Grant Allen [mailto:[EMAIL PROTECTED]
Gesendet: Dienstag, 25. November 2003 06:59
An: Multiple recipients of list ORACLE-L
Betreff: Experiences with Oracle and MS .Net data providers


Hi all,

Would really like to hear any feedback regarding anyone comparing these two
.Net data providers (or even some of the others out there - Datadirect,
etc.).

We're at decision making time, and things like the differences in calling
stored procs, returning Ref Cursors, are starting to mean we need to pick
one.  My gut says go with the Oracle one (keep the technology stack based on
the one vendor), but they kludge too many things.  (just like in ADO, where
they ignored the standard for stored proc calling).

Anyway, any comments about your use, likes and dislikes of either would be
much appreciated.

Ciao
Fuzzy
:-)

--
The contents of this post are my opinions only
  If swallowed seek medical advice 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Grant Allen
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).


 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Stefan Jahnke
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).


Experiences with Oracle and MS .Net data providers

2003-11-24 Thread Grant Allen
Hi all,

Would really like to hear any feedback regarding anyone comparing these two .Net data 
providers (or even some of the others out there - Datadirect, etc.).

We're at decision making time, and things like the differences in calling stored 
procs, returning Ref Cursors, are starting to mean we need to pick one.  My gut says 
go with the Oracle one (keep the technology stack based on the one vendor), but they 
kludge too many things.  (just like in ADO, where they ignored the standard for stored 
proc calling).

Anyway, any comments about your use, likes and dislikes of either would be much 
appreciated.

Ciao
Fuzzy
:-)

--
The contents of this post are my opinions only
  If swallowed seek medical advice 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Grant Allen
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).