Path: news.easynews.com!easynews!cyclone.swbell.net!cyclone-sf.pbi.net!64.245.249.51!sfo2-feed1.news.algx.net!dca6-feed2.news.algx.net!allegiance!newsfeed1.cidera.com!Cidera!news-x2.support.nl!news.csl-gmbh.net!newsfeed01.sul.t-online.de!newsfeed00.sul.t-online.de!newsmm00.sul.t-online.com!t-online.de!news.t-online.com!not-for-mail From: tojo Newsgroups: comp.databases.oracle.tools Subject: Re: ODBC Driver differences Date: Thu, 6 Jun 2002 10:32:36 +0200 Organization: T-Online Lines: 31 Message-ID: References: <0g63QcC1Zx$8EwF1@jimsmith.demon.co.uk> Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-Trace: news.t-online.com 1023352050 00 2226 mXd1byiS7Aakm 020606 08:27:30 X-Complaints-To: abuse@t-online.com X-Sender: 320012341988-0001@t-dialin.net X-Newsreader: MicroPlanet Gravity v2.50 Xref: easynews comp.databases.oracle.tools:51672 X-Received-Date: Thu, 06 Jun 2002 03:31:07 MST (news.easynews.com) In article <0g63QcC1Zx$8EwF1@jimsmith.demon.co.uk>, jim@jimsmith.demon.co.uk says... > I am looking for some detailed references on ODBC drivers for SQLServer > and Oracle. I am in the middle of porting a SQLserver application to > Oracle. Part of the application uses VBScript ASPs and I keep hitting > problems which seem to be connected with differences in the way > SQLServer and Oracle or their respective ODBC drivers return values in > various situations. > > Example (pseudo code) > > select max(Anumber) as MAXID rom EmptyTable; > if MAXID > 0 then > ... > end if > > This works with SQL server, but with Oracle MAXID is null (as I would > expect) so the IF fails. > > Any pointers would be appreciated. The vendor docs I can find don't seem > to go into this kind of detail. > Jim, this has nothing to do with ODBC drivers, but rather fundamental differences between Oracle and SQL Server. Those differences run much deeper than comparing NULLs. I'd suggest you read the Oracle Concepts manual, then maybe the Oracle SQL docs. -- Tom