Setting up Easysoft 7 ODBC connection to a Firebird database

Posted on 2004-11-16
Last Modified: 2013-12-09
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.
Question by:corahealth
    LVL 19

    Accepted Solution

    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?
    LVL 19

    Expert Comment

    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?

    Author Comment

    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:


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

    Expert Comment

    as it's on a unix platform I'd have expected something more like this

    Please also check the case of the "TRACKER", if the file is "tracker" it won't be found
    LVL 19

    Expert Comment

    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.

    Featured Post

    Top 6 Sources for Identifying Threat Actor TTPs

    Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

    Join & Write a Comment

    CCModeler offers a way to enter basic information like entities, attributes and relationships and export them as yEd or erviz diagram. It also can import existing Access or SQL Server tables with relationships.
    Shadow IT is coming out of the shadows as more businesses are choosing cloud-based applications. It is now a multi-cloud world for most organizations. Simultaneously, most businesses have yet to consolidate with one cloud provider or define an offic…
    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…

    733 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

    20 Experts available now in Live!

    Get 1:1 Help Now