Oracle Database Discussions

I have my Oracle RDB running in OpenVMS environment. Below is my server configuration.

SQLSRV> show server;
Server Version: 7.3
Server Platform: HP OpenVMS IA64
Max Shared Mem Size: 8000 Kb
Config file: SYS$SYSROOT:[SYSMGR]SQLSRV_CONFIG_FILE73.DAT;1
Log path: SYS$MANAGER:
Dump path: SYS$MANAGER:
Proc start time: <none>
Proc shut time: <none>
Network Ports: (State) (Protocol)
DECnet object DBS_SERVER Running Native
TCP/IP port 2200 Running Native
Current shared memory usage:
Allocation unit: 65536 bytes
Total memory: 8192000 bytes (125 units)
Free memory: 7864320 bytes (120 units)
Partly allocated: 262144 bytes ( 4 units)
Log File: SYS$SYSROOT:[SYSMGR]SQS_I64V82_SQLSRV_MON_0073.LOG;
Dump File: SYS$SYSROOT:[SYSMGR]SQS_I64V82_SQLSRV_73.DMP;


Below are my services.

SQLSRV> show services;
C l i e n t s E x e c u t o r s
Name State Per-Exec Max Active Min Max Running
OCI_SAMPLE RUNNING 1 10 0 1 10 1
RMU_SERVICE RUNNING 1 100 0 4 100 4
GENERIC RUNNING 1 10 0 2 10 2
SQLSRV_MANAGE RUNNING 100 0 1 0 0 0

I have the below shown dispatchers.

SQLSRV> show dispatcher;
Dispatcher SQLNET_DISP
State: INACTIVE
Autostart: on
Max connects: 100 clients
Idle User Timeout: <none>
Max client buffer size: 5000 bytes
Network Ports: (State) (Protocol)
SQL*Net listener LISTENER1 Unknown SQL/Services
Log path: SYS$MANAGER:
Dump path: SYS$MANAGER:

Dispatcher OCI_DISP
State: INACTIVE
Autostart: off
Max connects: 100 clients
Idle User Timeout: <none>
Max client buffer size: 5000 bytes
Network Ports: (State) (Protocol)
SQL*Net listener oci_listener Unknown OCI clients
Log path: SYS$MANAGER:
Dump path: SYS$MANAGER:

Dispatcher RMU_DISP
State: RUNNING
Autostart: on
Max connects: 100 clients
Idle User Timeout: <none>
Max client buffer size: 5000 bytes
Network Ports: (State) (Protocol)
DECnet object RMU_DISP Running Native
TCP/IP port 1571 Running Native
Log path: SYS$MANAGER:
Dump path: SYS$MANAGER:
Log File: SYS$SYSROOT:[SYSMGR]SQS_I64V82_RMU_DISP00873.LOG;
Dump File: SYS$SYSROOT:[SYSMGR]SQS_I64V82_RMU_DISP008.DMP;

Dispatcher SQLSRV_DISP
State: RUNNING
Autostart: on
Max connects: 101 clients
Idle User Timeout: <none>
Max client buffer size: 5000 bytes
Network Ports: (State) (Protocol)
SQL*Net listener LISTENER1 Running SQL/Services
TCP/IP port 119 Running SQL/Services
DECnet object 81 Running SQL/Services
Log path: SYS$MANAGER:
Dump path: SYS$MANAGER:
Log File: SYS$SYSROOT:[SYSMGR]SQS_I64V82_SQLSRV_DIS00373.LO
G;
Dump File: SYS$SYSROOT:[SYSMGR]SQS_I64V82_SQLSRV_DIS003.DMP;

My generic service has the below configuration.

SQLSRV> show service generic full;
Service GENERIC
State: RUNNING
Owner: APFQA1
Owner Password: <not specified>
Protocol: SQL/Services
Default Connect Username: APFQA1
Default Connect Password: <not specified>
SQL version: 7.2
Autostart: on
Process init: <not specified>
Attach: ATTACH 'FILENAME SYS$COMMON:[SYSHLP.EXAMPLES.RDB72
]PERSONNEL.RDB'
Schema: <not specified>
Reuse: SESSION
Database Authorization: CONNECT USERNAME
dbsrc file: <not specified>
SQL init file: <not specified>
Appl Transaction Usage: SERIAL
Idle User Timeout: <none>
Idle Exec Timeout: 1800 seconds
Min Executors: 2
Max Executors: 10
Running Executors: 2
Clients Per Executor: 1
Active Clients: 0

Access to service GENERIC
Granted to users:
Default Connect Username 'APFQA1'
PUBLIC PRIVILEGED_USER 'APFQA1' 'SQLSRV$DEFLT'


Now when i try to connect to server using Oracle RDB ODBC driver, it says that connection is refused. I am able to ping to my server machine from client.

Below is my ODBC configuration

DataSource Name = Oracle RDB
Transport = 2=tcp/ip
Server = 10.60.255.37
Service = generic
UserID = apfqa1
*Attach Statement = ATTACH 'FILENAME SYS$COMMON:[SYSHLP.EXAMPLES.RDB72]PERSONNEL.RDB*

and this is the error that i get

FAILED: Service Connection test
rc=-1
SQLState=08S01
*[Oracle][ODBC][Rdb] Connect Ret -1 Err#10061 WSAECONNREFUSED Connection refused*

And when i try using Microsoft ODBC driver it says

Details:
*SQL Error: [Microsoft][ODBC driver for Oracle][Oracle]ORA-12541: TNS:no list*
ener
SQL State: NA000 from SQLConnect
SQL Native Code : 12541

Can you please let me where I am going wrong and what needs to be done to configure the connection using both Microsoft ODBC and Oracle RDB ODBC drivers.