Showing a list of SQL Tables under ODBC
Have you considered using UDL files
You can create connections using the "Microsoft OLE DB Service Component Data Links" components: this allows existing conections to be verified as well as new ones to be set up. No runtime error when the validataion fails
To experiment, create a new and empty text file and rename its extension to UDL. Double click on it from within Windows Explorer.
|