Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Exporting data in MSACCESS
Message
 
 
À
19/03/2007 13:42:57
Dragan Nedeljkovich (En ligne)
Now officially retired
Zrenjanin, Serbia
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Versions des environnements
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Divers
Thread ID:
01192149
Message ID:
01205651
Vues:
23
>>Here's you suggested code:
>>
lnConnHandle = SQLSTRINGCONNECT('Driver={Microsoft Access Driver (*.mdb)};Dbq="'+
>>	lcMDBDir+'\'+lcMDBName+'";Uid=Admin;Pwd=;')
>>
>>
>>Here's what I typed in and I think they are the same, but it returned a -1 value. It did get further through the program but I should have tested for a -1 return value and stopped the program at that point. I'll do that.
>>
>>
>>lnConnHandle = SQLSTRINGCONNECT('Driver={Microsoft Access Driver (*.mdb)};Dbq="'+
>>	lcMDBDir+'\'+lcMDBName+'";Uid=Admin;Pwd=;')
>>
>
>Let's try a clean one...
>
>
lcFullPath=forcepath(lcMDBName, lcMDBDir)
>cString=textmerge("Driver={Microsoft Access Driver (*.mdb)};Dbq=<<lcFullPath>>;Uid=Admin;Pwd=;"
>lnConnHandle=sqlstringconnect(cString)
>if lnConnHandle<1
>   aerror(ee)
>   messagebox(ee[2])
>endif
How about double quotes around the path? The original problem was related to a space in the path.
If it's not broken, fix it until it is.


My Blog
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform