Oracle - Bug Oracle Patch 13

Bug Oracle Patch 13

From:

Date:

Time:

I have an application called BIS a client server app
that accesses a Oracle8 backend database
using Microsoft ODBC driver for oracle
and they get the below error and BIS doesn't startup any more
on Win2k and/or NT4 pcs

Error in Microsoft OLE DB Provider for ODBC drivers
Routine: Subroutines - checkifTableExists

This started AFTER we installed Oracle Patch13
on all the pcs to support Oracle Developer Forms6 2000Plus application

Is this just tnsnames.ora file that has been stuffed up on the pc ?
and/or is it a combination with ODBC Registry keys mucked up as well?

Any help appreciated, newbie question

KInd Rregards
Dave

David Kimpton...
Infrastructure Coordinator, Information Technology
City of Casey
e-mail - dkimpton@casey.vic.gov.au
phone - 03 9705 5488
fax - 03 9704 9544
mobile - 0438 591 539

> -----Original Message-----
> From: Oracle List [SMTP:oracle-list@digitalpoint.com]
> Sent: Wednesday, 22 October 2003 4:59 PM
> To: Oracle List
> Subject: Oracle Digest #14 - 10/21/03
>
> Oracle Digest #14 - Tuesday, October 21, 2003
>
> Server-side sql using between/and
> by "Pellegrini, Anthony" <Apellegrini@griffinwheel.com>
> Re: [Oracle] Server-side sql using between/and
> by "Robin Quasebarth" <robinq@digitalpoint.com>
>
>
> ----------------------------------------------------------------------
>
> Subject: Server-side sql using between/and
> From: "Pellegrini, Anthony" <Apellegrini@griffinwheel.com>
> Date: Tue, 21 Oct 2003 09:23:11 -0500
>
> How can I specify, in sql, that I'd like the server to process and send a
> client only the records that fall BETWEEN a start date AND an end date
> that
> the user specifies at run-time?
>
> ----------------------------------------------------------------------
>
> Subject: Re: [Oracle] Server-side sql using between/and
> From: "Robin Quasebarth" <robinq@digitalpoint.com>
> Date: Tue, 21 Oct 2003 08:09:05 -0700
>
> If the date is actually stored in a DATE format (not char) you can use
> the BETWEEN ( between '01-JAN-03' AND '31-OCT-03' )function but that
> will include both the high and low dates specified. Remember to TRUNC
> the dates if needed since a date field in Oracle stores time as well.
> TRUNC puts the date at Midnight of the date. You can use ( trunc
> (date_field)+1 >= to_date('01-JAN-03') AND trunc(date_field) < to_date
> ('31-OCT-O3') ) If you do not want to include the specified dates.
>
> Robin
>
> > How can I specify, in sql, that I'd like the server to process and
> send a
> > client only the records that fall BETWEEN a start date AND an end
> date that
> > the user specifies at run-time?
> >
> > ----------------------------------------------------------
> > To subscribe, unsubscribe or to search list archive
> > please visit http://www.digitalpoint.com/lists/oracle.html
> > ----------------------------------------------------------
> >
> >
>
>
>
> ----------------------------------------------------------------------
> End of Oracle Digest
>
> ----------------------------------------------------------
> To subscribe, unsubscribe or to search list archive
> please visit http://www.digitalpoint.com/lists/oracle.html
> ----------------------------------------------------------

######################################################################
Important Notice: This transmission may contain information which
is confidential and privileged and intended only for the addressee.
If you are not the addressee you may not use, disseminate or copy
this information. If you have received this information in error
please notify us immediately. Thank you

-------------------------------------------------------------------
NOTE: Do you need to forward a copy of this email message to the
records department for filing?
-------------------------------------------------------------------
######################################################################

----------------------------------------------------------
To subscribe, unsubscribe or to search list archive
please visit http://www.digitalpoint.com/lists/oracle.html
----------------------------------------------------------

Sales:
888/4-DPOINT

Support:
858/452-3696