Paul Vinkenoog wrote:

> Hi Francisco,
>
> > public static Connection getCon()
> > {
> > Connection c = null;
> > String maquina = "";
> > try
> > {
> > maquina = getCaminhoServidor();
> > /* localhost or 192.168.0.1, 192.168.0.2 ... */
> > }
> > 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
> database!
>
> 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>;
>
> etc.
>
> 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 Firebird-Java@yahoogroups.com 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.
>
>
> Greetings,
> Paul Vinkenoog
>

Whey trying this: isql -user sysdba -pass masterkey
"localhost/3050:C:\Kooky\SiGet\dados\SIGET.FDB"

I get this: ERROR SQLCODE -922