Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Asp syntax for foxpro table
Message
From
14/10/1998 22:21:09
 
General information
Forum:
Visual FoxPro
Category:
Internet applications
Miscellaneous
Thread ID:
00145309
Message ID:
00146969
Views:
28
>Does anyone know where I can find the syntax for asp? I would like to convert the code below to connect to a VFP table rather than an access table (database).
>
>1 set conntemp=server.createobject("adodb.connection")
>2 cnpath="DBQ=" & server.mappath("yourtable.mdb")
>3 conntemp.Open "DRIVER={Microsoft Access Driver (*.mdb)}; " & cnpath
>4 set rstemp=conntemp.execute("select * from authors")

You don't need _all_ of this. The syntax for a fox table is the same for an access table, they both have to be set up as an ODBC datasource. All you need is
<%Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open("dsn=myvfpDataSource")
Conn.Execute("select * from authors")
%>
www.west-wind.com has some stuff about ASP.
Erik Moore
Clientelligence
Previous
Reply
Map
View

Click here to load this message in the networking platform