So I have a Windows 7 x64 desktop here and I need to add an ODBC connection via the x64 ODBC tool. For whatever reason the SQL Server option is missing. Here is a screenshot: http://i55.tinypic.com/t893dv.png Never seen this before.

do you have SQL server installed on the desktop or is it on the LAN somewhere Windows MVP, XP, Vista, 7. Expanding into Windows Server 2008 R2, SQL Server, SharePoint etc. My page on Video Card Problems is now my most popular landing page. My Page on SSD is now #2. See my gaming site for game reviews etc. Developer | Windows IT | Chess | Economics | Hardcore Games | Vegan Advocate | PC Reviews

It's on the LAN.

http://social.technet.microsoft.com/Forums/en-us/category/sqlserverWindows MVP, XP, Vista, 7. Expanding into Windows Server 2008 R2, SQL Server, SharePoint etc. My page on Video Card Problems is now my most popular landing page. My Page on SSD is now #2. See my gaming site for game reviews etc. Developer | Windows IT | Chess | Economics | Hardcore Games | Vegan Advocate | PC Reviews

Well I posted it in here because out of the 50+ Windows 7 x64 boxes, this is the only one missing the sql server option in the x64 ODBC. x32 ODBC on the same PC is fine.

install the OS clean then from the sysprepped image Windows MVP, XP, Vista, 7. Expanding into Windows Server 2008 R2, SQL Server, SharePoint etc. My page on Video Card Problems is now my most popular landing page. My Page on SSD is now #2. See my gaming site for game reviews etc. Developer | Windows IT | Chess | Economics | Hardcore Games | Vegan Advocate | PC Reviews

I was hoping that format/reinstall would be the last option. Thanks.

Hi, Thanks for the post. First, please check whether the sqlsrv32.dll file is existing in the path %windir%\system32 and %windir%/SysWOW64. If not, I suggest you to perform SFC/scannow command to check this integrality of system files. If the files are already existing there, please check the following. The path for the SQL Server ODBC driver in the registry entry is either invalid or is pointing to a network driver. This causes driver installation to fail. Go to the following registry entry: HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\SQL Server and change the "driver" and "setup" values to point to %WINDIR%\system32\sqlsrv32.dll directory. Regards, Juke TechNet Subscriber Support in forum If you have any feedback on our support, please contact tnmff@microsoft.com. Please remember to click Mark as Answer on the post that helps you, and to click Unmark as Answer if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.

Hi, Any luck? Regards, Juke TechNet Subscriber Support in forum If you have any feedback on our support, please contact tnmff@microsoft.com. Please remember to click Mark as Answer on the post that helps you, and to click Unmark as Answer if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.

Hi, sorry! Yes this worked perfectly. The ODBC driver was the issue. Thanks!

Hi, Welcome! thanks for your update. Regards, Juke TechNet Subscriber Support in forum If you have any feedback on our support, please contact tnmff@microsoft.com. Please remember to click Mark as Answer on the post that helps you, and to click Unmark as Answer if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.