Information générale
Titre:
Connecting to SQL without using DSN
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)
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement