Re: [firebird-support] Trouble establishing a connection to Firebird database files.

[Justis Root justis.r...@gmail.com [firebird-support]]

Thank you for all of your help Helen,

I was able to locate the issue, that being that the drive I’m trying to connect 
to is a network drive and not a wired in physical drive.
I almost can’t believe I’d been trying so many things and installing and 
uninstalling so many different versions of everything just for it to have been 
something so simple.

The error, by the way, when I typed the SQL statement PROPERLY, was “Could not 
locate path specified” or something along those lines.

Thanks again for you’re help. You really went above and beyond with all that 
you’ve taught me.
Hopefully you won’t have be hearing from me again.

Have an incredible evening.
- Justis

> On Nov 27, 2017, at 11:21 PM, Helen Borrie hele...@iinet.net.au 
> [firebird-support]  wrote:
> 
> 
> Tuesday, November 28, 2017, 12:06:27 PM, Justis wrote:
> 
> >I’m running firebird 3.0; I’m not sure what version of firebird the database 
> >files were generated with.
> 
> You can find out, using another command line tool. Open a command
> shell and go to the Firebird root directory.
> 
> Then do
> 
> gstat -h d:\path\to\your\database
> 
> where d:\path\to\your\database is the absolute (i.e., not relative)
> file path to your database
> 
> If you do that right, and the database was created or restored under
> Fb 3, you should see output similar to this:
> 
> C:\Programs64\Firebird_3_0>gstat -h 
> c:\programs64\firebird_3_0\examples\empbuild\employee.fdb
> 
> Database "C:\PROGRAMS64\FIREBIRD_3_0\EXAMPLES\EMPBUILD\EMPLOYEE.FDB"
> Database header page information:
> Flags 0
> Generation 168
> System Change Number 0
> Page size 8192
> ODS version 12.0
> Oldest transaction 160
> Oldest active 161
> Oldest snapshot 161
> Next transaction 161
> Sequence number 0
> Next attachment ID 21
> Implementation HW=AMD/Intel/x64 little-endian OS=Windows CC=MSVC
> Shadow count 0
> Page buffers 0
> Next header page 0
> Database dialect 3
> Creation date Mar 21, 2017 10:15:35
> Attributes
> 
> Variable header data:
> *END*
> 
> If it was created or restored under an older Firebird, you will see
> this:
> 
> C:\Programs64\Firebird_3_0>gstat -h 
> c:\programs64\firebird_2_5\examples\empbuild\employee.fdb
> 
> Wrong ODS version, expected 12, encountered 11
> 
> ODS means "on-disk structure". Each major verson (1.0, 1,5, 2.0, 2.1,
> 2.5, 3.0, 4.0) has its own ODS:
> ODS 10.0 ~~ Fb 1.0 ODS 10.1 ~~ Fb 1.5
> ODS 11.0 ~~ Fb 2.0 ODS 11.1 ~~ Fb 2.1
> ODS 11.2 ~~ Fb 2.5 ODS 12.0 ~~ Fb 3.0
> 
> So, take note of the 'encountered' ODS if you get that message, as it
> will tell you what version of Fb you need to install instead.
> 
> (Actually, this just revealed a bug in Fb3's gstat. It should have
> reported '11.2', not '11'.)
> 
> BTW, Fb 2.5 and below *can* attach to databases with older ODS, so if
> Fb 3 gives you the Wrong ODS version error, try installing V.2.5, as
> its gstat -h and iqsl tools will read 11.0, 11.1 and 11.2.
> 
> However, if you need to make a gbak backup of your database, in order
> ro restore it as ODS 12 under Fb 3, you will need to run the backup on
> the actual Firebird server version that created it.
> 
> >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.
> 
> > I’m not sure if that means the connection was successful or unsuccessful.
> 
> It means neither. The CON> prompt there means isql is waiting for a
> semi-colon, which is isql's line terminator. But that is not a valid
> CONNECT statement you have there, anyway, even with the semi-colon.
> If you supply the user and/or password arguments to the CONNECT
> statement, the syntax is:
> 
> SQL> CONNECT 'localhost:employee' USER sysdba PASSWORD 'masterkey';
> 
> Note that employee is an alias for
> c:\programs64\firebird_3_0\examples\empbuild\employee.fdb. Read up
> about database aliases - they are very friendly to have around.
> 
> As you did it, in Fb 3, with an embedded connect, you don't need
> the PASSWORD argument at all. You will need the USER argument as,
> otherwise, you will be logged in under your Windows user name, which
> may not, at this point, have the permissions you need to access
> objects in the database.
> 
> >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.
> 
> 3050 is the default port so you don't need it. But that URI looks
> weird, anyway.
> 
> Try
> 
> "jdbc:firebirdsql://localhost:T:/Database/ejdb.fdb 
> "
> 
> But it can't work if driv

Re: [firebird-support] Trouble establishing a connection to Firebird database files.

[Helen Borrie hele...@iinet.net.au [firebird-support]]

Tuesday, November 28, 2017, 12:06:27 PM, Justis wrote:

>I’m running firebird 3.0; I’m not sure what version of firebird the database 
>files were generated with.

You can find out, using another command line tool.  Open a command
shell and go to the Firebird root directory.

Then do

gstat -h d:\path\to\your\database

where d:\path\to\your\database is the absolute (i.e., not relative)
file path to your database

If you do that right, and the database was created or restored under
Fb 3, you should see output similar to this:

C:\Programs64\Firebird_3_0>gstat -h 
c:\programs64\firebird_3_0\examples\empbuild\employee.fdb

Database "C:\PROGRAMS64\FIREBIRD_3_0\EXAMPLES\EMPBUILD\EMPLOYEE.FDB"
Database header page information:
Flags   0
Generation  168
System Change Number0
Page size   8192
ODS version 12.0
Oldest transaction  160
Oldest active   161
Oldest snapshot 161
Next transaction161
Sequence number 0
Next attachment ID  21
Implementation  HW=AMD/Intel/x64 little-endian OS=Windows 
CC=MSVC
Shadow count0
Page buffers0
Next header page0
Database dialect3
Creation date   Mar 21, 2017 10:15:35
Attributes

Variable header data:
*END*

If it was created or restored under an older Firebird, you will see
this:

C:\Programs64\Firebird_3_0>gstat -h 
c:\programs64\firebird_2_5\examples\empbuild\employee.fdb

Wrong ODS version, expected 12, encountered 11

ODS means "on-disk structure".  Each major verson (1.0, 1,5, 2.0, 2.1,
2.5, 3.0, 4.0) has its own ODS:
ODS 10.0 ~~ Fb 1.0  ODS 10.1 ~~ Fb 1.5
ODS 11.0 ~~ Fb 2.0  ODS 11.1 ~~ Fb 2.1
ODS 11.2 ~~ Fb 2.5  ODS 12.0 ~~ Fb 3.0

So, take note of the 'encountered' ODS if you get that message, as it
will tell you what version of Fb you need to install instead.

(Actually, this just revealed a bug in Fb3's gstat.  It should have
reported '11.2', not '11'.)

BTW, Fb 2.5 and below *can* attach to databases with older ODS, so if
Fb 3 gives you the Wrong ODS version error, try installing V.2.5, as
its gstat -h and iqsl tools will read 11.0, 11.1 and 11.2.

However, if you need to make a gbak backup of your database, in order
ro restore it as ODS 12 under Fb 3, you will need to run the backup on
the actual Firebird server version that created it.

>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.

> I’m not sure if that means the connection was successful or unsuccessful.

 It means neither.  The CON> prompt there means isql is waiting for a
semi-colon, which is isql's line terminator.  But that is not a valid
CONNECT statement you have there, anyway, even with the semi-colon.
If you supply the user and/or password arguments to the CONNECT
statement, the syntax is:

SQL> CONNECT 'localhost:employee' USER sysdba PASSWORD 'masterkey';

Note that employee is an alias for
c:\programs64\firebird_3_0\examples\empbuild\employee.fdb. Read up
about database aliases - they are very friendly to have around.

As you did it, in Fb 3, with an embedded connect, you don't need
the PASSWORD argument at all.  You will need the USER argument as,
otherwise, you will be logged in under your Windows user name, which
may not, at this point, have the permissions you need to access
objects in the database.

>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.

3050 is the default port so you don't need it.  But that URI looks
weird, anyway.

Try

"jdbc:firebirdsql://localhost:T:/Database/ejdb.fdb"

But it can't work if drive T: is not a physical drive wired onto the
server that hosts Firebird.  What I'm saying is that, if you have only
drives C:, E: and F: on the machine, your databases must be on the
native path of one or more of those, not on some mapped network
address.  So if you have drive T: mapped to some network or local
address then drive T: is NOT a phsysical drive.

May I suggest that, given your uncertainty about the properties of
your databases, you uninstall Fb 3 and install v.2.5?
And don't try to run before you can walk.  Use isql or some Firebird-dedicated
third-party tool, rather than one from "out there" that treats all
database engines as created equal.

HB

Re: [firebird-support] Trouble establishing a connection to Firebird database files.

[Justis Root justis.r...@gmail.com [firebird-support]]

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.
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.

Thank you again for your time,
- Justis

Re: [firebird-support] Trouble establishing a connection to Firebird database files.

[Helen Borrie hele...@iinet.net.au [firebird-support]]

Monday, November 27, 2017, 11:35:47 PM, Justis wrote:

> I’m running the latest version of Firebird on my windows PC, and
> I’ve got some .fbd files on my F:// Drive.
> I’m trying to connect to them via Firebird’s JDBC driver, but I’m getting 
> absolutely nothing.

The JDBC driver is that - a driver.  It is for connecting a Java
application to a database, through the Firebird server.  Unless you
have such an application, you don't have a starting point.

> I’ve tried restarting firebird, the machine.

You don't have to restart Firebird or the machine if you fail to
connect.  Firebird will just keep waiting until to offer a connection
string it likes.

> This is my first time with Firebird, so I apologize if I’m a bit
> slow to understand where to even start with trying to explain what’s 
> happening.
> What should I be checking first?

Well, Java is only one driver out of many.  Your best place to start,
AFTER reading the Quick Start Guide that is in the doc directory of
your Firebird installation, will probably be with the isql
command-line tool.  It is a native application that doesn't need a
driver, as it its interface is stitched directly into the fringes of
the Firebird engine.

If you are a total newbie, you should also grab the isql manual from
the Firebird documentation library.

> What info am I missing from this description in order to make assisting me 
> easier?

If you read the guff and still can't connect, you can copy/paste any
error messages from isql into your next message to this list.  Then,
everyone will know what kind of help you need. If/when you do, tell us
what version of Firebird you are trying to use.  That really matters,
as Firebird 3 cannot connect to databases made by earlier Firebird
versions.

Also, provide the connection string you use to request the connection,
e.g.

localhost:f:\databases\mydb.fdb -user sysdba -password masterkey

For issues trying to connect an app with your database through the
JDBC driver, there is a dedicated list.

HB

Re: [firebird-support] Trouble establishing a connection to Firebird database files.

[Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]]

27.11.2017 11:35, Justis Root justis.r...@gmail.com [firebird-support] wrote:
> What should I be checking first?

   First of all, carefully read error message. It usually contain a reason of 
failure.

> What info am I missing from this description in order to make assisting me 
> easier?

   The message, preferable copy-pasted from isql.


-- 
   WBR, SD.






++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

[firebird-support] Trouble establishing a connection to Firebird database files.

[Justis Root justis.r...@gmail.com [firebird-support]]

Hey there,

I’m Justis contacting you in hopes of getting support with some database 
connection issues I’m experiencing.
I’m running the latest version of Firebird on my windows PC, and I’ve got some 
.fbd files on my F:// Drive.
I’m trying to connect to them via Firebird’s JDBC driver, but I’m getting 
absolutely nothing.
I’ve tried restarting firebird, the machine.
This is my first time with Firebird, so I apologize if I’m a bit slow to 
understand where to even start with trying to explain what’s happening.
What should I be checking first?
What info am I missing from this description in order to make assisting me 
easier?

Every moment of your time is appreciated.
Thank you in advance,
- Justis