Microsoft KB Archive/247750

From BetaArchive Wiki
< Microsoft KB Archive
Revision as of 16:13, 18 July 2020 by 3155ffGd (talk | contribs) (importing KB archive)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Knowledge Base

BUG: Table Names Enclosed in Double Quotes When Transferred from SQL Server to Oracle

Article ID: 247750

Article Last Modified on 2/24/2004


  • Microsoft SQL Server 7.0 Standard Edition
  • Microsoft SQL Server 2000 Standard Edition

This article was previously published under Q247750

BUG #: 56517 (SQLBUG_70)


When table(s) are transferred from SQL Server 7.0 to Oracle7.x or Oracle 8.x using the Microsoft OLE-DB Provider for Oracle in Data Transformation Services (DTS), they are enclosed in double quotes when created in Oracle.


Query the table(s) using quotes in Oracle.


Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

Additional query words: kbbug oracle

Keywords: kbbug kbpending KB247750