ODBC changes at random...help

Hi All,
Strange thing going on here.....I have an application that uses 2 ODBC
connections, 1 for SQL and 1 for an Access Database. They are configured as
System ODBCs that connect to the databases through a mapped drive to the
server. Everything works fine on all users except 4 of them....whose ODBC
for the Access database will randomly (maybe once a month or less) change
from the one mapped drive to another...where there is no database. 3 of
these users are running XP pro and the other is running Win 2000.
I have deleted the ODBCs and recreated them, disconnected the drives and
re-mapped them....it still does it periodically.
Any idea why this is happening and how to stop it?
Thanks!!
Troubleshooting random events that you can't repro is very difficult.
I'd suggest getting rid of the DSNs you are using and connect
programmatically by supplying the ODBC connection string information
in code when the user connects. You can get the syntax for valid ODBC
connection strings for both Access and SQL Server at
http://able-consulting.com/ADO_Conn.htm and
http://www.connectionstrings.com. DSN's are notoriously difficult to
support and troubleshoot.
--Mary
On Wed, 23 Feb 2005 11:32:40 -0700, "Dan B" <none@.none.com> wrote:

>Hi All,
>Strange thing going on here.....I have an application that uses 2 ODBC
>connections, 1 for SQL and 1 for an Access Database. They are configured as
>System ODBCs that connect to the databases through a mapped drive to the
>server. Everything works fine on all users except 4 of them....whose ODBC
>for the Access database will randomly (maybe once a month or less) change
>from the one mapped drive to another...where there is no database. 3 of
>these users are running XP pro and the other is running Win 2000.
>I have deleted the ODBCs and recreated them, disconnected the drives and
>re-mapped them....it still does it periodically.
>Any idea why this is happening and how to stop it?
>Thanks!!
>