AMPLECOMPUTERS
asked on
Office XP on Windows 7 64 ODBC not linked
Ever since 2002 I have been developing on Office XP developer edition and still have quite a few databases running Access XP front ends with either SQL Server or MySQL backends. Converting them all is not an option.
I recently moved my main machine to Windows 7 64bit and so far everything seemed to work, until now.
I can open up the ODBC control panel and create a connection to my server (Server 2008) which has both SQL Express 2008 and MySql 5.x on it, connections here to both are fine. I can open the MySQL query browser on my Win7 machine and execute queries on the server just fine. Now when I open Access XP's linked tables dialog the ODBC connections I entered in the Windows 7 control panel are not there. When I create a new one in Access pointing to the SQL Server it works fine but it does not show up in the Windows 7 ODBC control panel.
This may not be an issue, or it may be. Since the end user will have an Access runtime instead of a full blown copy they will not have a way to set up a ODBC connection unless they can do it from the Windows ODBC control panel.
Suggestions?
I recently moved my main machine to Windows 7 64bit and so far everything seemed to work, until now.
I can open up the ODBC control panel and create a connection to my server (Server 2008) which has both SQL Express 2008 and MySql 5.x on it, connections here to both are fine. I can open the MySQL query browser on my Win7 machine and execute queries on the server just fine. Now when I open Access XP's linked tables dialog the ODBC connections I entered in the Windows 7 control panel are not there. When I create a new one in Access pointing to the SQL Server it works fine but it does not show up in the Windows 7 ODBC control panel.
This may not be an issue, or it may be. Since the end user will have an Access runtime instead of a full blown copy they will not have a way to set up a ODBC connection unless they can do it from the Windows ODBC control panel.
Suggestions?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
OK, now I feel better. Everything I entered into Access was right there waiting on me. Now that I know I can get to both, I feel more comfortable going forward. Thanks!
If you just fire up the ODBC Administrator in Win7 64-bit, you'll see only the 64-bit drivers. If you want to view the 32-bit drivers, you'll have to run the odbcad32.exe, located in the <Root>\SysWow64 folder. This will show you the 32-bit drivers.
See here:
http://social.msdn.microsoft.com/Forums/en/sqldataaccess/thread/685eacc1-a670-42d4-8392-924230fa90cb