Re: Insert Oracle Linked Server timestamp error...

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Bob (bustravelerkc_at_NOSPAMyahoo.com)
Date: 06/03/04 

Date: Thu, 03 Jun 2004 10:12:59 GMT

Sue,

The query can be made to work for openquery with a to_char() statement,
unfortunately this does not work for Inserts.

I finally did receive a response from Microsoft support, the timestamp data
type is not supported, there is no plan to support it. They suggested using
the .net managed providers for Oracle, which of course can not be used for
linked servers.

They referenced several kb articles about data types supported and not
supported in Oracle, but basically the timestamp, clobs and blobs were out
( i expected the blobs but was surprised by the timestamp).

Anyway at least I know Microsofts position on it's ole db provider, they
support it, but have no plans to enhance it, watch thos data types
introduced from Oracle 8 on...

Bob

"Sue Hoegemeier" <Sue_H@nomail.please> wrote in message
news:04snb01147cfcpn394k2ufrrv9jsr953u9@4ax.com...
> Try using Openquery and wrapping the value in to_timestamp.
> You should also check your nls timestamp format on the
> Oracle server.
>
> -Sue
>
> On 28 May 2004 12:34:05 -0700, bob@lifeasbob.com (Bob
> Horkay) wrote:
>
> >Additional information.
> >
> >This is Oracle 9.203.
> >
> >Oracle introduced a new data type timestamp, this data type does not
> >seem to be updateable or insert via SQL Server linked server.
> >
> >I'd appreciate if anyone else could test and confirm this. We've
> >contacted MS Support and they weren't very helpful, indicating we were
> >the only ones who have reported a problem, and that is is most likely
> >an Oracle problem.
> >
> >I'm just looking for some guidance so we can establish a standard to
> >not use the Oracle time stamp data type on tables that require data to
> >be transferred back and forth between SQL Server and Oracle.
> >
> >Thanks
> >bob
>

Relevant Pages

  • SUMMARY: Hardening Solaris 8 with Oracle
    ... Oracle *not* offering a CLI install is a new trend. ... My reason for asking about Oracle Reports Server was a recent issue I ... # To Support X-Application need the LibC library ...
    (SunManagers)
  • RE: Server Explorer & Databases
    ... As for the visual studio's database server explorer, ... oracle, visual studio generally use the OLD DB provider which is for Oracle ... and support of most general funcctionalitis in latest version of Oracle. ... #Server Explorer for Oracle Databases ...
    (microsoft.public.vsnet.ide)
  • Re: Reports Background engine failures
    ... support for forms after 6i. ... We are a terminal server shop not Oracle application server with ... Oracle has many other development tools. ... or our customers. ...
    (comp.databases.oracle.tools)
  • RE: Oracle newbie questions
    ... Oracle uses SQL Plue to connect to server and run queries. ... As far as I know, the driver cannot enumerate servers as SQL Server does. ... Microsoft Online Community Support ... where an initial response from the community or a Microsoft Support ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Advice on ORaacle Data Provider.
    ... I'm aware that the OLEDB provider doesn't support the data type. ... > My choices then are ODP.net provided by Oracle and the Oracle Client ...
    (microsoft.public.dotnet.framework.adonet)