Results 1 to 7 of 7
  1. #1
    Join Date
    Dec 2008
    Posts
    135

    Unanswered: HScoonection from oracle to sqlserver

    I have created a heterogeneous connection from oracle 10g to sql server 2005 successfully by following the steps specified in the link below
    Heterogeneous Database connections - Oracle to SQL Server

    my issue is, when i am trying to select data from sqlserver i am getting the
    below error
    QUERY----
    select * from Declaration_Task@db_sql
    ERROR-------
    connection from ORACLE to a non-Oracle system returned this message:
    [Generic Connectivity Using ODBC][H00C] Attempt to access a column CustomPointStorageAreaName_English with unsupported name length (greater than 30 characters).
    ORA-02063: preceding 2 lines from DB_SQL

    how to resolve this issue?

    Thanks in advance

  2. #2
    Join Date
    Jun 2003
    Location
    West Palm Beach, FL
    Posts
    2,713

    Talking Cut the name

    Quote Originally Posted by bklr
    ...[Generic Connectivity Using ODBC][H00C] Attempt to access a column CustomPointStorageAreaName_English with unsupported name length (greater than 30 characters).
    ORA-02063: preceding 2 lines from DB_SQL

    how to resolve this issue?
    1) Don't use column names longer than 32 characters.
    2) Create a view with shorter names.
    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

  3. #3
    Join Date
    Dec 2008
    Posts
    135
    hi LKBrwn_DBA,
    thanks for your reply.
    but, suppose if i have 50 tables in sql server db, then i need to create 50
    views for all those tables .

  4. #4
    Join Date
    Jun 2003
    Location
    West Palm Beach, FL
    Posts
    2,713

    Cool Duh!

    Only for those that have column names greater than 30 characters long.
    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

  5. #5
    Join Date
    Aug 2009
    Posts
    2
    Hi please help me how to create connection from oracle 10g in linux/Aix to sql server 2005 in windows

  6. #6
    Join Date
    Aug 2009
    Posts
    2
    please help me soon...

  7. #7
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    read the link in the first entry to this tab.
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

Posting Permissions

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