Friday, March 30, 2012

OpenQuery Problems with Date Function Different MS-SQL 7 / MS-SQL

Hi
It is a change in the Microsoft Oracle driver to support the newer versions
of Oracle. In effect, it is a change required by Oracle that Microsoft had t
o
comply with so that the driver would continue to work. AFAIK, the change was
introduced in MDAC v2.5
Regards
Mike
"Klaus" wrote:

> hi,
>
> Currently we move a couple of SQL Server 7.0 to SQL Server 2000 and right
> now we habe big problems with a OPENQUERY Statement
> The SQL Server 7.0 and Windows 2000 is a german version, the MS-SQL Server
> 2000 and Windows 2000 is in english
>
> The Query on the MS-SQL Server 7 works fine
> SELECT * FROM OPENQUERY (ABKG002,
> 'SELECT DISTINCT NODP.AU_AUD_BENUTZER AS BA_AUD_ERST_VON FROM
> V3FADM.AUODP_ORDERPOS_OTAB NODP WHERE NODP.AU_AUD_ZEITPUNKT >
> ''01.03.2005''')
>
> With the same Query under MS-SQL 2000 is the result
> Server: Msg 7330, Level 16, State 2, Line 1
> Could not fetch a row from OLE DB provider 'MSDAORA'.
> [OLE/DB provider returned message: ORA-01843: not a valid month]
> OLE DB error trace [OLE/DB Provider 'MSDAORA' IRowset::GetNextRows returne
d
> 0x80040e07].
>
>
> if we change the Query like below, the OPENQUERY is fine. IS THIS REALLY
> only the way the OPENQUERY works fine? That means for us we have to recrea
te
> a lot of VB Applications
> SELECT * FROM OPENQUERY (ABKG002, 'SELECT DISTINCT NODP.AU_AUD_BENUTZER AS
> BA_AUD_ERST_VON FROM V3FADM.AUODP_ORDERPOS_OTAB NODP WHERE
> NODP.AU_AUD_ZEITPUNKT > to_date(''22.03.2005'',''dd.mm.yyyy'')')
>
>
> Has anybody an IDEA?
>
>
> thx
> klaus
>
>
>Hi Mike
thanks for the very fast and good answer !
Klaus
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> schrieb im Newsbeitrag
news:5C2EC99E-CB18-4B1D-8DCA-6A04ED22255C@.microsoft.com...
> Hi
> It is a change in the Microsoft Oracle driver to support the newer
> versions
> of Oracle. In effect, it is a change required by Oracle that Microsoft had
> to
> comply with so that the driver would continue to work. AFAIK, the change
> was
> introduced in MDAC v2.5
> Regards
> Mike
> "Klaus" wrote:
>

No comments:

Post a Comment