Re: ODBC Database Link

From: Sybrand Bakker <gooiditweg_at_sybrandb.verwijderdit.demon.nl>
Date: Mon, 25 Oct 2004 19:40:45 +0200
Message-ID: <8ieqn0h3bjqhuk3loclncvm16ahfqrf8t1@4ax.com>

On Mon, 25 Oct 2004 17:47:31 +0200, "Bruno D." <bdurren_avirer__at_hotmail.com> wrote:

>Hi to everyone,
>
>On my Oracle 9i database, I have an odbc dblink to a sqlserver database.
>
>When it's linked on 'my' sqlserver, I have to double-quote every column like
>this:
>
> select "my_data" from my_table.
>
>When it's linked on some other sqlserver, I have *not* to double quote.
>
>I'm not sure, if it's an oracle, odbc or sqlserver setting but I can't find
>it...
>... and that makes me crazy !!!
>
>Any help ?
>

You are using lower case column names in your sql server database. Oracle considers a lower case character in an identifier as a special character. This forces you to double quote the identifier.

--
Sybrand Bakker, Senior Oracle DBA

Received on Mon Oct 25 2004 - 12:40:45 CDT