Hello, I have an empty x.fdb in FB3. I created some user "caspian". I start
firebird.exe with
-ma flags (multi + application). Now I can connect through TCP with that
user but not with sysdba:

F:\fb3dev\fbbuild\firebird30\temp\Win32\Debug\firebird>isql localhost:x.fdb
-user sysdba -pass masterkey
Statement failed, SQLSTATE = 28000
Your user name and password are not defined. Ask your database administrator
to set up a Firebird login.
-attempt to fetch past the last record in a record stream
Use CONNECT or CREATE DATABASE to specify a database

Attempt to fetch past the last record???

This unprivileged user "caspian" exists in the DB, I defined it with CREATE
USER:

F:\fb3dev\fbbuild\firebird30\temp\Win32\Debug\firebird>isql localhost:x.fdb
-user caspian -pass caspian
Database:  localhost:x.fdb, User: caspian
SQL>

What am I missing with sysdba? It's a global user, I should not need to
create it.

If I try an unknown user but without password, I don't get the "fetch past
the last record". Same if I try a known user but with the wrong pw.

C.
---
Claudio Valderrama C.
Consultant, SW developer.


------------------------------------------------------------------------------
Learn Graph Databases - Download FREE O'Reilly Book
"Graph Databases" is the definitive new guide to graph databases and their
applications. Written by three acclaimed leaders in the field,
this first edition is now available. Download your free book today!
http://p.sf.net/sfu/13534_NeoTech
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Reply via email to