Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Can I use ADO to connect to a .DBC?
Message
From
23/11/2001 06:23:47
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00585075
Message ID:
00585081
Views:
24
This message has been marked as the solution to the initial question of the thread.
Chris,
Sure. Try something like this:
oConnection = CreateObject("adodb.connection")
oRecordSet = CreateObject("adodb.recordset")

oConnection.Open("Driver={Microsoft Visual FoxPro Driver};" +;
                 "SourceType=DBC;" +;
                 "SourceDB=C:\Program Files\Microsoft Visual Studio\MSDN98\98VS\1033\Samples\VFP98\Tastrade\Data\TASTRADE.DBC;" +;
                 "Exclusive=No;")

oRecordSet.Open("select * from supplier", oConnection, 1, 3)
?oRecordSet.fields(1).value
HTH
>Ummmm! This may sound like a silly question - can I use ADO to connect to a Visual Foxpro .DBC?
Daniel
Previous
Reply
Map
View

Click here to load this message in the networking platform