Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Making a connection to VFP
Message
Information générale
Forum:
ASP.NET
Catégorie:
Autre
Titre:
Making a connection to VFP
Divers
Thread ID:
00485859
Message ID:
00485859
Vues:
45
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
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform