Basic Tab
To connect to an ODBC data source, specify either the DSN (data source name) or specify an ODBC connection string: Set Driver and the connection properties for your ODBC driver. A simple example is the following:
- DSN: The name of a DSN that has already been configured in ODBC. For example:
SQL Server Source
- Driver: This property is used to specify the ODBC Driver to use, along with any connection properties that are required. For example:
{SQL Server};Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword;
Note: the DSN needs to be installed on the server running TDV, not on the machine they are using TDV studio on.