[firebird-support] Grant and Revoke update (field)

2014-04-23 Thread Tomáš Beran
Hello, I have a problem with permissions. I test this problem on new database. I have two users (User1 and User2), one table (TEST_TABLE (PKID, NAME, AGE)). I set permission select and update(AGE) to both users. Now everything is all right, but when I revoke permission to USER2, then USER1 has n

[firebird-support] Transliteration of identifiers, query buffers etc?

2014-04-23 Thread Kjell Rilbe
Hi, I've been wondering a bit about how Firebird handles transliteration of various parts of a query, in particular regarding (quoted) identifiers. My situation is that I have a database with default charset UTF8 and all char/varchar columns use this charset. I also always use UTF8 as connecti

[firebird-support] Re: Cannot log into database

2014-04-23 Thread Virgo Pärna
On 22 Apr 2014 08:45:07 -0700, wrote: > > When I run the client trying to use the fdb on the WIN7 system I get an > "unknown user name or password" error. If I point the ALIAS to the fdb on > the old XP system I can run the client from the WIN7 system but it is > accessing the fdb on the old

[firebird-support] FB 2.5.2 SS crash

2014-04-23 Thread Zsazsi
Hi all, Today one of our client got these messages in the firebird.log: DBSERVER (Server) Wed Apr 23 09:07:15 2014 Access violation. The code attempted to access a virtual address without privilege to do so. This exception will cause the Firebird server to terminate abnormally. DBSERVER (Serve

Re: [firebird-support] Cannot log into database

2014-04-23 Thread srotyliano
Thanks for your comments. Lots to learn here and your comments are a great help. I was able to resolve the issue overnight. I first backed up the 1.5 fdb file with gbak, then installed FB 2.5 on the WIN7 system and used gbak to restore and convert the fdb file it to a 2.5 version. This works

[firebird-support] flamerobin access from client

2014-04-23 Thread byerly
I have a firebird (2.5) database being accessed by a custom application over a windows 7 network (32bit) The application works fine. The customer would also like full database access through flamerobin on a couple of the clients. Flamerobin works fine on the server system. I have set up a se

Re: [firebird-support] flamerobin access from client

2014-04-23 Thread Jesus Garcia
> I have set up a server connection on the client (server name - server, host - > \\server, port- 3050) and registered the database (name - DB, path - > \\server\, user - sysdba, password - masterkey). > > Try with the connection string: Server:c:\data\db.fdb _ >

Re: [firebird-support] flamerobin access from client

2014-04-23 Thread Helen Borrie
At 03:32 a.m. 24/04/2014, bye...@byerly.biz wrote: >I have a firebird (2.5) database being accessed by a custom application over a >windows 7 network (32bit) The application works fine. The customer would >also like full database access through flamerobin on a couple of the clients. >Flamer