RE: about Linked Servers

From: linda deng[MS] (lideng@online.microsoft.com)
Date: 05/30/02 

From: lideng@online.microsoft.com (linda deng[MS])
Date: Thu, 30 May 2002 11:28:38 GMT

Hi Windboy,

        If the four-part naming convention does not work, you can utilize
'OPENQUERY'. Or you can try to change the four-part query to upper case
instead of lower case and it probably works. From Q248062: When using SQL
linked Server queries with a four part name to access mixed-case tables in
Oracle (created without using quotes), users will need to access it using
upper case letters, from SQL Server, such as:
        Select * from OracleServer..DEMO.SQLCUST
        For more details, please refer to
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q248062.

Sincerely,

Linda Deng
Microsoft Support Engineer

This posting is provided "AS IS" with no warranties, and confers no rights.

Relevant Pages

  • Re: OUT OF MEMORY
    ... you are saying that the default upper limit is 128k when created? ... Hitchhiker's Guide to Visual Studio and SQL Server ... and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook) ...
    (microsoft.public.sqlserver.ce)
  • Re: check constraints and null values
    ... little envelope) on the upper left hand corner of the incorrect topic so ... Books Online has it wrong. ... > SQL Server follows the ANSI / ISO Standard behaviour for CHECK and FOREIGN ...
    (microsoft.public.sqlserver.programming)
  • Re: How to return all view names that begin with "vwX"
    ... What version of SQL Server are you using? ... If your server is case sensitive, INFORMATION_SCHEMA.TABLES must be upper ... >>> What is the SQL to return the name of all the views in a database that ...
    (microsoft.public.sqlserver.programming)
  • Re: how to turn off case sensitive when sort
    ... He said "...but how do I turn off switch to treat lower case and upper case ... SQL Server MVP ... Columnist, SQL Server Professional ... > Column1 collate Latin1_General_CS_AI Wouldn't you want CI as opposed to CS? ...
    (microsoft.public.sqlserver.programming)