Answer the question
In order to leave comments, you need to log in
2 identical requests produce different values. How to fix?
The problem is in the linked server (Oracle Provider for OLE DB)
On 1 server where the drivers are installed:
ODBC Oracle in OraClient 11.02.00.03 (32bit)
and
ODBC Oracle in OraClient 12.01.00.01 (64bit)
Everything works correctly.
=============================================
On server 2 where driver installed:
ODBC Oracle in OraClient 11.02.00.04 (32bit)
ODBC Oracle in OraClient 18.00.00.00 (32bit)
and
ODBC Oracle in OraClient 12.02.00.01 (64bit)
ODBC Oracle in OraClient 19.00.00.00 (64bit)
Query returns incorrect data in a column res
select id, res --данные неверные
from openquery(REM11,
'select id, res from ARA.PROB')
where id = 'K025'
select id, res --данные верные
from openquery(REM11,
'select id, res from ARA.PROB where id = ''K025''')
Answer the question
In order to leave comments, you need to log in
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question