Subject Re: [firebird-support] Isql "copy" command - anyone know how it works?
Author Norman Dunbar
On 17/01/13 10:18, Mark Rotteveel wrote:

> Sounds like a major bug to me that it depends on 1) name of the executable
> and 2) the executable being on the path.

Could be. Sounds like one anyway. Even worse, when I sym-linked isql-fb
to isql, and tried again:

SQL> copy test my_test;
Statement failed, SQLSTATE = 28000
Your user name and password are not defined. Ask your database
administrator to set up a Firebird login.
After line 0 in file /tmp/fb_query_C8w4Oc
Errors occurred (possibly duplicate domains) in creating MY_TEST in employee

The temp file, is of course, blank when I try to view it to see what it
was doing.

I have not been able to get a setup where I can supply a user name and
password. I expect that maybe defining ISC_USER and ISC_PASSWORD before
I run isql might work.....

Yes indeed, that does work! But there has to be a way to pass username
and password, after all, you wouldn't necessarily want to define those
ever so slightly insecure variables just to use a copy command? I wouldn't!


Norman Dunbar
Dunbar IT Consultants Ltd

Registered address:
Thorpe House
61 Richardshaw Lane
West Yorkshire
United Kingdom
LS28 7EL

Company Number: 05132767