| Home | Previous Lesson: Network Options Next Lesson: ODBC |
'Connect Type' specifies how the ODBC driver prompts for additional connection information while connecting to the ODBC data source.
SQL_DRIVER_NOPROMPT tries to connect to the database with the information provided and returns error when can not connect. This value doesn't display any dialog box to the user.
SQL_DRIVER_PROMPT always prompts for the database connection information.
SQL_DRIVER_COMPLETE displays all the required dialog boxes, if it is not able to connect to the database successfully.
SQL_DRIVER_COMPLETE_REQUIRED works like SQL_DRIVER_COMPLETE, but displays only those options that are absolutely necessary to connect to the database.
'ODBC Trace Options' will be explained in detail in 'Debugging PB Apps' session'.
Once you provide all the details, you can also preview and copy the syntax from the Preview tab page meaning, you don't have to type in all the code in your script.
| Home | Previous Lesson: Network Options Next Lesson: ODBC |