Re: ODBC Driver differences

In article <0g63QcC1Zx$8EwF1_at_jimsmith.demon.co.uk>, jim_at_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