Connecting to SQL Databases

SQL databases are created and maintained using the native tools supplied with each database.

Database Drivers

To use a SQL database in a DataFlex workspace, you will need to load and configure the driver software for that database type and specify the connection parameters for the database.

• Configuring Database Drivers
• Configuring a Database Connection
• Login and Logout

Connecting to an SQL Database

To access tables from the database you are connecting to, you will need to create table descriptions. These describe the tables to the DataFlex driver software.

• Connecting to an MSSQL Database
• Connecting to a DB2 Database
• Connecting to an ODBC Database

Converting from/to an SQL Database

To convert an existing embedded database into an SQL database, use one of the database conversion wizards.

• Converting to MSSQL
• Converting to Pervasive.SQL
• Converting to DB2
• Converting to ODBC
• Converting to the Embedded Database

Table Character Formats

• OEM to ANSI Conversion Wizard