| Title: | The Replication Option for Rdb |
| Notice: | Product renamed to Replication Option for Rdb |
| Moderator: | BROKE::PROTEAU |
| Created: | Wed Mar 02 1994 |
| Last Modified: | Wed Jun 04 1997 |
| Last Successful Update: | Fri Jun 06 1997 |
| Number of topics: | 287 |
| Total number of notes: | 1231 |
ROR V7.0, Rdb V7.0 on OpenVMS/AXP.
I tried to use rdb$remote with IP like specified in the ROR handbook
"Example 4-2 (Cont.) Explicitly Named Remote Account Using Syntax for TCP/IP"
the workaround was to specified "sql_password,sql_username" in the
configuration file rdb$client_defaults.dat
Do I missed something ?
Thanks
/Jean-Luc
create transfert test_syntax type is replication move table employees
to existing filename 'w2:[jsubri.70]ddal70.rdb-
USER ''jsubri'' USING ''password'''
log filename 'W2:[JSUBRI.70]test_syntax.log';
** CLIENT: trn::trn - TRN CREATED - trn_obj = 0X1aa25c8
** CLIENT:
** CLIENT: trn::start; trn_obj = 0X1aa25c8
** CLIENT: rdb_ddtm_trn_cls::tm_set_tid; Setting TID to all zeros since the TID
address is 0
** CLIENT: ddtm_trn_cls::tm_is_tid_zero; TID contains all zeros
** CLIENT: ddtm_trn_cls::tm_is_tid_zero; TID contains all zeros
** CLIENT: trn:check_mask: write count=0, tid=0. Turning off 2pc
** CLIENT: trn::start; db obj = 0X79fbb8
** CLIENT: trn::start - rci trn handle = 0X1aa26e8
** CLIENT: trn::start - trn_db_count = 0X1
** CLIENT:
** CLIENT:
** CLIENT: trn::commit; trn_obj = 0X1aa25c8
** CLIENT: trn::commit; calling engine - db_obj = 0X79fbb8
** CLIENT: sbtrn::~sbtrn - destructing sbtrn 0X1aa28c8
** CLIENT: trn::commit; zero out in_transid->handle
** CLIENT: trn::~rdb_trn_cls - TRN Deleted - trn_obj = 0X1aa25c8
** CLIENT: trn::~rdb_trn_cls - TRN handle = 0X1aa26e8
** CLIENT: trn::clear_user_address; trn_obj = 0X1aa25c8
** CLIENT: trn::clear_user_address; user_address = 0X7afb9458
** CLIENT: db::parse_db_filename: COSI parse error. Status = 0X56ec0d4
** CLIENT: db::parse_db_filename: File name = w2:[jsubri.70]ddal70.rdb USER
'jsubri' USING 'password'
%SQL-F-ERRATTDEC, Error attaching to database w2:[jsubri.70]ddal70.rdb USER
'jsubri' USING 'password'
-RDB-E-BAD_DB_FORMAT, w2:[jsubri.70]ddal70.rdb USER 'jsubri' USING 'password'
does not reference a database known to Rdb
-RMS-F-SYN, file specification syntax error
SQL>
| T.R | Title | User | Personal Name | Date | Lines |
|---|---|---|---|---|---|
| 261.1 | Do NOT put USER and USING in CREATE TRANSFER | BROKE::PROTEAU | Jean-Claude Proteau | Wed Jan 15 1997 08:56 | 10 |
Jean-Luc,
In the example you've shown here you included USER and USING syntax in
the CREATE TRANSFER statement. You must not do that. As you can see,
SQL reports an error. Just specify the target file specification
without the USER and USING clauses. Then, use one of the alternative
methods of specifying the username and password by putting them in the
SQL dat file or in the ROR configuration file (different syntax).
Claude
| |||||