• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 837
  • Last Modified:

How do I access the Raisor's Edge database?

I am trying to determine how to connect to the Raisor's Edge database (.db file type) via an ODBC connection to use as a source for a potential data warehouse.  How would I go about accessing the data outside of the application UI?
0
zencos
Asked:
zencos
1 Solution
 
grant300Commented:
Blackbaud's website says that Adaptive Server Anywhere v5.5.04 is included with version 7 of the software.  Cripes, that's old "stuff".  The current release of ASA is 10.

If you have a running Raiser's Edge system, the database server should be started and you can configure an ODBC connection to it, assuming you kind find the drivers someplace.

If all you have is the .db file, you are going to have to find/scrounge a copy of ASA 5.5.04 to use with it.  ASA is a real database engine with a server component.  It is not like FoxPro, dBase, or the other file-databases where the ODBC driver can read the files directly.  You have to have a running engine to get at the data in the ASA .db file.  You then connect to the engine with ODBC.  This is sometimes confused by the fact that the ASA ODBC drivers give you the option to start and stop the database along with the connection.  This is useful when you are running by yourself on your local machine and don't want to configure the server to startup at boot time.

You can double check the version of the ASA database by using a Hex Editor and looking at the first couple hundred bytes of the .db file.  The version info should jump out at you.

Regards,
Bill
0

Featured Post

[Webinar] Improve your customer journey

A positive customer journey is important in attracting and retaining business. To improve this experience, you can use Google Maps APIs to increase checkout conversions, boost user engagement, and optimize order fulfillment. Learn how in this webinar presented by Dito.

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