Subject Re: [firebird-support] Help accessing FB in win98
Author Paul Vinkenoog
Hi Francisco,

> public static Connection getCon()
> {
> Connection c = null;
> String maquina = "";
> try
> {
> maquina = getCaminhoServidor();
> /* localhost or, ... */
> }
> catch(Exception io){}
> String user = "SYSDBA";
> String pwd = "masterkey";
> String dir_db = "C:\\Kooky\\SiGet\\dados\\SIGET.FDB";
> String url =
> "jdbc:firebirdsql:"+maquina+"/3050:"+dir_db+"?lc_ctype=ISO8859_1";
> try{
> c = java.sql.DriverManager.getConnection (url, user, pwd);
> }
> catch(org.firebirdsql.jdbc.FBSQLException ef)
> {
> ef.printStackTrace();
> TG.Mess("Erro FB/SQL: Pegando a Conexão",ef.getMessage());
> return null;
> }
> catch(SQLException eee)
> {
> eee.printStackTrace();
> TG.Mess("Erro SQL - Pegando a Conexão",eee.getMessage());
> return null;
> }
> return c;
> }
> This after registering the driver successfully.

OK. You say this works on XP so I presume your code is correct.

>> - what happened then: an error message? nothing? an application
>> freeze-up?

> The system runs but when I try to get the connection as shown above
> I get the Exception I will show below.

>> - if there was an error message, what did it say *exactly*?

> org.firebirdsql.jdbc.FBSQLException: Resource Exception. No message
> for code 335544352 found.
> null
> null
> null
> Reason: No message for code 335544352 found.
> null
> null
> null
> at

[ stack trace omitted ]

Error code 33554352 means: no privilege. That is: the user tries to
access/execute a database object without having permission. Normally
you can only get this error if you are already connected to the

If you can't connect because the username/password is invalid, you get
335544472: User name and password not defined.

I don't see anything in your code that explains what happens, so let's
get back to my earlier question:

>> Have you tried connecting with isql, or other native admin tools?

Please open a command window on the server machine, cd to the
Firebird bin subdirectory and type this (on one line):

isql -user sysdba -pass masterkey
"localhost/3050:C:\Kooky\SiGet\dados\SIGET.FDB" <ENTER>

Do you get the connection now? If yes, try e.g.

show tables;

select * from <tablename>;

update <tablename> set <field>=<value> where <condition>;


If this works, your Firebird setup and database are both OK so the
problem must be in Jaybird or in your own code. In that case, you'll
probably get better answers on the list
(although someone here may also be able to help you out).

If it doesn't work with isql, please show us your exact commands and
error message(s).

BTW, There also seems to be a problem with reading the messages file.
Or do you always get the error number only? Myself I don't know, I've
never used Jaybird.

Paul Vinkenoog