Crystal Report fails on German machine

[Former Member]

Hi all

We had someone trying our product on German Version of XP w/ SP2 and with German Version of MS Excel 2003 w/ SP3.

We use Crystal Report 10.0.0.533

Crystal Report is connecting through ODBC Excel driver (version Excel 97-2000, Read Only).

ODBC driver and Excel file that it points to are present and seemed to be OK.

The user gets following error message:

Crystal Report Viewer

Failed to open a rowset.

Details: 42S02:[Microsoft][ODBC Excel Driver] Das Microsoft Jet-Datenbankmodul konnte das Objekt 'extension Usage' nicht finden. Stellen Sie sicher, dass das Objekt existiert und dass die Namens- und Pfadangaben richtig eingegeben wurden.

According to the user, this means:

MS Jet datamodul couldnt find the objectu2026.please ensure that the object exists.

We had application being used by many people for a 3 or 4 years and no-one has had this problem.

The only difference that I can find is that he is using German verison of XP & Excel.

Has anyone else run into this?

Is this known problem?

Is there workaround?

Many thanks

Ranko

[former_member183750 · Accepted solution]

Please see the [Rules of Engagement|;

regarding answers to any queries.

You do not say how you distribute the Crystal Reports Runtime - msm is the only supported distribution method. Since the report uses ODBC, make sure that crdb_ODBC.dll is on the computer.

If the above does not help, for ease of troubleshooting, I'd recommend installing the CR designer on that computer and see if the report runs in that. You can download an eval of CR XI r2 from here:

http://www.businessobjects.com/products/reporting/crystalreports/eval.asp

or CR 2008 from here:

http://www.businessobjects.com/forms/default.asp?id=701600000009BXP

Ludek

[Former Member]

Hi all

I think that I have found the problem. To use Excel w/ ODBC driver, you have to define a name for the region of the Excel workbook that will be used by the driver. We create our Excel document from the template. The template is using cell-naming syntax R1C1, as opposite to more widely used A1 syntax.

Unfortunately, in German it is not R1C1 but Z1S1. The Names Add function does not generate exception but just silently fail so defined name that ODBC driver is using is never set.

I am planning to use Address function on Region to get proper syntax. I hope that I will get Z1S1 on the German system and R1C1 for the USA one. Has anyone tried this before? Is there a better way? (I do not want to change template to use A1 as I may break many other things doing this.)

Cheers

Ranko Lalić

[Former Member]

Hi Ludek

Everything indicates that this is MS Excel and MS ODBC driver issue. I am more then happy to send you email te file. (My posting was blocked when I try to share it)

It seems something is wrong w/ MS ODBC support for German version of Excel 2003 w/ SP3. This does not appear to be Crystal Report issue.

Again, I will try to conntact MS reagarding this & will share outcome on this thread if any.

Thanks

Ranko

[Former Member]

Thanks Ludek for your suggestions.

I got an Excel file from our German user & can replicate his problem generating report from it.

If I just copy and paste his data into a new Excel file, everything works fine.

So, either MS ODBC Excel driver does not work correctly with Excel file generated by German version of Excel, or Crstal Report has some issues w/ this set up. Is Unicode a problem? Though, there are no Unicode characters in Excel file. Maybe I am also forgetting to set up something?

If anyone else has run into the same problem, please, let me know how you solved it.

I will continue debuging. First I will try writing a test program that will directly access the file through ODBC driver. If that works, I will try installing the new versions of Crstal Report.

Anyway, whatever I find, I will post my finding here.

Cheers

Ranko

[former_member183750]

A bit strange... is there any security on that xls? I remember once getting an xls where part of the info was confidential, so "they" protected those rows with a password (I actually don't even know how to do this...). I wanted to format the xls differently, so I copied all the cells into a new xls, and voila, I could see the "protected" rows as well. I honestly did not want to hack it, it was just as simple as that. Could this be the issue here?

BTW., would you be able to share the xls with me? If so, I'll just ask one of the moderators here to give me the email address in your profile and contact you. (since I'm not a moderator yet, I don't see that info)

Ludek

[Former Member]

not answered