Re: How to connect as different user using dbaccess ?
Hi Sergiy,
connection -> connect -> {choose server} -> type user -> type password
-> {choose database}
The trick is, you can connect to the same instance.
HTH
smitin@gmail.com escribi':
> Hi there,
>
> pretty stupid question but I can't find an answer yet : how to provide
> user name and password if I want to use dbaccess ?
> So far I tried dbaccess - - <<!
> connect to dbname user 'user' using 'passwd';
> !
>
> 32412: USING clause unsupported. DB-Access will prompt you for a
> password.
> Error in line 1> Near character position 34
>
> I also tried
> dbaccess -cc 'dbname' <<!> user
> password
> !
>
> and ended with
>
> USER NAME >>userpasswd
> Enter the login name you want to use for this connection.
>
> ------------------------------------------------ Press CTRL-W for Help
> --------
>
> Any ideas ?
>
> Regards,
> Sergiy
>
sending to informix-list