Re: ODBC Driver differences

[Quoted] "Jim Smith" <jim_at_jimsmith.demon.co.uk> wrote in message news:0g63QcC1Zx$8EwF1_at_jimsmith.demon.co.uk...
> 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

Is this pseudo asp or pseudo sql. if the former try if cint(maxid) > 0 .......

If the latter then you need to look into the databases null handling.

of course you should proabbly code stored procedures which accept the same paramaters in T-SQL and PL/SQL and call these from asp.

--
Niall Litchfield
Oracle DBA
Audit Commission UK