ODBC connection DNS failed

Question

I just updated my company's Operation's computer from Windows XP on an old computer to a new machine (dual core) computer with Windows 7 Professional.  The system is running MS Office 2007.  On the old comuputer the MS Access 2007 runs fine.  However, when I setup the new computer, I get an error when I attempt to run MS Access.  When I click on the button to access the label on the database, I get an error: "ODBC connection BOXWAVE_ECOM_REMOTE failed."  I have AVG running on the computer for the antivirus software.  Previously the system had "Norton Security Suite 2012" on it.  I uninstalled Norton and installed AVG.  Norton was blocking the 1433 port to get to the database.  My co-worker who is the database admin, made sure that the SQL server is connected to the PC.  He has set the permissions to the computer and attempted to get the MS Access to work.  However, we still get the same error as above.

Can someone help?  Thanks in advance.

Kristopher A. Fine

******@yahoo.com

Answer 1

I am assuming your database contains linked tables to SQL Server.  In order for these linked tables to work, you will need to create a DSN on your machine within the ODB Administrator.  I would recommend giving it the same name you used on the old machine (if possible).  After the DSN is created if you used the same name / driver, then try testing your application again.  If it still fails, you will then need to relink the linked tables in your database using the linked table manager.  Within the linked table manager, you will want to point to the new DSN you created.

Best Regards,

Nathan O.

Microsoft Online Community Support