Oracle Database Discussions

Hi,

The scenario is as follows: I have Oracle 11g R2 installed on a Windows Server 2008 (32-bit) server. The database SID is 'PGMS'. I am accessing (or want to access remotely) the Oracle database from the Visual Studio 2008 development environment (client environment) running on a Windows XP (SP3) platform. I have already installed the ODAC (Ver. 11.2.0.2.1) package for the Visual Studio environment.

I have created a sample Windows Forms application that uses the Oracle data access components. The sample schema HR in the Oracle database has already been unlocked. This is the schema that I am using in the application.

The issue that I am facing is that when I am adding the data connection in the Visual Studio environment; 'Test Connection' functionality returns the following error: ORA-12170 ... Connection timed out.

I have checked the TNSNAMES.ORA file, and everything is as is mentioned in the Oracle documentation. It is as follows:

PGMS=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.161)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = PGMS)
)
)

Kindly request the community to help me out in overcoming the error and in making the connection successfully. We have a System administrator but not a database administrator. The Oracle installation has been done by me.

Thanks,
Renj
----------