Skip to Content
avatar image
Former Member

Cannot See ODBC System DSN's on Windows Vista 64bit in Crystal Reports 2008

Hi,

I have installed Crystal Reports 2008 on my Windows Vista 64 bit PC and have setup an ODBC connection to my mySQL box which I wish to report on.

Crystal Reports however does not see the ODBC DSN's which I have configured.

I have installed the product on a 32 bit Windows system with no problems.

Is there a solution to this?

Thanks.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Jul 15, 2009 at 08:14 AM

    Hi,

    did you install the 32bit ODBC drivers for MySQL on your Vista machine?

    Regards,

    Stratos

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      I have found the solutions;

      My ODBC drivers did in fact install. Microsoft, in all their wisdom, has 2 versions of odbcad32. A 32 bit and a 64 bit. They are both named odbcad32.exe.

      They put the 32 bit odbcad32.exe in the syswow64 directory. They put the 64 bit odbcad32.exe in the system32 directory. 32 bit apps will pick up the 32 bit registry setting and 64 bit will pick up the 64 bit registry setting. system32 comes before syswow64 in the system path so the 64bit software runs before the 32 bit software.

      So, when I manually ran odbcad32.exe in the syswow64 directory, I was able to configure my connections and everything worked fine.