I am a very beginning VB
database coder, but an ODBC relies on the data source being configured on your machine beforehand, unless you create a system/file DSN earlier in your code. This is something I do with scripts I write that connect to databases using this method. That way I am sure the DSN is there, and I know what name to use to reference it.
I hope this helps.