ODBC Driver differences

From: Jim Smith <jim_at_jimsmith.demon.co.uk>
Date: Thu, 6 Jun 2002 08:59:49 +0100
Message-ID: <0g63QcC1Zx$8EwF1_at_jimsmith.demon.co.uk>

[Quoted] [Quoted] 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 <http://www.jimsmith.demon.co.uk/spam>

Received on Thu Jun 06 2002 - 09:59:49 CEST