Migrate ODBC from 32 bit 2003 server into 64 bit 2008 server for 32 application RRS feed

  • Question

  • Hi Tekgroup,

    We have upgraded our server from 32 bit 2003 server to 64 bit 2008 server and our client application is 32 bit version. Since there are 100's of system DSN created on 2003 32 bit server and we cannot create one by one manually, I would need your suggestion to migrate it more efficiently into 2008 64 bit machine and my 32 bit application should be access it. I have tried Import and Export option but still its throwing error message as "[Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application".

    Also I am wondering why the 32 Bit application is trying to lookup 64 bit driver on 64 bit server ? I suppose it should try to connect using 32 bit driver. Please advise.

    Earliest response would be greatly appreciated. 


    Thursday, September 25, 2014 6:56 PM