Path: news.easynews.com!easynews!cyclone.swbell.net!cyclone-sf.pbi.net!216.218.192.242!news.he.net!news-hog.berkeley.edu!ucberkeley!news.cis.ohio-state.edu!news.maxwell.syr.edu!newsfeed.icl.net!kibo.news.demon.net!news.demon.co.uk!demon!jimsmith.demon.co.uk!jim From: Jim Smith Newsgroups: comp.databases.oracle.tools,comp.database.oracle.misc Subject: ODBC Driver differences Date: Thu, 6 Jun 2002 08:59:49 +0100 Organization: At Home Message-ID: <0g63QcC1Zx$8EwF1@jimsmith.demon.co.uk> NNTP-Posting-Host: jimsmith.demon.co.uk X-NNTP-Posting-Host: jimsmith.demon.co.uk:158.152.103.218 X-Trace: news.demon.co.uk 1023350672 nnrp-01:25681 NO-IDENT jimsmith.demon.co.uk:158.152.103.218 X-Complaints-To: abuse@demon.net MIME-Version: 1.0 Content-Type: text/plain;charset=us-ascii;format=flowed User-Agent: Turnpike/6.01-U () Lines: 24 Xref: easynews comp.databases.oracle.tools:51671 X-Received-Date: Thu, 06 Jun 2002 03:08:45 MST (news.easynews.com) 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 Smith Because of their persistent net abuse, I ignore mail from these domains (among others) .yahoo.com .hotmail.com .kr .cn .tw For an explanation see