Microsoft Access ODBC

When using the client application by means of ODBC call to a specific data source, and through him – to the database, which he represents. When you install the ODBC is set of general and ODBC subsystem defined by a pair of "driver – the database", which is raised by the names used when connecting to the database. The corresponding pairs are called DSN – data source names. Create a data source is performed using ODBC Data Center Sours Administrator, called from the Control Panel window. The structure parameters of the source data includes: name and description of the source data server, to which they connect, the authentication method – the name of the database. There are three main types of data sources: user, file and system.

User data sources access to the data sources listed on the tab User DSN (data source user) windows ODBC Data Sours Administrator (Administrative data sources, ODBC), is only an account of the user who created them. Setting up custom data sources is similar to the setting of system data sources. If the error message says that there is no data source, you must first check to see if this user DSN. If so, then you must convert it to a file or system data source. Learn more on the subject from Scott Mead. File File data sources are data sources, similar to system resources, but unlike them, are stored in files, which facilitates the exchange of files between different computers DSN. If you want to use a data source for remote computer, the first thing to do for this – to make sure that this computer has the appropriate driver. For example, you can not use file data source for Access, if you have there is no ODBC driver for Microsoft Access. System data sources the System data source is available to any user of this computer. This, of course, does not mean that all egopolzovateli have access to the database, which refers to the data source. It just means that any scripts running on your computer, on which there is a source of data, can "see" the data source and use it to connect to the database data.