A while ago someone showed me this method of connect to a dBase database without having to use a DSN but instead to use the driver directly.

nSQL = sqlstringconnect([DBQ=C:\GoldMine;DefaultDir=C:\GoldMine;Driver={Microsoft dBase Driver (*.dbf)};DriverId=533;MaxBufferSize=2048;PageTimeout=5;])

On the SQL side I currently use:

nSQL = sqlstringconnect([DSN=CCC_GoldMine;UID=sa;PWD=;AutoTranslate=No;UseProcForPrepare=0;QuotedId=No;AnsiNPW=No])

and I was wondering if there is a way of specifying the SQL connection string with a driver instead of the DSN. If it is possible, could you take the string above and revise it correctly so that I can take a look at it.

TIA
DJ :o)