I am getting this error on our production server but not our test =
server. ODBC driver is version 3.5.06 on both. However, our test server =
is 4.1.14 and our production server is 4.1.8. I am getting the =
following error when trying to update a text datatype field using ADO:
"Microsoft Cursor Engine (0x80004005)
Data provider or other service returned an E_FAIL status."
The error occurs when I call the ado update method (rs_update.update()). =
Could this be due to production being an older version of MySQL or could =
it be something else? Below is the system configuration and the code I =
am having trouble with.
Prod System Info:
Windows 2000
MDAC 2.8
MyODBC 3.5.06
MySQL 4.1.8
Test System Info:
Windows 2000
MDAC 2.8
MyODBC 3.5.06
MySQL 4.1.14
Code:
Set RS_Update=3Dcreateobject("adodb.recordset")
RS_Update.cursorLocation=3DadUseClient
set objXMLStream=3Dcreateobject("adodb.stream")
objXMLStream.type=3DadTypeText
strSQL=3D"select * from fbappuserprefs where appsys=3D'" & me.appsys & =
"' and userid=3D'" & me.loginid & "'"
RS_Update.open strsql, thispage.dataconn, adOpenStatic, =
adLockOptimistic
if RS_Update.eof=3Dtrue then
rs_update.addNew=09
rs_update.fields("AppSys").value=3Dme.appsys
rs_update.fields("userid").value=3Dme.loginid
end if
=09
objXMLStream.open
objXMLStream.writeText strXML
objXMLStream.SetEOS
objXMLStream.position =3D 0
rs_Update.fields("xml")=3DobjXMLStream.readText
rs_update.update()
objXMLStream.close()
me.appPrefs=3Drs_Update.fields("xml")
rs_update.close()
Set objXMLStream=3Dnothing
Set RS_Update=3Dnothing
--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=3Dgcdmw-win32 [at] m.gmane.org
