• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 603
  • Last Modified:

How to set up a dsn less odbc link

Hello,

I'm trying to set up a dsn less odbc link to a table on an 2005 sql server from an access front end.  The server uses Sql Server authentication.  There are already several tables that are linked to the Access 2007 front end in this fashion.  This is an application I just took over and the previous developer is not available.  I'm trying to find out how the previous developer was created these dsn-less odbc connections to the backend.
0
chtullu135
Asked:
chtullu135
  • 2
1 Solution
 
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
It's done through a tabledef's object connect property. The way ODBC works, the connect string along with any DSN referenced need to supply all the parameters required to connect.  If any parameters are missing, you'll get prompted.

Likewise, if all the parameters appear in the connect string, then a DSN is not required.

Read through this on how to convert to a DSN-less connect string:

http://www.accessmvp.com/DJSteele/DSNLessLinks.html

Jim.
0
 
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
and a good site BTW for getting the required connect strings for a data source is:

www. connectionstrings.com

Jim.
0
 
chtullu135Author Commented:
Thanks Jim for the help.  I did some research and came up with the following link
http://support.microsoft.com/kb/892490

It does the same thing as the link you posted.  Both use the table def collection.  BTW thanks for the link for connection strings
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.

Join & Write a Comment

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now