ODBC How To



Direct ODBC connection without DSN

To connect without defining ODBC DSN you need to specify DRIVER=dll_name in Options edit control on a Login screen

dll_name should refer to actual driver dll. In this case DSN combo box should specify actual database server name

 

Available ODBC API commands:

It is possible to execute set of predefined commands when using ODBC Connectivity. These commands directly map to ODBC API functions. See ODBC documentation for parameter description. This feature mainly used to help us to debug ODBC connections for underlying databases to which we do not have access.

 

=SQLTables (Catalog, Schema, ObjectType)

=SQLColumns (Catalog, Schema, Table)

=SQLSpecialColumns (Catalog, Schema, Table)

=SQLPrimaryKeys (Catalog, Schema, Table)

=SQLForeignKeys (Catalog, Schema, Table)

=SQLProcedures (Catalog, Schema, ObjectType)

=SQLProceduresColumns (Catalog, Schema, Procedure)