SQL Server not geting rows from OraOLEDB linked server

Question

I have two Windows 2008 Server 64x machines. One running Oracle 10.2.x.x.x (Express Edition) and other SQL Server 2008 R2 with ODAC 12c (12.1.0.2.4).

I had created linked server, tested connection and it passes. I can see all Oracle tables, but when I query them, for example:

SELECT *
FROM ORACLE..USER.PERSON

All I get back are columns without no rows. If I run query from Oracle SQL Developer I get around 13000 rows.

What could be problem? I thought it was problem with backward compatibility, but according to this link it is not. It could be something with permissions/security?

Matjaž · Accepted Answer · 2017-04-24 06:47:35Z

1

Well it was nothing to do with linked server configuration. I didn't know that after every insert I need to commit changes.

SQL> commit;

answered Apr 24, 2017 at 6:47

Matjaž

2,1253 gold badges37 silver badges58 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

SQL Server not geting rows from OraOLEDB linked server

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related