asked on

msaccess adp - how does connection work?

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!

Vadim Rapp

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.

CaroleTSullivan

ASKER

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.

CaroleTSullivan

ASKER

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?

Vadim Rapp

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.

CaroleTSullivan

ASKER

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?

ASKER CERTIFIED SOLUTION

Vadim Rapp

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

CaroleTSullivan

ASKER

thank you!