Yes... In your ODBC DSN settings, check the Exclusive Use Check Box...

Here is an example on how to use a dsn-less connection string:

oConn = Createoject("adodb.connection")
oConn.Provider = "MSDASQL"
oConn.COnnectionString = ;
[Extended Properties="Driver={Microsoft Visual FoxPro Driver};UID=;SourceDB=D:\Program Files\Microsoft Visual Studio\MSDN98\98VSa\1033\SAMPLES\VFP98\data\TESTDATA.DBC;SourceType=DBC;Exclusive=Yes;BackgroundFetch=Yes;Collate=Machine;Null=Yes;Deleted=Yes;"]