Re: AW: Experiences with Oracle and MS .Net data providers
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
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.
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
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
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
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
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
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).