Crystal reports with Visual Foxpro 9, failed to load database information

[former_member958523]

When we recently upgraded a machine to Windows 10 an old application stopped working. The application is written in Visual Foxpro and uses Crystal Reports.

The error reported is:

"Failed to load database information

Details: The database connector crdb_p2bxbse.dll could not be loaded..." as below:

The application can load the Crystal application but crashes when it tries to output the file to a Word document.

I have tried copying versions of crdb_p2bxbse.dll to the application folder and to the Windows\System32 folder but to no avail. The versions of crdb_p2bxbse.dll I have are dated 2003 and 2017.

I have tried Crystal Reports V9 and V11 to no avail.

Any pointers would be appreciated.

Thank you

Martin

[DellSC · Accepted solution]

You also need to install the Foxpro ODBC driver, which you can get from here: https://docs.microsoft.com/en-us/sql/odbc/microsoft/setting-up-the-visual-foxpro-odbc-driver?view=sq.... The crdb_p2bxbse.dll covers Crystal's ability to work with Foxpro data but is not the actual database driver.

-Dell

[former_member958523 · Accepted solution]

Thank you for coming back to me. It's a while since I've had to set up ODBC for Foxpro, but it brings back memories. The problem I have when I try to set it up is that when I try to add the Foxpro ODBC, it's not included in the list.

Unfortunately the link you gave led me to a dead end because Microsoft no longer support ODBC for Foxpro. I found some other information but I'm continuing to search but if you have any other suggestions, it would be appreciated.

[former_member11696]

Hi Martin,

You have more problems than just the FoxPro database client not being available.....

The error indicates you are using the old RDC or the Embedded Report Designer craxddrt.dll.

That dll is only installed into Visual Studio 2010->2019 and can only be used within Visual Studio itself, you are no longer licensed to distribute the file and it's not included in any of the distribution MSI packages.

I think your only option now is to convert your app to .NET and use the Crystal Reports for Visual Studio runtime from here:

https://wiki.scn.sap.com/wiki/display/BOBJ/Crystal+Reports%2C+Developer+for+Visual+Studio+Downloads

Also, as of CR 2011 we no longer install the SDK packages with Crystal Reports Designer, it's all from the above link and only SDK supported, unless you want to convert to Java.

There are a couple of samples C# projects on the wiki page to get you started.

If you were using the Embedded Report Designer now you'll have to write your own using the RAS components to be able to use Report Creation API's.

Good luck

Don