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

[Former Member]

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.

[former_member142702]

Hi,

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

Regards,

Stratos

[Former Member]

Hi Efstratios,

I installed mysql-connector-odbc-5.1.5-winx64.msi which includes both 32 bit and 64 bit drivers.

When I click test on my System DSN it works fine, but Crystal Reports doesnt see it.

[former_member142702]

Did you setup your System DSN to use the 32bit driver?

Regards,

Stratos

[Former Member]

Hi Efstratios,

I only get the option of one mySQL driver when I configure my DSN, "MySQL ODBC 5.1 Driver 5.01.05.0 MYODBC5.DLL 18/08/2008".

If I Modify my MySQL ODBC connector install and remove the 64 bit driver I do not get the option of MySQL when setting up my DSN. This would sugges that tha 32 bit driver isnt being installed properly or isnt being used (even though I have selected it during the install).

[former_member142702]

Hi,

can you please try to download and inbstall only the 32bit version of the MySQL ODBC driver 3.51?

[http://dev.mysql.com/downloads/connector/odbc/3.51.html]

Regards,

Stratos

[Former Member]

Hi Efstratios,

I have installed this but still dont get a 32 bit drive roption. I've also uninstalled my 64 bit driver and installed the 32 bit driver and I do not get the option of MySQL when setting up a DSN.

[former_member142702]

This should be ok that you do not have an option to choose between 32 and 64bit since you have only installed the 32bit version. Are you able to see the DSN now?

Regards,

Stratos

[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.