Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 odbcad32 DSN to SQL Server from Windows 7 fails

Author  Topic 

uughaze43
Starting Member

1 Post

Posted - 2010-05-26 : 04:27:58
I am attempting to setup a 32bit ODBC DSN from my Windows 7 X64 PC to SQL Server 2005 (local or on network, x64 and X86). I get the following error:-

SQL Server Error 0
[Microsoft][ODBC SQL Server Driver][DBNETLIB]Connection Open SECCreateCredentials(). Connnection Failed; SQLState 08001 SQL Server Error 18 [Microsoft][ODBC SQL Server Driver][DBNETLIB]SSL Security Error

Attempting using the 64bit ODBC Administrator and it works okay!?!

The 32bit ODBC Administrator works fine from Windows XP (x86), Windows Server 2003 (x86 and x64) and Windows Server 2008 (x64). Not sure what is different about Windows 7?

Any assistance/advice appreciated.
   

- Advertisement -