Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Exporting data in MSACCESS
Message
De
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:
01205649
Vues:
22
>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

back to same old

the first online autobiography, unfinished by design
What, me reckless? I'm full of recks!
Balkans, eh? Count them.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform