Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Getting information out of Interbase through BI-tool 1

Status
Not open for further replies.
blom0344

blom0344

Technical User
Joined
Mar 20, 2002
Messages
3,441
Location
NL
I noticed very few active participants on this forum, so perhaps there is an expert to exchange info directly.

My problem (working with DB2/ORACLE) is that Interbase related data is so scarce. I want to use a BI-tool (Business Objects) to use directly on a P&O database that runs on an interbase database. We know nothing about it, though it runs for years without ever needing attention. (quite something I guess)

We are talking about a late 5 version of the database. We can only read info from it (through the bought application), we are not authorized to change or add to the database design. There must be ways to use ODBC to reach the database, but info is hard to get

Anyone of you any ideas?

T. Blom
Information analyst
tbl@shimano-eu.com
 
Sort by date Sort by votes
What is your exact question?

Do you want to access the InterBase database directly?

Martijn Tonies
Database Workbench - the developer tool for InterBase and Firebird
 
Upvote 0 Downvote
Yes, We want to be able to directly extract data from the database using ODBC. (In this case we want to use Business Objects to draw data from the interbase database and combine it at report-level with other data)

We report on DB2/ORACLE/SQL Server on a daily basis with a variety of tools, but Interbase is something new to use. The application runs, apperently there is a database we should be able to get into.

But how?

Do you have any suggestions?


T. Blom
Information analyst
tbl@shimano-eu.com
 
Upvote 0 Downvote
Do you have an InterBase ODBC driver? If not, you can download a good one here:

Next, you need to find out where the database resides - unlike MS SQL, Oracle or DB2, InterBase does not have a central repository with available databases, but expects the client application to know where the primary database file is.

A "connect string" (for TCP/IP) can look like this:

<server>:<path><primary_datafile>

eg:

my_server:d:\data\app\mydatabase.gdb

Notice that &quot;gdb&quot; can be anything, but this used to be the default extension for InterBase < v7.


Martijn Tonies
Database Workbench - the developer tool for InterBase and Firebird
 
Upvote 0 Downvote
Hello Martijn,

I finally got authorization to access the interbase database using ODBC for read-only purposes.
I downloaded the easysoft driver: ib6-2_0_22-windows-x86.exe
, but when installing it gives an error-message about a dll that it cannot locate: gds32.dll

Is a interbase client required to get ODBC working?

T. Blom
Information analyst
tbl@shimano-eu.com
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

DBMyself
  • Locked
  • Question Question
Interbase user connection limit
Replies
0
Views
697
DBMyself
DBMyself
RFBCAN
  • Locked
  • Question Question
Recursivity (Interbase).
Replies
0
Views
516
RFBCAN
RFBCAN
Tman60
  • Locked
  • Question Question
Remotely accesing interbase applications
Replies
0
Views
565
Tman60
Tman60
tirf
  • Locked
  • Question Question
help on interbase database
Replies
0
Views
531
tirf
tirf
ale2
  • Locked
  • Question Question
Interbase Server did not start within the expected time_any solution
Replies
0
Views
479
ale2
ale2

Part and Inventory Search

Sponsor

Back
Top