[Search for users] [Overall Top Noters] [List of all Conferences] [Download this site]

Conference orarep::nomahs::dbintegrator_public_public

Title:	DB Integrator Public Conference
Notice:	Database Integration - today! Kit/Doc info see note 36
Moderator:	BROKE::ABUGOV

Created:	Mon Sep 21 1992
Last Modified:	Fri Jun 06 1997
Last Successful Update:	Fri Jun 06 1997
Number of topics:	1171
Total number of notes:	5187

1142.0. "Is SQL connect supported in ORA gateway?" by chsr38.ch.oracle.com::ROHR (The Packers did it!) Fri Apr 04 1997 07:56

    Is the Rdb SQL connect statement supported with the Oracle gateway?
    
    att 'alias conna fi /type=oracle/user=bla/pass=bla/node=sqlnet2';
    
    connect to 'alias bla file ... see above' as 'test';
    
    SQL> sho connect    
            RDB$DEFAULT_CONNECTION
    ->      test
    SQL> sho connect test;
    Connection: TEST
    %SQL-F-NOSUCHCON, There is not an active connection by that name
    
    Thanks,
    Regina

T.R	Title	User	Personal Name	Date	Lines
1142.1	Happens in Rdb too	BROKE::BITHER		`Fri Apr 04 1997 09:52`	29
	Hi Regina, This looks like a problem with Rdb. I've recreated your scenario using Rdb7-ECO 1: $ mcr sql$ SQL> att 'alias r1 f mf_personnel'; SQL> show connections; -> RDB$DEFAULT_CONNECTION SQL> connect to 'alias r1 f mf_personnel' as 'regina'; SQL> show connections; RDB$DEFAULT_CONNECTION -> regina SQL> show connection regina; Connection: REGINA %SQL-F-NOSUCHCON, There is not an active connection by that name (This next shouldn't be necessary since "-> points to regina" but I tried it anyway) $ SQL> set connection 'regina'; SQL> show connection regina; Connection: REGINA %SQL-F-NOSUCHCON, There is not an active connection by that name This follows the example in vol 2 of the SQL Ref Manual, pg 6-184 and does not appear to work to me as illustrated. Thanks, Diane
1142.2	Use delimited identifiers (or upper case names)	ORAREP::HERON::GODFRIND	Oracle Rdb Engineering	`Wed Apr 23 1997 06:59`	45
	> SQL> show connection regina; > Connection: REGINA > %SQL-F-NOSUCHCON, There is not an active connection by that name This is because the name of the connection is 'regina', a string in lower case characters. Contrast with: > SQL> connect to 'alias r1 f mf_personnel' as 'REGINA'; > SQL> show connections; > RDB$DEFAULT_CONNECTION > -> REGINA > SQL> show connection regina; > Connection: REGINA > .... > Alias R1: > Identifier character set is DEC_MCS > Default character set is DEC_MCS > National character set is DEC_MCS If you want to use a mixed or lower case connection name, you need to use delimited identifiers (and tell SQL about it): > SQL> att 'alias r1 f mf_personnel'; > SQL> show connections; > -> RDB$DEFAULT_CONNECTION > SQL> connect to 'alias r1 f mf_personnel' as 'regina'; > SQL> show connections; > RDB$DEFAULT_CONNECTION > -> regina > SQL> show connection regina; > Connection: REGINA > %SQL-F-NOSUCHCON, There is not an active connection by that name > SQL> set quoting rules "sql92"; > %SQL-I-DEPR_FEATURE, Deprecated Feature: " used instead of ' for string literal > SQL> show connection "regina"; > Connection: regina > ... > Alias R1: > Identifier character set is DEC_MCS > Default character set is DEC_MCS > National character set is DEC_MCS > SQL> show connections; > RDB$DEFAULT_CONNECTION > -> regina