Hi,

Don't know if it's relevant but are you sending any empty dates?

HTH,
Arriyel

>After a few days..yes DAYS, of going around this matter, I take the liberty
>to go to you as a resort hoping that someone had gone through the same
>thing, or at least similar. Awaiting for some type of "light" that would
>help me clear the light-path along this devious road, following I detail
>something that has been classified as a "cancer" status during my daily
>work.
>
>
>Enviroment:
>
>OS: Windows XP Professional
>Web Server: IIS 5.0
>Plataform: ASP - VBScript
>DATA ORIGIN: DBC VFP 6.0
>ODBC: Microsoft Visual FoxPro Driver Ver. 6.01.8629.01 (VFPODBC.DLL)
>DSN: System
>
>
>Problem:
>
>It does not matter what type of update I give to any DBF belonging to DBC, I
>always get the same
>message:
>Microsoft OLE DB Provider for ODBC Drivers error '80004005'
>
>[Microsoft][ODBC Visual FoxPro Driver]Cannot update the cursor.
>
>The Driver in Spanish states: Incompatibilidad en el tipo de datos.
>
>The truth is that ALL the input of data is character and the tables' fields
>also (logically). Specifically, the last of the intents happens when an
>"INSERT INTO" is made, just the way it follows:
>
>Dim cConn
>
>Set cConn=Server.CreateObject("ADODB.Connection")
>
>cConn.Mode=adModeReadWrite
>
>cConn.Open "DSN=mercosurindex"
>
>
>MySQL="INSERT INTO sugerencias (des_cate, des_pais, URL, Desc, Nombre,
>Fecha, email) VALUES ('"
>
>MySQL=MySQL & strCate & "', "
>
>MySQL=MySQL & "'" & strPais & "', "
>
>MySQL=MySQL & "'" & strURL & "', "
>
>MySQL=MySQL & "'" & strDesc & "', "
>
>MySQL=MySQL & "'" & strNombre & "', "
>
>MySQL=MySQL & "'" & strDate & "', "
>
>MySQL=MySQL & "'" & strEmail & "')"
>
>Set RS=cConn.Execute(MySQL) HERE!!!!!
>Response.Write(MySql)
>
>cConn.Close
>
>set cConn=nothing
>
>
>I have exhausted all the possibilities and alternatives, since I have tried
>to change field by field individually, taking away the "date", etc. etc. but
>it always comes up with the same.
>
>Any ideas? Might it be a bug of the driver.dll?
>Tired...very much tired...... FAB
>
>By the way... I already tried in W2K Server and Advenced Server.....the
>same.