Re: vb oracle8i ADO problems
From: Jim Kennedy <kennedy-family_at_attbi.com>
Date: Tue, 10 Dec 2002 07:01:42 GMT
Message-ID: <7jgJ9.98493$pN3.7382_at_sccrnsc03>
Date: Tue, 10 Dec 2002 07:01:42 GMT
Message-ID: <7jgJ9.98493$pN3.7382_at_sccrnsc03>
My crystal ball says the sql is wrong. But since you left that and the
version out it's kind of hard to know.
Jim
"user" <utagi_at_yahoo.com> wrote in message
news:3df58ba3$1_1_at_news.tm.net.my...
> it keeps on saying:
>
> "Run-time error '-2147217900 (80040e14)':
> [Microsoft][ODBC driver for Oracle][Oracle]ORA-00936: missing expression"
>
> on the line
>
> Set mrsDish = New ADODB.Recordset
> mrsDish.Open msSelect, mADOConnection, adOpenDynamic, adLockOptimistic
>
> i've already got the "MS ODBC for Oracle" and "Oracle ODBC drivers"
> installed in the sys DSN
>
> what could be wrong ?
>
>
Received on Tue Dec 10 2002 - 08:01:42 CET