Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Making a connection to VFP
Message
General information
Forum:
ASP.NET
Category:
Other
Title:
Making a connection to VFP
Miscellaneous
Thread ID:
00485859
Message ID:
00485859
Views:
46
I am having some challenges with making a connection to a Visual FoxPro free table on the web. Actually, I need to access 2 tables and make a join. I am getting a Fox error 1 with the code below:
set cn1 = Server.CreateObject('ADODB.Connection')
cn1.Open 'Driver={Microsoft Visual FoxPro Driver};' & _
                   'SourceType=DBF;' & _
                   'SourceDB=\;' & _
                   'Exclusive=No;' 
set rs = cn1.Execute ( 'select * from table1' )
WHILE NOT RS.EOF
     Response.Write ( & rs('field1') & _
     & rs('field2') & _
     & rs('field3') & _
     & rs('field4') & )
     rs.MoveNext
WEND
Any ideas?
TIA!
DLC
"Use the Right Tool for the Job!"
davidandcynthia@email.com
Next
Reply
Map
View

Click here to load this message in the networking platform