Re: Oracle ODBC Drivers

From: Justin Cave <jocave_at_yahoo.com>
Date: 18 Oct 2002 17:48:32 -0700
Message-ID: <233b7a65.0210181648.47a9623f@posting.google.com>

> I understand that the new driver is the best way to go. However, I am
> thinking that this is not just an access97 Issue. We have a pearl
> script that is also creating problems for us. We are seeing corrupt
> indexes in the database. I have rebuilt the indexes and with in a day
> or two they are corrupt again. My theory is that the ODBC connection
> is the cause. I have seen the problem in the select SQL in access97
> and think that it is also happening in the Insert sql in the Pearl
> Script. Thanks for the information.... Anyone have any suggestions.

I cannot imagine anything that an ODBC driver could possibly do to cause corrupt indexes. This is almost certainly not related to anything related to any client processes. I'd start looking at the database-- are there processes that rebuild indexes that might be failing? I'd tend to suspect hardware, though. Perhaps the disk controller is flaky.

If you can install the database on another machine, that would be beneficial.

Justin Cave Received on Fri Oct 18 2002 - 19:48:32 CDT