Today I though I'd give Firebird 3.0 a shot, but for some reason I can't seem to get it installed - at least not in a way that I can connect from a JDBC application.
What I did was to follow this article:
This is what happened:
c:\etc\Firebird30>gsec -add sysdba -pass masterkey c:\etc\Firebird30>start firebird.exe -a -m c:\etc\Firebird30>isql Use CONNECT or CREATE DATABASE to specify a database SQL> create database "localhost:c:\temp\mydbfb3.fdb" user "sysdba" password "masterkey"; Statement failed, SQLSTATE = 08006 Error reading data from the connection. SQL>
Now creating the database "locally" works:
SQL> create database "c:\temp\mydbfb3.fdb" user "sysdba" password "masterkey"; SQL> commit; SQL>
But in that case, when I connect from a JDBC application (still everything "localhost"), I get the error message (using sysdba/masterkey to log in)
GDS Exception. 335544472. Your user name and password are not defined. Ask your database administrator to set up a Firebird login. Reason: Your user name and password are not defined. Ask your database administrator to set up a Firebird login.
I double-checked (more than once) that the username and password in the JDBC application is sysdba/masterkey.
From the commandline I can indeed access that newly created database:
SQL> connect 'c:\temp\mydbfb3.fdb'; Database: 'c:\temp\mydbfb3.fdb' SQL> create table foo (bar integer); SQL> insert into foo values (1); SQL> select * from foo; BAR ============ 1 SQL> commit; SQL>
I'm sure I'm missing something obvious, but what?