I've been setting up a Quaratine Manager server, in order to test and deploy on our network in order to improve our Spam management and control. I've been testing it using a separate SQL server, and have ran into quite a few issues, which, I have so far been able to work past, but I have reached an impasse.
When I enter the database details and run a test, I recieve a "Data Source Name Not Found error and no default driver specified" error message. I have confirmed the DSN connections exist, and. as was mentioned in my investigation, have confirmed that these exist for the ODBC connection which WoW uses as well as the usual settings.
Another fix that was suggested was to enable 32 bit applications in the application pool, but this causes the DBManagementUI to become unavailable.
Are there any known issues regarding this, and are there fixes for this, or can anyone offer an insight?
i have installed Microsoft SQL Server 2012 Native Client (packege for x64) before to test connection do SQL Server 2012....
I cannot remember which exact version I installed, but I remember I tried several different. Have you tried x86 and perhaps the SQL Server 2008 R2 NC?
Use the version of native client.
with software linked by you i have fixed the issue. Strange but true, to use MQM eith SQL 2012 I have had to use Natice Client x64 for SQL 2005
We saw some issues in support with the SQL 2012 Native Client which a hot fix is available HF1007572 if you contact support and open a SR they will be able to provide you a copy.