Crystal to Btrieve Database

We have an end user trying to connect a Crystal Report (version 11) to an old Btrieve 5.0 database.   On one station he has the "btrieve" file type available and the report(s) work fine.   On the second station there is no Btrieve file type, but he can use the "databases" file type and pick the DDF file.  When he does this he gets "unknown database connector" when he does a refresh on the report.

How do I get the "Btrieve" option to show up on the list of database choices?
ClassicCanadaAsked:
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.

Bill BachPresident and Btrieve GuruCommented:
Btrieve 5.0 had no ODBC driver.  As such, you have two options:
1) Some versions of Crystal Reports included their own Btrieve-level driver that might work.  However, most recent versions did NOT install this as a default, so you may have to re-run the CR setup utility to add this functionality.

2) If you have a newer version of Btrieve or Pervasive.SQL available, such as from another application like PeachTree, Macola, MAS90, or other such application, then you may have a newer ODBC driver available as part of the Pervasive database engine.  If that's the case, then use the ODBC driver that came with that environment instead.

For some white papers on how to set this up, and on how to find your database version, see http://www.goldstarsoftware.com/press.asp.
0
ClassicCanadaAuthor Commented:
We solved the problem with a small number of DLLs and the w32mkde.exe file that were on the "working" machine.

Once those were in the folder on the new machine Crystal started to work again.
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
Crystal Reports

From novice to tech pro — start learning today.