 |  LoginProducts  SalesSupportDownloadsAbout |
| Home » Technical Support » DBISAM Technical Support » Product Manuals » DBISAM Version 4 ODBC Driver Manual » Using the ODBC Driver » Configuring a Data Source |
Configuring a Data SourceIntroduction
A data source, or DSN (Data Source Name), is used by applications that use ODBC to locate and access a specific database in a specific location. Once you have configured a data source in the ODBC Administrator, you may use this data source name in any application that can access ODBC. However, you should check out the Application Compatibility notes in this manual for more information on applications that have been specifically tested with the DBISAM ODBC Driver.
Step-By-Step Instructions
Complete the following steps to properly configure a data source that uses the DBISAM ODBC Driver:
1) Run the ODBC Administrator (odbcad32.exe). This program is located in the Start menu under Programs/Administrative Tools/Data Sources (ODBC).
By default, 32-bit versions of Windows use the 32-bit ODBC Administrator, and 64-bit versions of Windows use the 64-bit ODBC Administrator, when launching the ODBC Administrator via the Administrative Tools link. If you're using a 64-bit version of Windows, then you must use the 32-bit ODBC Administrator located here in order to configure 32-bit data sources for use with 32-bit applications and the 32-bit DBISAM ODBC Driver:
where <WindowsInstallDir> is the base Windows installation directory, usually c:\Windows.
2) If you want the data source to be accessible by all users, then click on the System DSN tab. If you want the data source to only be accessible to the current user, then click User DSN tab (the default page).
3) Click on the Add button to begin adding a data source. This will bring forward a dialog with a list of the installed ODBC drivers. Select the DBISAM ODBC Driver from the list and click on the Finish button.
It is possible that there may be more than one DBISAM ODBC Driver listed due to multiple, different major versions of the driver being installed on the system.
4) A DBISAM ODBC Driver configuration wizard dialog will now be shown. Follow the instructions on this wizard to complete the data source configuration.
If at any time you wish to re-configure the data source, simply choose the appropriate tab page (User DSN or System DSN), select the data source name that you previously added from the list of data sources, and then click on the Configure button. This will bring forward the same configuration wizard dialog as before, except in this case you cannot specify a name for the data source.
A data source, or DSN (Data Source Name), is used by applications that use ODBC to locate and access a specific database in a specific location. Once you have configured a data source in the ODBC Administrator, you may use this data source name in any application that can access ODBC. However, you should check out the Application Compatibility notes in this manual for more information on applications that have been specifically tested with the DBISAM ODBC Driver.
Step-By-Step Instructions
Complete the following steps to properly configure a data source that uses the DBISAM ODBC Driver:
1) Run the ODBC Administrator (odbcad32.exe). This program is located in the Start menu under Programs/Administrative Tools/Data Sources (ODBC).
By default, 32-bit versions of Windows use the 32-bit ODBC Administrator, and 64-bit versions of Windows use the 64-bit ODBC Administrator, when launching the ODBC Administrator via the Administrative Tools link. If you're using a 64-bit version of Windows, then you must use the 32-bit ODBC Administrator located here in order to configure 32-bit data sources for use with 32-bit applications and the 32-bit DBISAM ODBC Driver:<WindowsInstallDir>\SysWoW64\odbcad32.exe
where <WindowsInstallDir> is the base Windows installation directory, usually c:\Windows.
2) If you want the data source to be accessible by all users, then click on the System DSN tab. If you want the data source to only be accessible to the current user, then click User DSN tab (the default page).
3) Click on the Add button to begin adding a data source. This will bring forward a dialog with a list of the installed ODBC drivers. Select the DBISAM ODBC Driver from the list and click on the Finish button.
It is possible that there may be more than one DBISAM ODBC Driver listed due to multiple, different major versions of the driver being installed on the system.4) A DBISAM ODBC Driver configuration wizard dialog will now be shown. Follow the instructions on this wizard to complete the data source configuration.
If at any time you wish to re-configure the data source, simply choose the appropriate tab page (User DSN or System DSN), select the data source name that you previously added from the list of data sources, and then click on the Configure button. This will bring forward the same configuration wizard dialog as before, except in this case you cannot specify a name for the data source.
More Support Options
This web page was last updated on Thursday, November 16, 2023 at 10:39 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ?  E-mail us at info@elevatesoft.com |
