Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

How to set up a dsn less odbc link

Posted on 2012-03-21
3
Medium Priority
?
598 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 58

Accepted Solution

by:
Jim Dettman (Microsoft MVP/ EE MVE) earned 2000 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

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

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.
One of the most important things in an application is the query performance. This article intends to give you good tips to improve the performance of your queries.
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

877 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