Tips to Windows ODBC manager "ODBC Data Source Administrator" |
Unfortunately, the Windows ODBC manager is not easy to use for the first time user. The following tips should make the entrance easier. |
Function of Windows ODBC manager |
- The Windows ODBC manager administers so-called DSNs (Data Source Names) which represent a data source (e.g., an Access database). A DSN contains all information which is needed for opening a data source, as for example: File path to the Access data base, user name and password, special data source parametres.
- The DSN to a data source should be created by the administrator once on a PC and can be used afterwards by applications.
The DSN name can be freely chosen, as for example "My customer database ".
- Path to open the ODBC-Manger in Windows:
[Control Panel > Administrative Tools > Data Sources (ODBC)]
|
Create a new DSN (example with Access) |
...during setup of a new folder linking: - You are in the dialog "Select Data Source" of the ODBC manager.
- Click on [Add...]
(You do not need to enter a name in field "DSN name", the name is questioned later.)
- Select in the following dialog the suitable driver to your data source, - "Microsoft Access driver (*.mdb)" for example.
Hint: Some drivers can be listed several times in different language versions what has influence on possible error messages.
- After [Next >] the DSN name is to be entered now.
e.g., " My customer database " Click on [Next >] and [Finish].
- The following dialog comes from the selected database driver.
In the Access driver dialog, the the desired *.mdb file would be selected via [Select...] button.
- With [OK] the settings are taken over and now the DSN name should be visible in the ODBC manager.
- With a further [OK] the ODBC manager is closed. Now in the CTI-Client-Dialog "New Folder Linking" all tables of the Access database should be visible.
Create a new DSN via Control Panel: - Open the ODBC manager via: [Control Panel > Administrative Tools > Data Sources (ODBC)]
- Select "File DSN".
- Click on [Add ...]
- To the further steps see point 3. and following above.
|
|