VB6 Heterogeneous queries require the ANSI_NULLS and ANSI_WARNINGS options to be set for the connection

If you are getting the next error on your VB6 applications when trying to run selects:

Heterogeneous queries require the ANSI_NULLS and ANSI_WARNINGS options to be set for the connection

Looks like the problem is in the ODBC connection. Be sure  you have selected the check boxes:

Use ANSI quoted identifiers

Use ANSI nulls, paddings and warnings

VB6 No creatable public component detected

If you get the error "No creatable public component detected" when trying to compile a new VB application like the one below, you need to change the Instancing value because it is private.

Just change the instancing to Multiuse or GlobalMultiuse: