Categories
Non classé

.Net C# Crystal Report / MySQL ODBC

Like many out there, I use Crystal Report for invoices and other kinds of report. What I like doing is exporting the result as a pdf on disk.

I just got a new laptop so I installed visual studio, mysql drivers,crystal report, etc…

If you have used Crystal Report for a while, you might have seen errors that are not so obvious. Let’s take that one.

System.Runtime.InteropServices.COMException (0x80004005): The system cannot find the path specified

You expect the problem to be related to the folder you’re trying to write to. Maybe something related to permissions.

So you check and everything is fine.

The problem might not be the folder.

If your application is running in “Any CPU” and you are on a X64 machine, be aware that Crystal Report will be in 64 bit mode so it will try to use an 64 bit odbc connection which it might not find because you created it in 32 bit mode. Doh !