32Bit ODBC DSN "Server does not exist or access denied" but 64 bit ODBC OK connecting to SQL Server 2014

Question

Using a new SQL Server 2014

Connecting via 32bit ODBC fails giving the error "Server does not exist or access denied"

Connecting via 64 bit ODBC is successful

What might cause this?

Did you verify that the 32bit DSN actually exists on the machine? 64bit DSNs would be configured via C:\Windows\System32\odbcad32.exe while 32bit DSNs would be configured via C:\Windows\SysWow64\odbcad32.exe. — , Jun 17 '15 at 12:27

score 0 · Accepted Answer · answered Jun 17 '15 at 13:43

0

Firewall issue! Disabling the firewall allowed the 32bit DSN to work

answered Jun 17 '15 at 13:43

ZZ9

1 Answers1