Finding DNS

Posted on 2011-05-05
Medium Priority
Last Modified: 2012-05-11
I went through the control panel and made a DNS connection (tested it and it worked).  I'm now in Access 2010 front-end, trying to use the wizard to import & link tables to a SQL Server.  I don't see the DNS I made anywhere.  Someone have a good step-by-step on how to do this? It's been awhile.
Question by:gcgcit
  • 2
  • 2
LVL 58
ID: 35697906

 When you created the DSN, did you create a file, user, or system DSN?

  Also, are you working on a 64 bit OS?   For 64 bit, there are two ODBC managers; one for 64 and one for 32.  Access is a 32 bit app, so you must create it with the 32 bit ODBC manager or it won't see it (the 32 bit one is in the WOW64 directory).


Author Comment

ID: 35697956
I'm in a 64 bit, Windows 7 and Access 2010.  I was in control panel to make DSN, got my admin to log in, created it, tested connection and rebooted.  Now I'm in Access 2010 pressed Import & Link ODBC Database and when I type the DNS name but I don't know what folder to link to.
LVL 58

Accepted Solution

Jim Dettman (Microsoft MVP/ EE MVE) earned 2000 total points
ID: 35698313

  Unless your using the 64 bit edition of Office (most are not), you need to create the DSN with the 32 bit version of the ODBC manager:

 %systemdrive%\Windows\SysWoW64\ Odbcad32.exe

  Make sure you a system DSN with it.

  In Access 2010, Click External Data, ODBC Database, then select "Link to data source by creating a linked table".

  The ODBC dialog will popup and you should see your DSN.



Author Closing Comment

ID: 35699766
Thank you, very helpful as always.  Fixed it.

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

We live in a world of interfaces like the one in the title picture. VBA also allows to use interfaces which offers a lot of possibilities. This article describes how to use interfaces in VBA and how to work around their bugs.
Sometimes MS breaks things just for fun... In Access 2003, only the maximum allowable SQL string length could cause problems as you built a recordset. Now, when using string data in a WHERE clause, the 'identifier' maximum is 128 characters. So, …
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…
Suggested Courses

850 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question