D
D
Djasar2021-06-24 11:28:25
SQL
Djasar, 2021-06-24 11:28:25

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'


The query returns the correct data in the res column

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 question

Ask a Question

731 491 924 answers to any question