Linked server data type issue

• newbieuser

  SSCrazy Eights

  Points: 9423

  More actions

  October 14, 2019 at 7:44 pm

  #3688657

  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: 80325

  More actions

  October 15, 2019 at 8:10 pm

  #3689059

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

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