Linked server data type issue

  • Hi friends,

    We have a problem with ODBC driver interpreting data type differently on SQL Server 2012 linked to Oracle unicode database.

    SQL DB 2012 server - Windows 2012 server

    Oracle database server - Windows 2016, Oracle database Unicode database

    Installed Linked server - using Oracle client/ODAC and ORAOLEDB.ORACLE provider

    Using osql to run odbc trace, found that the data type being used for column is -9 which is WVARCHAR. Unfortunately our application does not support wvarchar so it has to be VARCHAR.  Is there a way to make ODBC interpret the column as varchar instead of WVARCHAR?

    osql -S server c88-798 EXIT SQLDescribeColW with return code 0 (SQL_SUCCESS)
    HSTMT 0x00000000008CA110
    UWORD 1
    WCHAR * 0x0000000000000000 <null pointer>
    SWORD 0
    SWORD * 0x00000000009DD870 (8)
    SWORD * 0x00000000009DD874 (-9)

    Appreciate all your suggestions in advance. Thank you

  • Thanks for posting your issue and hopefully someone will answer soon.

    This is an automated bump to increase visibility of your question.

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply