We have three PC's using Sage and using ODBC to access the sage data in Excel and Access. The PC's are identical: hardward, OS, everything. Two work fine using teh 32 bit ODBC. One, which happens to be the Sage Data server, will not allow the ODBC connection. The error is: ODBC: ERROR [IM014] The specified DSN contains an architecture mismatch between the Driver (32-bit) and Application (64-bit)
I think its old news that we have to use the 32 bit ODBC -and that's what works fine on the other two PC.s Any ideas why this PC is showing the error?
Thanks,