Print Page | Close Window

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: http://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=7010
Printed Date: 14 December 2017 at 3:12am


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.  Thumbs Up


-------------
Tradaweb Ltd

PO Box 30

St Neots

Cambridgeshire PE19 7GF

UK

http://www.tradaweb.co.uk" rel="nofollow - http://www.tradaweb.co.uk



Print Page | Close Window