How do I tell the compiler to use the 32 bit ODBC driver when compiling a VB6 program in a 64 bit machine, W7.

When compiling it comes up with several SQL errors but does not offer any other info. When running the program it comes up with a "file not found" error without further info. It appears as though it is using the VB6 - 64 bit sql connection rather than the odbc connection.

I have a former VB 6 compiled...