Subject Re: [IBO] IB_Connection1.AlterUser Problem
Author Helen Borrie (TeamIBO)
At 10:21 AM 01-08-02 +0200, you wrote:
>I run the following which completely hangs my application.
> IB_Connection1.AlterUser(uaAddUser,Edit1.Text,Edit2.text,edit3.Text,
> Edit1.Text,Edit1.Text,Edit1.Text);
>The connection data is
> object IB_Connection1: TIB_Connection
> PasswordStorage = psNotSecure
> Params.Strings = (
> 'PATH=/semaphoredata/firebirddbs/BodyTrak2.gdb'
> 'USER NAME=sysdba')
> Left = 146
> Top = 96
> SavedPassword = '.JuMbLe.01.402F02200322'
>I successfully runned the same command when the database serer was on the
>same computer as windows 2000 machine. Could it have something to do with
>the linux machine or with the location of isc4.gdb?

No, there's no reason why this stream should *hang* your machine. If
anything were amiss with the user name or password, it would return an
error message, not hang the application.

>The AGroupName parameter, is that the role which the user belongs to?

No, it's a host network feature to support Unix groups - not related to
database ROLE at all. My guess is that your application may not be hung,
but that the Linux server is searching in vain for a group with same name
as you are passing to it...

By the way, only user name and password are required fields in the USERS
record. It's not necessary (nor really desirable) to pass dummy strings
for fields you aren't using. A dummy group name will obviously cause
problems; and duplicating the user name into the last three fields of the
user record is quite unnecessary. Just pass NULL to those fields.

Helen Borrie (TeamIBO Support)

** Please don't email your support questions privately **
Ask on the list and everyone benefits
Don't forget the IB Objects online FAQ - link from any page at