Have been installing Oracle 10g server and client on my laptop so I can play around with developing an Analysis Services Cube that can join SQL Server and Oracle tables together.
All going well, though hit a problem that BIDS couldn't connect to the XE database through an Oracle connector or Oracle OLEDB. After a good while googling I gave up but then had a thought. I found the registry setting for the Oracle XE Client and create a TNS_ADMIN entry that pointed to the server install TNSNAMES directory. I'd installed both server and client on my D drive so this worked fine.
No comments:
Post a Comment
Would love to get feedback on any of my posts.