Invalid argument value error when updating memo fields

[myatia]

I'm getting this message when I try to update a memo field in a recordset. If I remove the memo field lines from the update statement, the update works just fine. Does anyone have any advice? My code and error messages are below. I'm using ASP and VFP 6. Let me know if you have any questions.

Thanks,

Misty

ERROR MESSAGE
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Visual FoxPro Driver]Invalid argument value
/career/secure/career_guide/acguide_signup_demographics.asp, line 101


VALUES FROM THE FORM
FirmDesc = 'dfg'
Clind = 'dfgf'
Firmname = 'blah blah'


CODE

<%
'// Memo fields
FirmDesc = trim(Request.Form("FirmDesc"))
Clind = trim(Request.Form("Clind"))

'// text field
FirmName = trim(Request.Form("FirmName"))

set rs = server.createobject("ADODB.Recordset")
    
rs.cursorlocation = adUseServer
rs.cursortype = adOpenKeyset
rs.locktype = adLockOptimistic

fields = "firmother, clind, firmname"
st = "SELECT " & fields & " FROM guidedata WHERE id = " & id
rs.open  st, conn, , , adCmdText

rs("firmother") = FirmDesc
rs("clind") = Clind
rs("firmname") = FirmName
    
rs.Update  '<<== LINE 101
rs.close()
%>

 

[rgbean]

Because I'm not familiar with ASP, are you actually using the VFP ODBC driver (what version) or the VFP OLEDB provider (what version)?

Rick

 

[myatia]

How do I find this out?

 

[rgbean]

The latest VFP OLE DB client (vfpoledb.dll - version 8.0.0.3117), is available at

http://www.microsoft.com/downloads/...8-7a94-4ae1-a59e-965869cb3bc9&displaylang=en.

While there is a newer one that comes with the VFP 9.0 public beta, it can't be separately downloaded.

The latest and last ODBC driver (vfpodbc.dll - version 6.1.8629.1) was released for VFP 6.0 - MDAC 2.6. There is a link to this driver at

http://msdn.microsoft.com/vfoxpro/downloads/updates/odbc/default.aspx.

Rick