Solved

Question about connection to database using jaybird and flamerobin

Posted on 2006-11-20
5
1,112 Views
Last Modified: 2013-12-09
These might be 2 similar answers so i am going to ask both here.

1.
If i want to connect to a remote database on a windows machine how would i put the connection string for jaybird
jdbc:firebirdsql:native://host[:port]/path/to/db.fdb

However i can't seem to make a connection with this setup
I have a computers say it's called inventory
The database file is c:\Database\db.fdb

jdbc:firebirdsql:native://inventory:3050c:\Database\db.fdb

this does not seem to work

2.
I have a similar problem with flamerobin
I click on server on the menu bar and i register server
entering as the hostname -- \\inventory
enter the port as -- 3050

Then i click on that server and click register database
I put as the database path -- c:\Database\db.fdb
Then i enter the password and user and nothing i get a 334455375

0
Comment
Question by:ethnarch
  • 3
5 Comments
 
LVL 2

Author Comment

by:ethnarch
ID: 17981564
ok i figured out the flamerobin problem

Server settings
   Host -- inventory
      not \\inventory
   port 3050

database Settings
   path -- c:\Database\db.fdb
   pass -- password
   user -- username

now i am just having problems with the jdbc jaybird driver
0
 
LVL 2

Author Comment

by:ethnarch
ID: 17982648
And now i figured out the jdbc problem

the correct format that worked for me was
jdbc:firebirdsql://inventory:3050/c:/Database/db.fdb
0
 
LVL 2

Author Comment

by:ethnarch
ID: 18000274
yes i did, i also asked for this question to be closed but i guess they didn't get around to it so oh well
0
 
LVL 1

Accepted Solution

by:
kodiakbear earned 0 total points
ID: 18004356
Closed, 250 points refunded.
kb
Experts Exchange Moderator
0

Featured Post

Free Trending Threat Insights Every Day

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

Introduction: I have seen many questions on EE and elsewhere, asking about how to find either gaps in lists of numbers (id field, usually) ranges of values or dates overlapping date ranges combined date ranges I thought it would be a good …
Entity Framework is a powerful tool to help you interact with the DataBase but still doesn't help much when we have a Stored Procedure that returns more than one resultset. The solution takes some of out-of-the-box thinking; read on!
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

757 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now