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.