Help SQL*Net V2 and Pro*C
From: Darrell Coons <darrell_coons_at_mc.xerox.com>
Date: 1996/06/19
Message-ID: <darrell_coons-1906961224290001_at_dcoons2.roch875.mc.xerox.com>#1/1
Date: 1996/06/19
Message-ID: <darrell_coons-1906961224290001_at_dcoons2.roch875.mc.xerox.com>#1/1
I'm having a problem using a Pro*C 2.2 program to connect to a remote database (Oracle 7.3.2) using SQL*Net V2. I can successfully connect to a local db using the following:
EXEC SQL CONNECT :oracle_user IDENTIFIED BY :oracle_pword;
But when I try to connect to the remote db using the following:
EXEC SQL DECLARE mydb DATABASE:
EXEC SQL CONNECT :oracle_user IDENTIFIED BY :oracle_pword AT mydb USING
:oracle_tns;
I get ora-12203 (TNS unable to connect to destination). However SQL*Net works OK so I'm assuming there's a problem with my connect string. BTW, all the host variables are declared as VARCHAR.
Oracle Tech Supp seems unable to resolve this problem. Anyone out there have any ideas?
-- Name: Darrell Coons E-Mail: darrell_coons_at_mc.xerox.comReceived on Wed Jun 19 1996 - 00:00:00 CEST