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?
zencosAsked:
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.

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

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