Unable to open Database

[2969]

hi

I am using Crystal Report 8.5 (Crystal report engine objecty lib cpeaut32.dll). I get "Unable to Open database error). The same code, same report does not works on some machines but works on others. There is no sub-report being called from this report.

Any ideas.??what can i check

 

[synapsevampire]

Perhaps you should state the type of database and the connectivity being used?

Is this from Crystal itself, or a distributed application?

This could be related to MDAC, the OS or a range of other possibilities, including permissioning.

When asking about databases, remember to at least include the type and your connectivity.

A common problem is that people will use Oracle's ODBC driver instead of the Crystal supplied one, but there are so many possibilities.

-k

 

[2969]

i m using fox pro6 as database, and connecting to the rpt thru ODBC. I am passing a recordset in my app to the crystal rpt (CPEAUT32.dll) for it to view and print

 

[synapsevampire]

It's been quite some time since I coded in Fox, but I'd be suspect of MDAC or the ODBC if it happens on just some machines.

You might also consider writing your Fox app the way Crystal suggests by using the RDC rather than the print engine.

Here's a blurb on it, and there are plenty more on the web:

http://www.ml-consult.demon.co.uk/foxst-19.htm

-k

 

[2969]

hi,

i observed that all the other rpts on this machine work all the fine but for this one. So that means MDAC or ODBC work just fine.

I have checked all ttx file compatibilitties also but dont know what more to look at.

any other ideas