Re: Oracle ODBC driver problems

I don't know if it's related, but I have had a few problems with Access 97/VBA and the Oracle ODBC driver. Basically, when you link to a table with the Oracle driver, access sometimes looks at fields that are number(5) and thinks they are integer fields. What that then does is make your Access crash when it happens upon a number larger than 32 thousand and something. Switching to the MS driver solved that issue, but there are minor problems with the MS driver too so I'm having to use both drivers, each for selected tables!

If anyone manages to find a reliable ODBC driver for Oracle 7.3 let me know.

--
Neil Robinson
VTR1000 Firestorm

<shielsy6791_at_my-dejanews.com> wrote in message news:7grfek$7bl$1_at_nnrp1.deja.com...
> Platform: WinNT sp 4
> Compiler: Visual 6
>
> Hello,
>
> Has anyone else had problems with the Oracle ODBC drivers. I have a
problem
> that when I do a simple SELECT * FROM SOME_TABLE and then Free the
Statement
> handle I get the error "Function sequence error". Strangely enough I do
not
> this error with the Microsoft Oracle driver. The only way to avoid this
error
> is to call COMMIT or ROLLBACK (SQLTransact) after doing a SELECT which is
> rediculous. I cannot use the Microsoft driver because it doesn't support
the
> SELECT FOR UPDATE query.
>
> At the moment, I am planning to upgrade my driver from 8.0.3.0 to 8.0.5.0
and
> after asking Oracle they said that to upgrade I will have to purchase a
> complete Oracle Client! Even worse they said that the driver may not even
fix
> my problems.
>
> Has anyone else has problems with the Oracle driver - similar to what I'm
> having. Also, I would appreciate it if someone could tell me whether the
new
> driver will actually fix my problems?
>
>
> Thanks,
> Andy Shiels
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Sat May 08 1999 - 06:29:02 CDT