Tomorrow I will check out the oracle side including the pointed view and permissions and will share my results

it is also an interesting question, but I don't know. The other user credentials which I tested is my own user and it has sysadmin privileges as well. Both of...

I have updated OLEDB driver. The same thing( nothing has changed

Now it is midnight here and I am gonna update driver and see what happens

mapping section is empty. I don't think so because when I execute that query under SA user, I get randomly 2 different result for that specific column. I can't predict...

I was given remote login with password. From Oracle side I was given permission to query that view and underlying tables.

interesting part is that this only happens when I run that query under SA user.  When execute that query under different name, then everything ok. I decided to firstly update...

Thank you guys for your valuable time and answers. I am now satisfied with answers.

It seems that defining the protocol order in Server Configurations does not matter, sql server will choose TCP/IP as default.

Yes. Ports 139 and 445 opened. An interesting behavior I observe is when I disable TCP/IP protocol then everything works as I wanted. So, I am able to connect using...