You are using the 32 big ODBC DSN Data Source. You have to use the 64 bit one.

You are using the 32 big ODBC DSN Data Source. You have to use the 64 bit one.

From the Knowledge Base

Description

When executing a script that worked with prior version of Sage 100 ERP, the script returns an Error: "[Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application."

Disclaimer

Support

Sage Customer Support does not provide assistance for issues related to third party products or enhancements, hardware, report customizations, state or federal tax-related questions, or specific accounting questions. Please contact your Sage Business Partner, network administrator, or accountant for assistance. Please review this document for additional information on the scope of Sage Customer Support Services.

Cause

64 bit applications cannot access a 32bit DSN's and you are attempting to execute a 32 bit application/script with a 64 bit scripting application or vice-versa.

Resolution

   If the application or script is a 32 bit script that has worked with Sage 100 previously then it needs to be executed with the 32bit version of cscript, which is located in C:\Windows\SysWOW64\cscript.exe.

   If it's a 64 bit application access the 64 bit DSN it needs to use the cscript version, which is located in C:\Windows\system32\cscript.exe.

Thanks Louis. I will give that a shot.