can i use windows 32 bits software to connect 64bits mysql database ?
i have a windows 32bits software which connect to 32bits mysql database without any problem, but now my client want to upgrade the server to windows server 2008 64 bits, so my concept is that, i have to install the 64bits mysql in the server, my question is , how about the workstation with the 32bits software ? do i still use the mysql connector 3.51 to connect to the 64bits mysql database ?
No it is not necessary. The client is sending and receiving data in a certain format in order for the server to interpret and return results. So having a mix of 32 bit client and 64 bit client should be ok.