Database Developer's Guide:ODBC
To connect to a database with ODBC, you have to set up a DSN with, for example the Data Source Name: Webserver.
Now use a Database component by setting:
- DriverName: odbc
- Host: the Data Source Name you have set, for example Webserver
- Username: Name of the user with access
- UserPassword: Password for that user
Note: To set up a database with ODBC is very easy, but this data access is really slow compared to native access. So it is recommended to use native access if possible.