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 11.2.0.3.20 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 .

ScreenShot631

ScreenShot629

 

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!

Advertisements

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

Installed ODTwithODAC1110720

image

 

Installed client with it : Log of it

 

Inventory contents of (Tzvi-PC/169.254.82.172):

Oracle Homes
OraClient11g_home1
Oracle Data Access Components for Oracle Client 11.1.0.7.20
Oracle Data Provider for .NET 2.0 11.1.0.7.20
Oracle Data Provider for .NET Documentation 11.1.0.7.20
Oracle Providers for ASP.NET 11.1.0.7.20
Oracle Data Provider for .NET 2.0 11.1.0.7.20
Oracle Data Provider for .NET Documentation 11.1.0.7.20
Oracle Providers for ASP.NET Documentation 11.1.0.7.20
Oracle Developer Tools for Visual Studio 11.1.0.7.20
Oracle Data Provider for .NET 2.0 11.1.0.7.20
Oracle Data Provider for .NET Documentation 11.1.0.7.20
Oracle Developer Tools for Visual Studio .NET Documentation 11.1.0.7.20
Oracle Provider for OLE DB 11.1.0.7.20
Oracle Objects for OLE 11.1.0.7.20
Oracle Services For Microsoft Transaction Server 11.1.0.7.20
Oracle Universal Installer 11.1.0.7.0
Installer SDK Component 11.1.0.7.0
Oracle One-Off Patch Installer 11.1.0.7.0
Installer SDK Component 11.1.0.7.0
Java Runtime Environment 1.5.0.11.0
Oracle Instant Client 11.1.0.7.0
Oracle ODBC Driverfor Instant Client 11.1.0.7.0
Oracle JDBC/OCI Instant Client 11.1.0.7.0
Oracle Globalization Support 11.1.0.7.0
SSL Required Support Files for InstantClient 11.1.0.7.0
RDBMS Required Support Files for Instant Client 11.1.0.7.0
SQL*Plus Files for Instant Client 11.1.0.7.0
——————————————————————————–
HOME SELECTION
——————————————————————————–
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 :

image

Problem :

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

Solution : (more…)

Tag Cloud

%d bloggers like this: