Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Help! CRAXDRT Error with UNC paths in ASP/Crystal/Btrieve

Status
Not open for further replies.

cheerfulskeptic

Programmer
Feb 3, 2003
88
IN

I am using Crystal 7.
ODBC is very slow to the Pervaisve SQL server 2000, so I decided to switch to the Crystal Btrieve Driver. Performance within Crystal was significantly improved. Here is my report structure

Main Report
3 groups of fields
innrmost group, account ID has a subreport in the group footer

the subreport contains the report data connecting to Pervasive SQL. Just one table, Invoice Detail (We're using MAX).

Here's the problem: in the subreport, I then specify the f:\MAx\sales\file.ddf location as the definition location.
The database table location (just 1 table) is f:\max\sales\invdet.dat alias Invoice_Detail.
Everything works great inside crystal. I used Recrystallize Pro to generate the ASP to display the report, but when I use the web activex viewer to view it, it gives me a CRAXDRT error. If I dont trap it, I get an ASP error saying "server threw an exception".

here's my logon info in my asp file:
crtable.SetLogonInfo cstr("f:\max\sales\field.ddf"), cstr("Invoice_Detail"), cstr(""), cstr("")
I even tried changing this code to UNC naming, ie, \\SPIRIT\MAX\SALES\field.ddf and \\SPIRIT\MAX\SALES\invdet.dat and changed to UNC inside crystal as well.. Same issue...

What am I doing wrong?
thanks!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top