Solved

How to set up a dsn less odbc link

Posted on 2012-03-21
3
543 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
  • 2
3 Comments
 
LVL 57

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 57
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

Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Join & Write a Comment

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

757 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

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now