xBase error trying to distribute a Crystal Report...

[tommy19]

Howdy,
Would anyone know why I get an xBase error that says file cannot be opened? and another that says invalid handle? The distribution expert won't allow me to connect to the database. I can refresh the report from my computer but can not get the report to distribute. I was getting Dictionary " etc file" does not exist errors, but I recreated my report and it can now find the files. But it still will not let me distribute. Please help!

tommy19

 

[kenhamady]

What is the data source of the report?
When does the error occur? Ken Hamady, On-site/Phone Crystal Reports Training/Consulting
Quick Reference Guide to using Crystal in VB

http://www.kenhamady.com/

 

[tommy19]

the data source is a .qry file that is on a network drive. The error shows wjen I try to use the distribution expert.

 

[tommy19]

I have recreated the report so that the error messages do not pop up in the distribution expert, however the errors that say 'Dictionary "g:/path/*.qry" not found' is popping up again after I run the setup.exe file on the non native machine.

the g: drive is my network drive.

To explain the report alittle better: I have created the report on my C: drive using about 10 different subreports that link a userid field. The data source is a query file that only has that field for the records I wish to be in the report. All of the query files are on the g: drive. If I run the *.exe file from my computer everything works. I am however, having big problems trying to get the report distributed to other machines.

Thanks for the help
tommy19

 

[kenhamady]

QRY's convert the data to Xbase internally.
QRY's are tricky with distribution, the target PC has to have the QRY.

The QRY has to have saved data, or it has to find the data in the same exact place as the source PC. Ken Hamady, On-site/Phone Crystal Reports Training/Consulting
Quick Reference Guide to using Crystal in VB

http://www.kenhamady.com/

 

[tommy19]

Would the fact that its an ODBC database have any affect?

 

[kenhamady]

QRY's only work with ODBC data, so the rules I listed should apply to all scenarios. By "same exact place" it could be the same DSN in the ODBC Admin., however, I have heard tha the exact same DSN sometimes misbehaves if the database is on a different server or in a different path. Ken Hamady, On-site/Phone Crystal Reports Training/Consulting
Quick Reference Guide to using Crystal in VB

http://www.kenhamady.com/

 

[tommy19]

Well just wanted to inform you incase you were unaware... With the correct paths the distribution still did not work. However, I found that a report created on Win98 OS can not be distibuted to Win 2000 Pro OS machine. Why this is I don't know but I thought maybe it would help someone else having a similar problem. The distribution worked perfectly when I tried it on another Win98 OS...

Ken, thanks for all the help!!!

tommy19

 

[kenhamady]

Have you tried compiling it on a Win2K?
Win2K is tricky with permissions, so it could be Win2K itself, or the change in OS.
Ken Hamady, On-site/Phone Crystal Reports Training/Consulting
Quick Reference Guide to using Crystal in VB

http://www.kenhamady.com/

 

[gacisa]

Hey Tommy:

I've got the same problem than you.
But i advertised that all my *.qry files that were running on Win 98 are not running on W2000 Pro.

If I make a new one qry file with SQL Designer I got the same error message: "xbase error".

I think the problem is the version of Crystal ( I got 7) but i´m not sure.
If you Know something else I'll thank you to post here.

 

[tommy19]

Well, I also have Version 7.0. I think that its either the verision or with somethings Win 2000 Pro is just funny. For example, Win 2000 also lost the deltree function in DOS? Why this is I am not sure. My company is going to upgrade to CR 8.0. If I find out anything new I'll let you know.

But what worked for me is use another win98 machine, if the same message comes up double check the path of your query file in the new machine and double check to make sure that all of your query files still open in SQL Designer

 

[gacisa]

Ok, I will try something else but i do not think i will get something rigth.

In fact, in a W98 machine I updated MDAC from 2.5 to 2.6 version and I got the same error message.

Then I changed the file 'sqlsrv32.dll' and put the old version (mdac 2.5) of this file and...it runs!!!

I think it is something with ODBC and this file.
On W2000 MDAC version is 2.6 or newer.

Upgrading to 8.0 seems to be the better action. 8(