Database Connection With Firebird, Error Extracting Metadata

jed_uretlguy

• March 10, 2012 00:00

• Answered

Follow

Hello there,

I just installed Fishbowl Inventory to manage my supply or inventory, and I was using Clover to pull data from it.
The exact location of my data is found here:

C:\Program Files\Fishbowl\database\data\EXAMPLE.FDB

Fishbowl is using Firebird for its database.

In my Clover, for creating the DB connection, I put there in the URL this value: jdbc:firebirdsql:localhost/3050/C:\Program Files\Fishbowl\database\data\EXAMPLE.FDB

When testing the connection, it says connection is valid, but when I'm about to extract my metadata, I am getting this connection error message: "For input string: "3050/C"".

Can somebody help me why I couldn't extract my metadata where in the first place it says connection to my database is valid.

I would appreciate any reply to this email sooner.

Thanks,

• 

  admin

  • March 12, 2012 10:25

  0

  Comment actions Permalink

  Hi jed_urETLguy,
  
  it looks like escaping issue. Please try something like: jdbc:firebirdsql:localhost/3050/C\:\\Program Files\\Fishbowl\\database\\data\\EXAMPLE.FDB
• 

  jed_uretlguy

  • March 12, 2012 13:46

  0

  Comment actions Permalink

  kubosj,
  
  I really appreciate your reply to my post, however it didn't work still. But I do figured out how should that supposed to look like:
  
  Instead of: jdbc:firebirdsql:localhost/3050/C:\Program Files\Firebird\Firebird_2_1\examples\empbuild\EMPLOYEE.FDB
  
  The correct url should be: jdbc:firebirdsql:localhost/3050:C:\Program Files\Firebird\Firebird_2_1\examples\empbuild\EMPLOYEE.FDB
  
  So, to make it work, replace "/" between 3050 and C with ":", and that's fully functioning now.
  
  Thanks,

Please sign in to leave a comment.