I seem to have a lot of problem using ADO through VFP ODBC. It either doesn't work or it only works occassionally. Anyone knows why is that so? I can't make it work even if it is adCmdTable type.


oConn = Server.CreateObject("ADODB.Connection");
oConn.Open("logolist");

oRs = Server.CreateObject("ADODB.Recordset");
oRs.Open("SELECT * FROM logocategory", oConn, adOpenStatic, adLockOptimistic, adCmdText);

oRsLogo = Server.CreateObject("ADODB.Recordset");
oRsLogo.Open("select * from logolist where imageid=" + lLogoid, oConn, adOpenStatic, adLockOptimistic, adCmdText);
oRsLogo("category") = lCat;
oRsLogo("type") = "L*";

oRsLogo.Update();