Or: Could not resolve the connect identifier specified.
In case of connecting ASP.NET with ORACLE using Visual Studio 2005 on Windows 7 Ultimate

1. Check the tnsnames.ora located in my case on

c:\app\juro\product\11.1.0\client_1\Network\Admin\tnsnames.ora

it should look as:

ORADA =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.12)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = ORADB)
)
)

Check the connection string:

"Data Source=ORADA;User Id=ProDB;Password=passw0rd;"

We can see the match so connection string and tnsnames are correct.

2. Run Visual Studio using local account

• Press shift key and hold it.
• Right click on Visual Studio icon.
• Select Run as different user.



• Enter some local account.