Solved

How to set up a dsn less odbc link

Posted on 2012-03-21
3
592 Views
Last Modified: 2012-03-21
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
Comment
Question by:chtullu135
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 58

Accepted Solution

by:
Jim Dettman (Microsoft MVP/ EE MVE) earned 500 total points
ID: 37748074
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
 
LVL 58
ID: 37748094
and a good site BTW for getting the required connect strings for a data source is:

www. connectionstrings.com

Jim.
0
 

Author Closing Comment

by:chtullu135
ID: 37748213
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

Featured Post

Database Solutions Engineer FAQs

In this series, we will discuss common questions received as a database Solutions Engineer at Percona. In this role, we speak with a wide array of MySQL and MongoDB users responsible for both extremely large and complex environments to smaller single-server environments.

Question has a verified solution.

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

What if you have to shut down the entire Citrix infrastructure for hardware maintenance, software upgrades or "the unknown"? I developed this plan for "the unknown" and hope that it helps you as well. This article explains how to properly shut down …
Code that checks the QuickBooks schema table for non-updateable fields and then disables those controls on a form so users don't try to update them.
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

626 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