Help needed to connect DB2k on PC to v7.3 on VMS

From: <Andrew>
Date: Sat, 20 Aug 2005 14:13:29 +0930
Message-ID: <4306b4f2@duster.adelaide.on.net>

Hi all!

Sorry guys but I am totally ignorant on oracle matters. I need some guidance in how and what is needed to connect directly to an oracle 7.3.2.3.2 database on a OpenVMS operating system with a database application developed on a Windows XP PC using DB2K.

Network/Database Server Details:

Server: Compaq AlphaServer DS10

O/S: OpenVMS 7.1
Database: Oracle 7.3.2.3.2

Protocol: TCP/IP (controlled by UCX)

Can I connect using only ODBC drivers?
Do I need an Oracle client on the pc workstation? Do I need a dedicated DB2K oracle user account (multiple users of DB2K PC application) or do I need to add an oracle user account for each individual user?

Any advice or guidance would reduce my trial and error approach as I am pressed for time and very gratefully appreciated.

Andrew Zac. Received on Fri Aug 19 2005 - 23:43:29 CDT