Oracle - Bug Oracle Patch 13

Re: Bug Oracle Patch 13

From:

Date:

Time:

1. define your tnsnames.ora first, manually or use netword asssistant;
2. define your Oracle ODBC test and define a machine data Source, please
keep the consistence with waht define in the tnsname.ora.

Just try it

----- Original Message -----
From: "David Kimpton" <dkimpton@casey.vic.gov.au>
To: "'Oracle List'" <oracle-list@digitalpoint.com>
Sent: Wednesday, October 22, 2003 6:20 PM
Subject: [Oracle] Bug Oracle Patch 13

> 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
> ----------------------------------------------------------
>

----------------------------------------------------------
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