[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 935
  • Last Modified:

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.
0
corahealth
Asked:
corahealth
  • 4
1 Solution
 
NickUpsonCommented:
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
 
NickUpsonCommented:
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
 
NickUpsonCommented:
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
 
NickUpsonCommented:
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

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now