General discussion


how to configure ODBC on client side?

By webmaster ·
how to configure ODBC on the client side (Access)?

Configure client-server connectivity with the ODBC Data Source Administrator

Would someone please teach me:
use Access database as an example. If we want to use one Access database in a LAN, first need to configure on the server side (ODBC connection), then how to configure on the client side (after splitting)?
Normally we use "link Table Manager" to define the path. Do we have to share the database completely on the server side? What shall we do to guarantee the security (user management)?

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Collapse -

by webmaster In reply to how to configure ODBC on ...

On Server side, we need to configure ODBC, File DSN, my question is: then how to configure on Client side? Do we still need to share the database file on the Server side completely?

Collapse -

by compgirlfhredi In reply to how to configure ODBC on ...

I believe Techrepublic covered this quite well in:
Windows 2000 supports three kinds of ODBC data source names (DSNs): system, user, and file. Windows 2000 stores system and user DSNs in the registry. It stores file DSNs, however, as files with a .dsn file extension.
A common use for a file DSN is to provide a data connection for a local application, such as Excel or Access. The advantage of using a file DSN is that you can share it easily with users, either by placing it on a network share or by copying the DSN file to each user's computer.
To share file DSNs with users, use the Data Sources applet in the Administrative Tools applet of Control Panel to first create the DSN, and place the DSN in a location accessible to users. Users must add the DSN folder path to their respective application settings.
For example, if users are working in Excel, choose Data | Import External Data | New Database Query. In the Choose Data Source dialog box, click Options, enter the path to the shared DSN folder, and click OK to close both dialog boxes. The DSNs will then be available to other users within the application.

Collapse -

by webmaster In reply to how to configure ODBC on ...

Can you explain how to use the DSN file if working in Access, instead of Excel?

Collapse -

by webmaster In reply to how to configure ODBC on ...

This question was closed by the author

Related Discussions

Related Forums