Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Connect to OLEDB provider using ODBC
Message
De
16/02/2012 19:24:33
 
 
À
16/02/2012 18:10:49
Joel Leach
Memorial Business Systems, Inc.
Tennessie, États-Unis
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Versions des environnements
Visual FoxPro:
VFP 9 SP2
Divers
Thread ID:
01535618
Message ID:
01535629
Vues:
55
I don't think so, You can go the other way, but not sure why you would want to. Also, keep in mind that Microsoft has declare OLEDB to be dead.

>Is it possible to connect to an OLEDB provider using ODBC? I always assumed that required ADO, but I found the code below in Craig Boyd's AppendXLSX.prg. Unfortunately, it pops up a dialog for me to select a data source, so I'm curious if this would have worked for Craig or anyone else.
>
>m.lnSQL = SQLSTRINGCONNECT([Provider=Microsoft.ACE.OLEDB.12.0;Data Source="] + m.tcXLSFile + [";Extended Properties="Excel 12.0 Xml;HDR=] + m.lcHeaderRow + [;";])
>
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform