>Hello all.
>
>Does anyone know how to make an ODBC connection on the fly? I'm in win2000 and trying to create connections to user chosen DBs in MySQL. This doesn't change the ODBC though. I tried using CreateConnection() - But I can't enter the IP and keep getting an error that no database has been chosen.
>
>Any help would be wholely appreciated...

Use SQLStringConnect. That does not need an ODBC DSN. If you are dependent on remote views that share a connection, then you will have to create a dummy remote view for each DB you want to connect to.

SQLConnect and SQLStringConnect lock you into SPT only. However, if you use the dummy remote view to establish the connection, you can use the CursorGetProp to retrieve the connection handle of that view for use in SPT.