Results 1 to 6 of 6
  1. #1
    Join Date
    May 2003
    Location
    Salvador - BA - Brasil
    Posts
    12

    Unanswered: DBLink with Generic HS to MS-SQL Srv 2k

    Hello Group!

    I want to use a DBLink to a SQL 2000 server using the Generic Oracle HS with OleDB.
    I create the BDlink and I can use simple queries, like:

    select * from table@oledblink;

    It's working fine.
    But, if I try anything like this:

    select * from table@oledblink where col1 = 'xxx';

    The Oracle returns: ORA-00904: invalid column name....

    Can anyone help me ?

    TIA,

    Aldair.

  2. #2
    Join Date
    Oct 2003
    Location
    St.Louis,MO
    Posts
    120
    Did you try double quotes?

  3. #3
    Join Date
    Oct 2003
    Location
    St.Louis,MO
    Posts
    120
    where "col1" = 'xxx'

    sorry. edited.

  4. #4
    Join Date
    May 2003
    Location
    Salvador - BA - Brasil
    Posts
    12
    Thank YOU !!! Its work well !!!

  5. #5
    Join Date
    May 2003
    Location
    Salvador - BA - Brasil
    Posts
    12
    Thank YOU !!! Its work well !!!

  6. #6
    Join Date
    Oct 2003
    Location
    St.Louis,MO
    Posts
    120
    I have found that when you are refrencing SQL Server objects directly over a OLE DBlink it is a good habit to enclose schema objects(or what we refer to as schema objects in Oracle) in double quotes.
    i.e. table_names, column_names...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •