ASP connection to visual foxpro

[jagvrb]

I am trying to setup an active server page that accesses my visual
foxpro database. I have setup a system DSN named vfp_test. How do you
open a recordset in an ASP? I have tried this code: rs.Open "ICILOC",
"DSN=VFP_test" , but I get an error on that line.

[Bob Barrows [MVP]]

ja****@aol.com wrote:

I am trying to setup an active server page that accesses my visual
foxpro database. I have setup a system DSN named vfp_test. How do you
open a recordset in an ASP? I have tried this code: rs.Open "ICILOC",
"DSN=VFP_test" , but I get an error on that line.

First, create and open a connection object:
set cn=createobject("adodb.connection")
'if vfp has an native ole db provider you should use it
'see www.connectionstrings .com
'for the sake of this example I will use your DSN
cn.open "VFP_test"

Then create a sql statement to only retrieve the fields you plan to use from
iciloc which I assume is the name of the table.
sql="select filed1,...,fieldN from iciloc"

Be explicit - don't use selstar in production code:
http://www.aspfaq.com/show.asp?id=2096

Then, to open a recordset using the default server-side, forwardonly cursor:
set rs = cn.execute(sql,,1)

The 1 means adCmdText - you should always tell ADo what the command type is.

--
Microsoft MVP - ASP/ASP.NET - 2004-2007
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"