ASP anyone?

[joecdn]

I'm not sure if anyone knows this, but I'm trying to insert a record into a FoxPro 2.6 database using ASP. I tried the regulat Insert command, but that doesn't seem to work. So, I'm trying this method, which I think is closer, but no cigar. Here's the code I have.

Dim ConString
Dim adoCon
Dim DataBase

DataBase = "C:\Inetpub\

http://wwwroot\Nu-Leaf\nl_staff"

' nl_staff is the FoxPro database
ConString = "Driver=Microsoft Visual FoxPro Driver;"
ConString = ConString & "SourceType=DBF;SourceDB=" & DataBase
ConString = ConString & ";Exclusive=NO;Deleted=YES;NULL=No;BackgroundFetch=No;"

Set adoCon = Server.CreateObject("ADODB.Connection&quot

Set RS=Server.CreateObject("ADODB.Recordset&quot
SQLQuery="Select * from C:\Inetpub\

http://wwwroot\Nu-Leaf\nl_staff"

' I think these next 2 declarations need to be properly picked in order for it to work
RS.CursorType = adOpenUnspecified
RS.LockType = adLockUnspecified
RS.Open SQLQuery, adoConn

RS.AddNew
RS.Fields("cnumber&quot = request.form("txtrepnum&quot
RS.Fields("sname&quot = request.form("txtlast&quot
RS.Fields("sfname&quot = request.form("txtfirst&quot
RS.Fields("webpass&quot = pv
RS.Update

Any insight would be great. Thanks in advance.

 

[rgbean]

Joe,
Since this really has nothing to do with FoxPro 2.x (other than the data - which is basically just a generic xBase .DBF), you'd probably be better off asking on a VB or ASP forum.

Rick