TeleFlow Step 0800
From TeleFlow
DB Connect Step
Connects to a database using ODBC (This is the only method of connecting to a database from within a TeleFlow Application).
A TeleFlow Application must connect to a database before running any SQL statements or stored procedures (with the SQL Statement step) to communicate with it. An application can connect to a data source prior to waiting for a call and maintain the connection at all times. TeleFlow does not allow you to have a connection to multiple data sources/databases at one time.
Contents |
Properties
ODBC Source: A drop-down list of ODBC data sources currently available/configured on the system. When one is selected, the 'DSN =' line of the connect string is sent to the Connect Parameters box.
Connect Parameters: The ODBC connect string to use to connect to the database. The database, ODBC drivers the application is using to connect to it, and its settings can all affect what is required in the connect string. Assuming the appropriate DSN has already been set up (See 'Setting up ODBC Data Sources' for help with this.), the following connect commands - with some adjustments for the appropriate user name or DSN name, of course - will provide access to the listed commonly used database systems:
- dBase: DSN=dBASEfile;
- MySQL: DSN=MySQLServer;
- SQL Server: DSN=SQLServer;UID=MANAGER;PWD=password;
Note that most databases - as shown above - require only that the application connect with "DSN=" and the data source name. Some require that the application itself, and not the datasource, supply user names and passwords for security.
Buttons
ODBC: Opens the ODBC Data Source Administrator, where you can set up new data sources of modify those already set up.
Action Steps
Failure: A database connection might fail if the database server is currently unavailable, or if some information in the connect string is incorrect, such as when a user name supplied isn't valid for the database.
Related Steps
DB Disconnect
SQL Fetch
SQL Statement
