<div>
Any ideas for establishing the connection would be greatly appreciated. &nbsp;Thanks!!!
</div>


Any ideas for establishing the connection would be greatly appreciated.  Thanks!!!

<div>
<div class="content wysiwyg-content">
I am running Windows 7 Pro and I am trying to establish a SQL server connection for a 32 bit Access 2003 database. &nbsp;The SQL Server database is running SQL 2008 on a Windows Server 2008 R2 OS. &nbsp;I am using the 32 bit ODBC configuration utility from the Windows\SysWOW64 directory called odbcad32.exe. &nbsp;Attached are screen shots showing the different steps for creating the connection. &nbsp;In the 4th sceen shot where I would change the default database it does not appear in the drop down. &nbsp;However I have been able to connect successfully from another Windows 7 and XP Pro machine. &nbsp;If I use the same credentials on my Windows 7 machine that connected successfully on the other machines I do not get my instance name in the drop down when I attempt to change the default database. &nbsp;Any ideas on how to get this connection working would be greatly appreciated. &nbsp;Thanks Experts!!!<br />
<a href="https://filedb.experts-exchange.com/incoming/2014/02_w07/833527/ODBC-Problem.doc" target="_blank" class="file-inline" title="ODBC Problem (327 KB)"><svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 512 512"><path d="M67.508 468.467c-58.005-58.013-58.016-151.92 0-209.943l225.011-225.04c44.643-44.645 117.279-44.645 161.92 0 44.743 44.749 44.753 117.186 0 161.944l-189.465 189.49c-31.41 31.413-82.518 31.412-113.926.001-31.479-31.482-31.49-82.453 0-113.944L311.51 110.491c4.687-4.687 12.286-4.687 16.972 0l16.967 16.971c4.685 4.686 4.685 12.283 0 16.969L184.983 304.917c-12.724 12.724-12.73 33.328 0 46.058 12.696 12.697 33.356 12.699 46.054-.001l189.465-189.489c25.987-25.989 25.994-68.06.001-94.056-25.931-25.934-68.119-25.932-94.049 0l-225.01 225.039c-39.249 39.252-39.258 102.795-.001 142.057 39.285 39.29 102.885 39.287 142.162-.028A739446.174 739446.174 0 0 1 439.497 238.49c4.686-4.687 12.282-4.684 16.969.004l16.967 16.971c4.685 4.686 4.689 12.279.004 16.965a755654.128 755654.128 0 0 0-195.881 195.996c-58.034 58.092-152.004 58.093-210.048.041z"/></svg>ODBC-Problem.doc</a>
</div>
</div>


ODBC-Problem.doc

I am running Windows 7 Pro and I am trying to establish a SQL server connection for a 32 bit Access 2003 database.  The SQL Server database is running SQL 2008 on a Windows Server 2008 R2 OS.  I am using the 32 bit ODBC configuration utility from the Windows\SysWOW64 directory called odbcad32.exe.  Attached are screen shots showing the different steps for creating the connection.  In the 4th sceen shot where I would change the default database it does not appear in the drop down.  However I have been able to connect successfully from another Windows 7 and XP Pro machine.  If I use the same credentials on my Windows 7 machine that connected successfully on the other machines I do not get my instance name in the drop down when I attempt to change the default database.  Any ideas on how to get this connection working would be greatly appreciated.  Thanks Experts!!!

Cannot Establish ODBC Connection

Windows 7 is an operating system from Microsoft. Features include multi-touch support, a redesigned Windows Shell with a new taskbar, referred to as the Superbar, a home networking system called HomeGroup, and performance improvements.