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

How to set up a dsn less odbc link


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.
  • 2
1 Solution
Jim Dettman (Microsoft MVP/ EE MVE)PresidentCommented:
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:


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

www. connectionstrings.com

chtullu135Author Commented:
Thanks Jim for the help.  I did some research and came up with the following link

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

A proven path to a career in data science

At Springboard, we know how to get you a job in data science. With Springboard’s Data Science Career Track, you’ll master data science  with a curriculum built by industry experts. You’ll work on real projects, and get 1-on-1 mentorship from a data scientist.

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