I was working on one the Enterprise customer Incident. The issue at hand was that we were unable to use Oracle Synonyms in a Four part naming query against a SQL-Oracle Linked Server. To probe the scenario, I had to set up a repro locally. Step 1 : To Create a test user on Oracle Login using a...

I ran into an issue creating a linked server on SQL 2005 64-bit. I was trying to connect to a 2000 32-bit server. The error I received was: OLE DB provider "SQLNCLI" for linked server "servername" returned message "Unspecified error". OLE DB provider "SQLNCLI" for linked server "servername" returned...