Help with locating file in Crystal 7 and Pervasive

[cheerfulskeptic]

Hello,
We are running MAX with Pervasive backend. Also we're deploying reports in Crystal Reports 7 over the web.
The problem is that when i use an ODBC connection using Pervasive ODB Client tool, the reports are SUPER slow. On another site, using Crystal 8 and ODBC to Pervasive us very fast.
I tried to convert the driver to ODBC, it asks me to specify the DDF Files. I browsed to the MAX server, under the Sales folder (which is the Pervasive database SALES), and I get 4 DDF files - Comment, fields, index and another file (dont recall which). Once i select one of these, it gives me an error saying that it cant find the file Invoice Detail. Invoice Detail is the name of the table we're pulling data from. Where can I find this, and what am I doing wrong.
thanks in advance!

 

[crystalreporting]

If you're converting your native Crystal reports to use an ODBC connection - then you will need to do the following. Select Database, Convert Database Driver. If the report is using Crystal's native driver, then the DLL will display as P2BBTRV. Select convert on next refresh, and choose ODBC. As soon as you do this, Crystal should bring up the ODBC window to allow you to select your DSN. The next step is to select Database, Set Location and crossreference each and every file in your report to the corresponding file name in the ODBC datasource. Once this is done, Crystal will verify all of the tables and give you messages to indicate they are correct. Lastly, check your table links as they will probably be wrong.

Peter Shirley

http://www.linkcorp.com

 

[ecichy]

When selecting the DDF files, use FILE.DDF. This should present a list of Tables defined for your application. The DDF's contain file name information which may or may not be correct. In Crystal, you have a Set Database Location function which should allow you to alter the physical location of the tables you want to access. There are a few different ways to store the file name within the DDF's. I usually put just the table name (i.e Invoice.db, or whatever extension your application uses) into the file name information. I usually place the DDF's in the same directory as the data. That way the assumption is that the tables are in the current directory, wherever that may be. Two other ways are to fully qualify the name (i.e. C:\SALES\Invoiced.db) or use UNC naming (i.e. \\server\volume\SALES\Invoiced.db). If this is the case, then the data must reside in those exact locations. If your application is installed on drive D: or in a sub-directory other than where the DDF's are looking for it, you will get the table not found error. Set up your report and before running it use the "Set database location" function to review where your data is. Modify the name before running the report.

 

[cheerfulskeptic]

Thanks for your help. However, I tried this...
the only Btrieve driver in Crystal 7 I see is pdctbtrv.dll. I selected field.ddf and then made the location of Invoice Detail to \\MAX\Sales\invdet.dat.
It works fine under crystal but I get a CRAXDRT error when viewing over the web...
I'm using hte following logon info in my ASP file that calls the report...

crtable.SetLogonInfo cstr("f:\max\sales\field.ddf"), cstr("f:\max\sales\invdet.dat"), cstr(""), cstr("")