ODBC Connection Failed

[Rick via AccessMonster.com]

How do I set up an ODBC connection? I see the administration tools in the
control panel, but not sure how to set this up so that it connects to the
database that is failing.

Don't know what happend, because it use to work, but now this morning I'm
getting the error.

Thanks,
Rick

 

[Dennis]

Can you be more specific on the error you're getting?

An ODBC connection consists of:

The DSN name
The server name
The database name

The DSN name must match what the database application expects it to be
called. For example, if your application's table links expect the DSN entry
to be named "SalesDB", and someone changes that name in the ODBC manager to
"Sales DB", you'll get a failure (in this example, a space was added to the
name).

If you know the three things I spoke of above, you should be able to setup
an ODBC connection is a few moments at most. Note that if someone changed the
SQL database (added a column, removed a column, etc) the affected table
should be re-linked in the Access fromnt-end. Sometimes the table needs to be
dropped and re-added to the front-end, although I'm not at all sure what
conditions require it.