Registrations are now open. Join us today!
There is still a lot of work to do on the wiki yet! More information about editing can be found here.
Already have an account?

Microsoft KB Archive/247750

From BetaArchive Wiki
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



APPLIES TO

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



This article was previously published under Q247750

BUG #: 56517 (SQLBUG_70)

SYMPTOMS

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.

WORKAROUND

Query the table(s) using quotes in Oracle.

STATUS

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