Tips and Tricks in a world of Mix

Posts tagged ‘ODT’

Synonym of Oracle is missing– Is the Oracle False messiah ?!

After installing the ODT and updating it after to work with VS2012 to ODAC with Oracle Developer Tools for Visual Studio on the same Oracle Client Home

I was able to create the EDMX model , but the synonyms stayed hidden to me on the wizard of the VS (by the way at VS 2010 also) .

The connection works perfect and gets me the regular tables , views and stored procedures .

The trouble is with the rest .




From my approach to Oracle I’ve got a couple of links and a statement that it’s Microsoft’s product that doesn’t support the import at the initialization wizard.

The links provided –

1) Make Entity Framework Designer support Synonyms  – we are not Code First – the schema exists and running

2)A problem to view synonym of Oracle in the Entity Data Model Designer – can’t see the synonyms , not with dba not with any user ..


Any ideas will be appreciated!


Oracle installation–tutorial , problems & solutions 11g ODT , ODAC with Toad on Windows 7

Installed ODTwithODAC1110720



Installed client with it : Log of it


Inventory contents of (Tzvi-PC/

Oracle Homes
Oracle Data Access Components for Oracle Client
Oracle Data Provider for .NET 2.0
Oracle Data Provider for .NET Documentation
Oracle Providers for ASP.NET
Oracle Data Provider for .NET 2.0
Oracle Data Provider for .NET Documentation
Oracle Providers for ASP.NET Documentation
Oracle Developer Tools for Visual Studio
Oracle Data Provider for .NET 2.0
Oracle Data Provider for .NET Documentation
Oracle Developer Tools for Visual Studio .NET Documentation
Oracle Provider for OLE DB
Oracle Objects for OLE
Oracle Services For Microsoft Transaction Server
Oracle Universal Installer
Installer SDK Component
Oracle One-Off Patch Installer
Installer SDK Component
Java Runtime Environment
Oracle Instant Client
Oracle ODBC Driverfor Instant Client
Oracle JDBC/OCI Instant Client
Oracle Globalization Support
SSL Required Support Files for InstantClient
RDBMS Required Support Files for Instant Client
SQL*Plus Files for Instant Client
Central Inventory Location: “C:\Program Files (x86)\Oracle\Inventory”
Oracle Home           Status
OraClient11g_home1    Selected

PATH = C:\app\Tzvi\product\11.1.0\db_1\bin;C:\Program Files\Common Files\Microsoft Shared\Windows Live;C:\Program Files (x86)\Common Files\Microsoft Shared\Windows Live;C:\app\Tzvi\product\11.1.0\client_1;C:\app\Tzvi\product\11.1.0\client_1\bin;%SystemRoot%\system32;%SystemRoot%;%SystemRoot%\System32\Wbem;%SYSTEMROOT%\System32\WindowsPowerShell\v1.0\;c:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\;c:\Program Files\Microsoft SQL Server\100\Tools\Binn\;c:\Program Files\Microsoft SQL Server\100\DTS\Binn\;C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\;C:\Program Files (x86)\Microsoft SQL Server\100\DTS\Binn\;C:\Program Files (x86)\Microsoft Visual Studio 9.0\Common7\IDE\PrivateAssemblies\;C:\Program Files (x86)\Windows Live\Shared


Installed DB – WindowsServer_x64_11g :


Problem :

“Oracle Database 11g is not certified on the current operating system.”

Solution : (more…)

Tag Cloud

%d bloggers like this: