I use SQLStringConnect() function. You do not have to have a DSN or a DBC Connection.
sqlstringconnect('Driver=Microsoft ODBC for Oracle;UID=myid;PWD=mypwd;CONNECTSTRING=reg6;')
I believe only the Oracle drivers use CONNECTSTRING parameter. The rest use the SERVER parameter. You can get the descriptive name of the driver from the ODBC Admin in Control Panel.
>Is there a way to use SQL Pass through to select the Remote Database using a DataSource instead of creating a temporary Database and using CREATE CONNECTION command?
>
>I know if the ODBC connection is created properly to point to the Database this is not a problem. However, if the DBA did not select a Default Database is there a way to select it knowing the name of the database as in CREATE CONNECTION?
>
>TIA
Mark McCasland
Midlothian, TX USA