Question Re: Data Access for .dbf data in Technology Q&A

Data Access for .dbf data

Former Member — Thu, 12 May 2011 20:40:42 GMT

I am new to crystal reports and am trying to create reports using database .DBF files used in a POS program that my company uses. When I try to access them a dialogue box opens and requires a user name and password. I have checked with the database company and they do not have any special user name or password to access their data. I also have another editor program that I use to access the data all the time. I also went into programs/features and modified the program by turning on data access for those files. Is there some other way to solve this?

Re: Data Access for .dbf data

former_member11696 — Thu, 12 May 2011 21:46:21 GMT

Hello,

What happens if you simply click OK without entering anything in? if not an option or it won't let you then we need to know what version of CR you are using and any patches installed?

You may want to try using/creating an ODBC System DSN to your DBF files as a work around.

Thank you

Don

Re: Data Access for .dbf data

Former Member — Fri, 13 May 2011 13:57:24 GMT

I did try pressing enter with blank user name/ password fields and it was the same result--no access. The version I am using is 2011.

Colin

Re: Data Access for .dbf data

former_member11696 — Fri, 13 May 2011 14:36:54 GMT

That helps.... I tested it also in CR 2011 and I too get an error when trying to connect to the DBF file using the native Database drivers. I then created an ODBC DSN using the MS DBF driver and it worked.

Please test also. I'm checking with the PM to see if this is supported any more through our native connector. It may be the dll p2bxbse is missing from the deployment/install package.

Thank you

Don

Update: Discovered this does work with SP1 for CR 2011. I've asked our SDN people to add this to our download page.

Edited by: Don Williams on May 13, 2011 7:54 AM

Re: Data Access for .dbf data

Former Member — Fri, 13 May 2011 14:57:34 GMT

Thanks for your help. I will give it a try.

Colin

Re: Data Access for .dbf data

former_member11696 — Sat, 14 May 2011 16:29:48 GMT

I see we have the download pages updated now....

Here's the link for SP1: https://smpdl.sap-ag.de/~sapidp/012002523100007683092011E/cr2011sp1.exe

Thanks again

Don