Windows Server 2008 Install
Printed From: LogSat Software
Category: Spam Filter ISP
Forum Name: Spam Filter ISP Support
Forum Description: General support for Spam Filter ISP
URL: https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=7010
Printed Date: 27 December 2024 at 10:16am
Topic: Windows Server 2008 Install
Posted By: Belvoir
Subject: Windows Server 2008 Install
Date Posted: 21 March 2012 at 6:10am
|
Is there a problem with Windows Server 2008? I have installed SF v.4.2.4.851 on a Windows 2008 server without apparent problem but when I come to create a connection string to a MySQL database I keep getting the same error:
Test connection failed because of an error in initializing provider.
[Microsoft][ODBC Driver Manager] The specifide DSN containes an architecture mismatch between the Driver and Application
I've tried every combination of MySQL Server 5.1 32bit and 64bit with MySQL Connector 5.1.10 32 bit and 64 bit and also MySQL Connector 3.51.30 64bit and 32 bit.
Am I doing something wrong or is there a specific combination of MySQL and ODBC Drivers I should be using?
Thanks for your help. ------------- Tradaweb Ltd PO Box 30 St Neots Cambridgeshire PE19 7GF UK http://www.tradaweb.co.uk" rel="nofollow - http://www.tradaweb.co.uk |
Replies:
Posted By: LogSat
Date Posted: 21 March 2012 at 4:59pm
|
That error usually occurs when you used the incorrect version of the odbcad32.exe which manages the 64-bit version of the driver instead of the 32bit one. Are you certain you used the c:\windows\sysWOW64\odbcad32.exe (correct version) and not the c:\windows\system32\odbcad32.exe (incorrect version)?
For the MySQL Connection, please try using the older 3.51 (32bit) rather than the 5.1, as we've received reports of incompatibilities from some users. ------------- Roberto Franceschetti http://www.logsat.com" rel="nofollow - LogSat Software http://www.logsat.com/sfi-spam-filter.asp" rel="nofollow - Spam Filter ISP |
Posted By: Belvoir
Date Posted: 23 March 2012 at 3:07pm
|
Thanks Roberto, that's got it!
I knew I must be doing something stupid.  ------------- Tradaweb Ltd PO Box 30 St Neots Cambridgeshire PE19 7GF UK http://www.tradaweb.co.uk" rel="nofollow - http://www.tradaweb.co.uk |