Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

msaccess adp - how does connection work?

Posted on 2009-02-10
7
Medium Priority
?
718 Views
Last Modified: 2013-12-05
I have a msaccess.adp file that connects to a sql server database via window authentication.  Everything was working until last week.  This is the strange thing.  I created an ODBC entry via the control panel connecting to the sql server via a sign in id/password.  I DID not change ANYTHING about the connection int he msaccess.adp file, but now the connection works again.  When I delete the ODBC entry from my machine, the msaccess.adp file doesn't work again with regards to the connection.  Can someone tell me why it works when I create the ODBC entry on my machine but not change how the msaccess.adp connects to the database.  Wierd.  It's like the adp is using the ODBC entry when it's initial connection doesn't work.  I hope someone can explain what is happening.  Thanks!
0
Comment
Question by:CaroleTSullivan
  • 4
  • 3
7 Comments
 
LVL 40

Expert Comment

by:Vadim Rapp
ID: 23602479
one possibility is that with odbc, you are changing client configuration - there's such button; which forces the client to connect to this particular sql server using different network protocol - and the default one for some reason does not work.

Try to telnet to the server port 1433, see if you can connect.
0
 

Author Comment

by:CaroleTSullivan
ID: 23603030
when I set up the ODBC, I did change the client configuration.  My question is why did the .adp connection use the ODBC connection version the connection configuration that was defined in the .adp file.  
0
 

Author Comment

by:CaroleTSullivan
ID: 23603046
I'm sorry, my last comment was clear.  My question is....does the .adp connection look for an ODBC file if the default .adp connection does not work?
0
Independent Software Vendors: 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!

 
LVL 40

Expert Comment

by:Vadim Rapp
ID: 23603078
ODBC applet only gives you interface to the configuration, but the configuration is global for the machine, not odbc-specific. If you set up 2 odbc entries for the same thing and change client configuration in one, you will find it changed in another as well.
0
 

Author Comment

by:CaroleTSullivan
ID: 23603610
so are u saying that the msaccess.adp used the ODBC entry which used the userid/password config versus using the window authentication?  or are u saying the at msaccess.adp used the ODBC client configuration and the window authentication?  I think what you're saying is that the msaccess.adp DOES use the ODBC entry NO MATTER how the adp defined the connection?
0
 
LVL 40

Accepted Solution

by:
Vadim Rapp earned 1500 total points
ID: 23603721
No. Both ODBC and Access are using configuration of the SQL client driver. ODBC allows you to see and change that configuration. Access only uses it, but has no interface to see or change it. Another way to see it would be to install sql server, that would give you dedicated application called "Client Network Utility".

It's the same as you can use your phone to access your bank account, but it does not mean that all your banking must go through the phone.
0
 

Author Closing Comment

by:CaroleTSullivan
ID: 31545120
thank you!
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Microsoft Access is a place to store data within tables and represent this stored data using multiple database objects such as in form of macros, forms, reports, etc. After a MS Access database is created there is need to improve the performance and…
Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple.  The final solution for this task involved creating a custom text parser and then reading…
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.
How can you see what you are working on when you want to see it while you to save a copy? Add a "Save As" icon to the Quick Access Toolbar, or QAT. That way, when you save a copy of a query, form, report, or other object you are modifying, you…

564 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