Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Access OLEDB
Message
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Access OLEDB
Miscellaneous
Thread ID:
00907238
Message ID:
00907238
Views:
38
Hello all, is it possible to access an "MS Access" mdb via OLEDB using SPT ?, I've managed it with ADO but would prefer to use SPT if possible, I tried it with the code below but this resulted in a dialog prompting me for a DSN
cConnStr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\\myserver\sys\apps\data\mydata.mdb"

nHan = SqlStringConnect(cConnStr)
*/ Brings up a dialogue prompting for a DSN.
Regards,
Peter J. Kane



Pete
Next
Reply
Map
View

Click here to load this message in the networking platform