I am trying to make a legacy Btrieve database available for searching from a Lotus Notes database (there is no Web interface on either system). I have tried to install software that should include a btrieve driver (Pervasive SQL), but I couldn't seem to configure a connection. Any ideas how to access btrieve? Where to get the ODBC drivers?
On a separate system, I converted an unsupported legacy SQL database as a Notes database using ODBC connections and LotusScript, but the Btrieve database is eluding me. I was hoping to not convert the Btrieve database and simply make it searchable instead, but I can't seem to get a driver to work, so it's kind of a moot point which way to go. I look forward to hearing from you.
I probably don't need to tell you this, but you've hit the classic integration challenge: getting an ODBC driver installed properly and using it to perform a successful query. The Pervasive.SQL driver should provide you with the functionality you're seeking and then some. I suggest that you work with their technical support resources to ensure that the driver is installed properly and that you can use a standard SQL query tool to select data from the Btrieve file structure. Once you can successfully query data then try your search functionality in the Lotus Notes database again.
Related Q&A from Scott Lemieux
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.