Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: ODBC Driver differences

Re: ODBC Driver differences

From: Jim Smith <jim_at_jimsmith.demon.co.uk>
Date: Mon, 10 Jun 2002 07:35:56 +0100
Message-ID: <iFaiZsAMjEB9EwgH@jimsmith.demon.co.uk>


In message <3d0379c6$0$8506$cc9e4d1f_at_news.dial.pipex.com>, Niall Litchfield <niall.litchfield_at_dial.pipex.com> writes
>"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
>.......
>

The null thing wasn't the best example to choose there were more problems in other areas.
I've pinned these down a bit further. All the oracle numbers come back as type vbDecimal (vartype 14) and VBScript can't seem to cope with that, _even if both numbers in a comparison are vbDecimal!_ It seems its not an ODBC thing but a problem with VBScript. I am resigned to putting cint and clng all over the several hundred asp files.

This application is half Java and half ASP. The Java part, once I'd converted a few SQL strings, worked a treat. I think I'd be quicker converting the ASP to Java than making the ASP work. I've got to do PostGres next.

-- 
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 Mon Jun 10 2002 - 01:35:56 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US