Setting up Easysoft 7 ODBC connection to a Firebird database

Question for you guys,

Is it possible to create an ODBC system DSN using the Easysoft driver for a Firebird database running on Redhat Enterprise Linux?

The reason I ask is that we did a project using Firebird and JSP on the Linux machine a while back and now we need to connect to the database using ODBC.

I have tried using a few different connection string and it has failed to connect each time.

If anyone has any suggested connection strings that would be helpful.  I'd settle also for someone saying it's impossible and pointing me in the right direction.

Thanks in advance.
corahealthAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Nick UpsonPrincipal Operations EngineerCommented:
It's certainly possible as I've done it. I won't be where I can examine it until this evening (6+ hours from now)

If you hit the test button on the dsn does it work? What doesn't work the dsn or the jsp connection string?
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Nick UpsonPrincipal Operations EngineerCommented:
This is the connection string I use (from a language called Panther). "Interbase" is the name of the dsn (historical)

DBMS WITH ENGINE odbc DECLARE interbase
      CONNECTION FOR USER "userid" PASSWORD "password"
      DATASOURCE "Interbase" CONN_STRING "CACHE 500"

what user and password are you using?
0
corahealthAuthor Commented:
I wish this was JSP, I wouldn't be having a problem then.

This is for one of the managers in my department.  He had to reinstall XP after a bad crash and lost all of his DSN info.  We had a connection set up on his old system to the Firebird database so he could run reports.  We thought we could recreate it, but we're having a bear of a time.

We are trying to ise the Easysoft Interbase driver to establish an ODBC connection to the database.  I've tried various connection paths but they have all failed.

Here is an example:

//10.8.1.12//opt/interbase/data/TRACKER.gdb

Whenever I test it it gives "the system cannot find the file specified".  The frustrating thing is I know we have been able to connect before, but now it won't.
0
Nick UpsonPrincipal Operations EngineerCommented:
as it's on a unix platform I'd have expected something more like this

10.8.1.12:opt/interbase/data/TRACKER.gdb

Please also check the case of the "TRACKER", if the file is "tracker" it won't be found
0
Nick UpsonPrincipal Operations EngineerCommented:
I've suddenly realised that your connection string is for a shared drive. DON'T DO IT

There was a long standing bug in interbase such that connecting as a shared drive could corrupt the database. Firebird
corrects the bug by not allowing you to do it. What you need to be doing is setting up a connection string that is passed
to the firebird server software on the linux machine which in turn connects to the database, the client machine never
needs to see the drive or file that is the database.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Databases

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.