Finding DNS

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.
gcgcitAsked:
Who is Participating?
 
Jim Dettman (Microsoft MVP/ EE MVE)Connect With a Mentor President / OwnerCommented:

  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.

JimD.



Region-Capture.jpg
0
 
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:

 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).

JimD.
0
 
gcgcitAuthor Commented:
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.
0
 
gcgcitAuthor Commented:
Thank you, very helpful as always.  Fixed it.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.