Microsoft Access ODBC

Posted on : 21-01-2012 | By : connie | In : News

Tags: ,

0

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. 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.

Related posts:

  1. Microsoft Protection Optimal protection kompyuterPeredovye antivirus protection real vremeniUluchshennaya protection features for internet use and e-pochtoyBlokirovanie suspicious activity programmZaschita from stealing usernames, passwords and other personal dannyhObespechenie safe operation of wireless setyahMinimalnoe impact on the work...
  2. Operating System Windows There are situations when the drive to read discs just 'disappears' from the operating system. And he is determined in the BIOS. Why is that? In most cases the 'guilty' in the different programs...
  3. Virtual Disks An article about the virtual disks (disk image), their purpose, creation, use cases, the appropriate software. Detailed illustrated instructions will easily understand the basics work with virtual disks to any 'kettle'. David Fowler shines...
  4. Social Networking Vkontakte.ru – the most popular and frequently visited social network in RuNet. Probably no longer exists Internet users who would not know what it is. At the moment, the number of users OpenID has...
  5. Remote Administration Of Servers Currently, rent dedicated server is not so expensive on the market, there are hundreds of companies offering any configuration of servers in any price category, so that anyone can pick out what would he,...

Comments are closed.