Advertisement
Strange situtaion after a server upgrade - I can create odbc connections on both 32&64 bit clients and they test OK. However when users run an Access DB only the 64 bit pc’s connect, 32 bit pc’s report an odbc error.<\/p>\n
The new server is 64 bit but seems to be ok with the 32 bit connections as they test ok. Anyone got any suggestions?<\/p>","upvoteCount":2,"answerCount":9,"datePublished":"2013-02-14T10:26:33.000Z","author":{"@type":"Person","name":"gerard-treacy","url":"https://community.spiceworks.com/u/gerard-treacy"},"acceptedAnswer":{"@type":"Answer","text":"
Update - have not figured out why this happened but as a workaround I deleted all the linked tables and re-created them - everything working OK now.<\/p>","upvoteCount":0,"datePublished":"2013-02-19T08:30:39.000Z","url":"https://community.spiceworks.com/t/odbc-error-ms-access/194431/9","author":{"@type":"Person","name":"gerard-treacy","url":"https://community.spiceworks.com/u/gerard-treacy"}},"suggestedAnswer":[{"@type":"Answer","text":"
Strange situtaion after a server upgrade - I can create odbc connections on both 32&64 bit clients and they test OK. However when users run an Access DB only the 64 bit pc’s connect, 32 bit pc’s report an odbc error.<\/p>\n
The new server is 64 bit but seems to be ok with the 32 bit connections as they test ok. Anyone got any suggestions?<\/p>","upvoteCount":2,"datePublished":"2013-02-14T10:26:33.000Z","url":"https://community.spiceworks.com/t/odbc-error-ms-access/194431/1","author":{"@type":"Person","name":"gerard-treacy","url":"https://community.spiceworks.com/u/gerard-treacy"}},{"@type":"Answer","text":"
Hi Gerard.<\/p>\n
What is the error reported on the 32bit PC’s?<\/p>","upvoteCount":0,"datePublished":"2013-02-14T11:00:39.000Z","url":"https://community.spiceworks.com/t/odbc-error-ms-access/194431/2","author":{"@type":"Person","name":"itsolutioncentrecouk2647","url":"https://community.spiceworks.com/u/itsolutioncentrecouk2647"}},{"@type":"Answer","text":"
Just ‘ODBC connection error’<\/p>","upvoteCount":0,"datePublished":"2013-02-14T11:03:50.000Z","url":"https://community.spiceworks.com/t/odbc-error-ms-access/194431/3","author":{"@type":"Person","name":"gerard-treacy","url":"https://community.spiceworks.com/u/gerard-treacy"}},{"@type":"Answer","text":"
Are you using a system DSN connection to one set up on the server or a local one?<\/p>","upvoteCount":0,"datePublished":"2013-02-14T14:21:49.000Z","url":"https://community.spiceworks.com/t/odbc-error-ms-access/194431/4","author":{"@type":"Person","name":"rockn","url":"https://community.spiceworks.com/u/rockn"}},{"@type":"Answer","text":"
It is a System DSN set up on the client PC. Everything works fine with the old server (32 bit) and when switched to the new one the test connection works. Can’t see any reason for this to fail with Access.<\/p>","upvoteCount":0,"datePublished":"2013-02-14T15:34:26.000Z","url":"https://community.spiceworks.com/t/odbc-error-ms-access/194431/5","author":{"@type":"Person","name":"gerard-treacy","url":"https://community.spiceworks.com/u/gerard-treacy"}},{"@type":"Answer","text":"
Is there such a thing as a 64-bit ODBC driver? Anything in the logs to indicate why it is not connecting from a 32-bit OS (checking both server side and client side logs)<\/p>","upvoteCount":0,"datePublished":"2013-02-14T15:48:17.000Z","url":"https://community.spiceworks.com/t/odbc-error-ms-access/194431/6","author":{"@type":"Person","name":"rockn","url":"https://community.spiceworks.com/u/rockn"}},{"@type":"Answer","text":"
Yes there is a 64bit ODBC, and it is connecting correctly on the 64bit machines. It is the 32bit one that is failing to allow Access to connect. What logs are there on the server side?<\/p>\n
Anyone got any other ideas?<\/p>","upvoteCount":0,"datePublished":"2013-02-15T20:25:25.000Z","url":"https://community.spiceworks.com/t/odbc-error-ms-access/194431/7","author":{"@type":"Person","name":"gerard-treacy","url":"https://community.spiceworks.com/u/gerard-treacy"}},{"@type":"Answer","text":"
Server side application or system event logs and the same logs on the client side. The only change has been putting the database on a 64-bit server OS?<\/p>","upvoteCount":0,"datePublished":"2013-02-15T20:52:18.000Z","url":"https://community.spiceworks.com/t/odbc-error-ms-access/194431/8","author":{"@type":"Person","name":"rockn","url":"https://community.spiceworks.com/u/rockn"}}]}}