Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: ODBC Problems
In case anyone else has this problem, I found out that Access was choking on the content of a couple of columns. The were indicated as text fields in access and char fields in oracle. The data within apparently upset Access. I created a view of the table without those two columns in Oracle and linked to it instead.
kuper_at_oscsystems.com wrote:
: Thank you for the help!! However, I have increaded the ODBC refresh
: interval to 32766 and I'm still getting the error. I have also upped
: the Update retry interval with no success.
: Bewildered.
: -- Willie
: Peter Livingwater (PeterChong_at_nospam.att.net) wrote:
: : Basically the ODBC is not fast enough to refresh, Make some change on the
: : ODBC refresh rate
: : Like Options|Advanced|ODBC Refresh in Value(sec)
: : Cheers
: : Peter C.
: : <kuper_at_oscsystems.com> wrote in message
: : news:893mkg$7mp$1_at_spider.oscsystems.com...
: : >
: : > Hi,
: : >
: : > I am having a problem linking to Oracle tables via ODBC. When access
: : > opens the table, each field contains the string "#deleted". I get the
: : > errorwith either the Oracle or Microsoft ODBC drivers. Using SQL Plus,
: : > I can see the data without problem. Any help is greatly appreciated!
: : >
: : >
: : > -- Willie
: : >
Received on Thu Mar 02 2000 - 00:00:00 CST