Re: connecting to informix through PowerBuilder

ANTS wrote: > Hi, > > We have Informix 5.0. We have tried creating the stores5 database. But when > connecting through PowerBuilder, using account other than Informix (the > owner). It will say that only DBA can drop, grant, create, ... this > database. > This is no problem of the connection with powerbuilder. It is a problem of user privileges. By default "informix" has DBA privileges, all other users have CONNECT privileges only. If this is not sufficient for the user you want to connect with, you have to GRANT him RESOURCE or DBA privileges. > Another thing is that, when creating the stores5 database with logging > option, and connecting via PowerBuilder, it will give (error 255) Not in > transaction. > Most probably the error is given at the COMMIT WORK and not at CONNECT time. I think you should issue a BEGIN WORK to start a transaction before any update operation. > Please help, > > Nien Sui > > sui@naseej.com > =========================================== > Mails are checked daily and processed right away. > If you don't get my replies within 3 days please send your mail again. Helmut Leininger Bull AG Vienna Unix Support Email: Helmut.Leininger@bull.net