Both Laptops have:
Windows 7 64 bit
I have a working query. From one Windows 7 64-bit laptop, I can run the query no problem. I tried to set up ODBC on another laptop and run the same query. It gives me an error - "the specified dsn contains an architecture mismatch between the driver and application".
I verified 64-bit odbc (under system32) and made sure System DSN is blank. I also verified 32-bit odbc (under (syswow64) and deleted an existing one in System DSN and recreated a new one. I rerun the same query, but got the same error above.
Can anybody know why and how to fix it? I appreciate your advice in advance. Thank you.