I am running SQL Server 2008 on Windows 7 laptop. I want to use it to connect to an Oracle database so that I may build cubes etc.
So I downloaded and installed the ODAC from Oracle's download site - it included ODP.Net and the Instant Client.
I have not configured anything any further but just open up BIDS, right click "Data Sources" -> "New Data Source".
I have 4 options here when I click "New.." but each of them end up in the same error.
OracleClient Data Provided Oracle Data Provider for .NET Microsoft OLE DB Provider for Oracle Oracle Provider for OLE DB
When I click "Test Connection" the error pops up "Test connection failed because of an error in initializing provider. ORA-12154: TNS:could not resolve the connect identifier specified".
I can't get any further than this.
Can anyone see what I am doing wrong?
View Complete Post