Subject Re: [IBO] Cannot Open File Error
Author Helen Borrie
At 03:23 AM 03-04-02 +0000, you wrote:

> Well, well... I found a work-around which makes the login succeed.
>I just entered a '0' in for the SQL-Role on the Login Dialog box and
>it allowed me in. Without the '0', I get the 'Cannot Open File'
> I don't use any Role functionality in my app, so I wouldn't want my
>users to enter '0' everytime they login. I'll try to specify '0' for
>the SQL-Role in the TIB_Connection and see if that helps.
> Anyway, this seems like a bug on either Firebird's or IBO's part.

I don't think so. I'm currently using IB_SQL compiled with IB) 4.2Gc, with
the same version of Firebird that you are using. All along I have kept
everything in step (IBO releases/patches, Firebird builds) and I have
*never* encountered any problem (like this, or any other) involving
roles. The same with applications, some compiled with older vvs of IBO,
some using TIBO*, some using TIB_*, et al., etc.

So, somewhere in your app (in your code or in your DFM) you have
*something* that is plastering roles for you. If you can't find it in your
code, then open the DFMs as text and search for the word "role". If you are
not touching roles at all, REMOVE the reference (probably in the params
strings for your connection object).

IBO doesn't pass parameters that aren't there; and Firebird silently
disposes of any role stuff that comes through, where the equivalent role is
not found in the database, i.e. if a role (whatever it is, '0' or any other
string) is not found, it stores 'NONE' in memory and subsequently ignores it.


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