Sage 100

Trying to run a vbs to get tracking #s from MAS and upload to web. Works fine on windows task schedule but when run manually from a 64bit workstation to a 32bit server the customer gets ""The specified DSN contains an architecture mismatch between the Driver and Application"" MS says ""To resolve this error, use the 32-bit odbcad32.exe to configure or remove the DSN"". Has anybody run into this or a similar situation?

Just today had an issue with FRX ... need to create the MAS DSN using the 32-bit ODBC. Use the odbcad32.exe in the windir\sys\wow64 folder instead of the normal ODBC Connection icon.

When I ran the odbcad032 exe it had SOTA DSN. Should I remove it and add it back?

No - that should have been there from the MAS client workstation install. Are you using that DSN for your process?

Was it a system or user dsn? Might be a mismatch there. Probably remove it, then reinstall the client as administrator.

Thanks, I'll try it on Monday.

This msg occurs when you're running a script external to MAS on a 64-bit machine that references a 32-bit DSN. I really don't know what the official correct way to deal with this is but what I do: Task Scheduler: In the Actions tab / New Program/script: C:\Windows\SysWOW64\Wscript.exe Add arguments: <path to VBS file which needs to be quoted if there's spaces> Start in: C:\Windows\SysWOW64 Shortcut: Target: C:\Windows\SysWOW64\Wscript.exe <path to VBS file which needs to be quoted if there's spaces> Start In: C:\Windows\SysWOW64

I believe @AlnoorCassim has the officially correct way to do this. If you are trying to run a script that accesses 32-bit resources and objects, you have to use 32-bit script host.