Is it possible to create a database link between an Oracle Express 11g database to a SQL Server or do I need full 11g?

0
votes

Is it possible to create a database link between an Oracle Express 11g database to a SQL Server Database? I've succeeded in getting the connection to work the other way around but I wasn't sure if this is possible with the express edition or whether I'd need the full blown 11g installation.

1
sqlsql-serveroracleoracle11g
Yes. Assuming you are using Generic Connectivity (ODBC), the express edition has the same functionality as the enterprise edition. – Justin Cave
Turns out that this isn't the case according to the license agreement (the section on integration in particular) docs.oracle.com/cd/E17781_01/license.112/e18068/… – TangoKilo

1 Answers

1
votes

According to the license agreement it appears that you cannot do so (see the section on integration features which are not included in particular)