Linked server data type issue

  • newbieuser

    SSCrazy Eights

    Points: 9415

    Hi friends,

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

    SQL DB 2012 server - Windows 2012 server

    Oracle database server - Windows 2016, Oracle database 11.2.0.4 Unicode database

    Installed Linked server - using Oracle 12.1.0.1 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

  • Site Owners

    SSC Guru

    Points: 80380

    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