Outlook • ACT! • combit address manager • cobra Adress PLUS • CAO-Faktura • Access Databases • Lotus Notes • Text files
Up | ### Windows ODBC Manager | Page Index

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 farther [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 farther steps see point 3. and following above.