Issue while accessing a SQL Server table over OTG
Hi,
I have been learning oracle for about 1.5 years and am just starting to learn some OTG pieces. I am wondering about an issue. The issue is:
"We need help with an issue we are having while accessing a SQL Server table over OTG. We are getting the following error message in Oracle :
ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
[Oracle][ODBC SQL Server Driver]Unicode conversion failed {HY000}
The column it is failing on is "-----------" in the view --------------- in the SQL Server database pointed to by the Oracle DB Link ------------------- thats created in the Oracle instances ---- and -----.
This was working before, but is now failing, we suspect its due to new multi-byte data being added to the base table in the above column."
I took out the details and added ---- instead. I am wondering your guys thoughts on fixing this issue and helping me learn along the way. Thanks