Home » RDBMS Server » Networking and Gateways » Heterogeneous Database connections Oracle, SQL Server 2005 and MS Access
Heterogeneous Database connections Oracle, SQL Server 2005 and MS Access [message #296284] Fri, 25 January 2008 09:38 Go to next message
scumboss
Messages: 3
Registered: January 2008
Junior Member
Hi All

We have an Oracle database which has heterogeneous Database connection to SQL Server 2005 which works. Our Microsoft Access database can see our SQL Server 2005 and our Oracle Server. But it cannot see the SQL Server 2005 tables through the Oracle connection, even though we have setup the heterogeneous Database connection. We wanted to do this so we could do SQL joins on tables in our Oracle and SQL Server. Any ideas?

Cheers

Andrew Smile

[Updated on: Fri, 25 January 2008 09:38]

Report message to a moderator

Re: Heterogeneous Database connections Oracle, SQL Server 2005 and MS Access [message #296293 is a reply to message #296284] Fri, 25 January 2008 10:38 Go to previous message
Michel Cadot
Messages: 64122
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Use heterogeneous services.
Search for this, a guy posted the same question today.

Regards
Michel
Previous Topic: ORA-12514: TNS:listener does not currently know of service requested in connect
Next Topic: Not able to create tablespace
Goto Forum:
  


Current Time: Wed Dec 07 03:24:00 CST 2016

Total time taken to generate the page: 0.14409 seconds