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

From: <Andrew>
Date: Sat, 20 Aug 2005 14:15:45 +0930
Message-ID: <4306b57a$1_at_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 Sat Aug 20 2005 - 06:45:45 CEST

Original text of this message