I am having trouble trying to link an Oracle DB to my SQL Server. I get this error:
"cannot create an instance of oraoledb.oracle"
I created a DSN that connects to it just fine, but when I make the connection in SQL Server I keep getting this error. Any help is appreciated. I'm using SQL Server 2008 R2 and Oracle 11g.