| Heterogeneous Database connections Oracle, SQL Server 2005 and MS Access [message #296284] |
Fri, 25 January 2008 09:38  |
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 
[Updated on: Fri, 25 January 2008 09:38] Report message to a moderator |
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
