Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> ODBC Database Link

ODBC Database Link

From: Bruno D. <bdurren_avirer__at_hotmail.com>
Date: Mon, 25 Oct 2004 17:47:31 +0200
Message-ID: <clj76f$128o$1@feed.teaser.net>


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 ? Received on Mon Oct 25 2004 - 10:47:31 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US