On 2017-11-28 00:06, Justis Root justis.root@...
[firebird-support] wrote:

> Thank you for your responses,
>
> I’m running firebird 3.0; I’m not sure what version of firebird
> the database files were generated with.
> I’m using the JDBC driver to connect from InfoCaptor.
>
> When using the ISQL tool to try and connect, this is what I see:
> https://gyazo.com/b122c8c6de54be1d07a5240dc65c4ff6
> I don’t even get an error.

In isql commands, statements, etc need to be terminated with a
semi-colon (;), the 'CON>' prompt (for continuation) indicates it is
waiting for more input or the semi-colon to complete the statement.

> I’m not sure if that means the connection was successful or
> unsuccessful.
> I was attempting to follow this tutorial:
> https://www.firebirdsql.org/pdfmanual/html/isql-connect-database.html
>
> When I try and connect with the same credentials with InfoCaptor via
> the JDBC driver, the error I get is simply “null”.
> The JDBC url I’m using is
> “jdbc:firebirdsqlLlocalhost/3050:T:/Database/ejdb.fdb”. And the
> user and password are the same as in the above screenshot.

That is an invalid url, the proper form would be:

jdbc:firebirdsql://localhost:3050/T:/Database/ejdbc.fdb

I don't know InfoCaptor, but it sounds like it tries to directly use the
JDBC driver instead of through DriverManager.
You get 'null', because that URL is not recognized by Jaybird, and per
the JDBC requirements it returns null.

See also:
https://www.firebirdsql.org/file/documentation/drivers_documentation/java/faq.html#pure-java-default

For Jaybird specific problems, please post to the firebird-java
mailinglist instead

Mark