Turns out it was a DSN driver issue ie 32 vs 64 bit windows. After prompting the client fixed the DSN and everything is now OK. Sorry for the noise.
On 5 May 2016 at 19:21, Vernon D. Cole <vernondc...@gmail.com> wrote: > More information about your program would be helpful. There are at least > three ways that connections to SQL Server might be obtained in Python. In > general, it would seem that the version of Python may have changed. The > bit-width of the SQL Server server should not affect a data client. > > > On Thu, May 5, 2016 at 3:18 AM, Robin Becker <ro...@reportlab.com> wrote: >> >> A client has changed database and now receives this error >> >> >> dbi.internalError: [Microsoft][ODBC Driver Manager] The specified DSN >> contains an architecture mismatch between the Driver and Application in >> LOGIN >> >> >> I suspect that this is due to something related to >> >> >> https://social.msdn.microsoft.com/Forums/sqlserver/en-US/702f0d9b-6cb9-49cf-9953-80d059711e60/the-specified-dsn-contains-an-architecture-mismatch-between-the-driver-and-application?forum=sqlgetstarted >> >> but can anyone explain what should be done to fix this? >> >> I have asked concerning the db machine 32/64bit etc etc and whether the >> python software is running on 32/64 bit python. >> >> -- >> Robin Becker >> _______________________________________________ >> python-win32 mailing list >> python-win32@python.org >> https://mail.python.org/mailman/listinfo/python-win32 > > -- Robin Becker _______________________________________________ python-win32 mailing list python-win32@python.org https://mail.python.org/mailman/listinfo/python-win32
