The Connection Properties dialog opens. For my sample ITworld application, I changed the data source to Microsoft SQL Server (SQLClient), and entered the necessary Server, Log On, and database values.

Errors are sent to another table, rather than disrupting the whole process. (Click image to view larger version.) As you can see in Fig 4., the errors have been redirected.