Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Connect to OLEDB provider using ODBC
Message
From
16/02/2012 19:24:33
 
 
To
16/02/2012 18:10:49
Joel Leach
Memorial Business Systems, Inc.
Tennessee, United States
General information
Forum:
Visual FoxPro
Category:
Client/server
Environment versions
Visual FoxPro:
VFP 9 SP2
Miscellaneous
Thread ID:
01535618
Message ID:
01535629
Views:
58
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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform