I&#039ve set a DSN on a FoxPro database and tried to get connect to it and manipulate it. Below is a clip from my coding:<BR><BR>Set qConn = server.CreateObject("ADODB.Connection")<BR>qConn.O pen "game1"<BR>Set qRs = Server.CreateObject("ADODB.Recordset")<BR>qRs.Open "question", qConn, adOpenDynamic , adLockPessimistic<BR><BR>where game1 is DSN and "question" is the table i&#039m trying to open and update.<BR><BR>the error appear<BR>Error Type:<BR>Microsoft OLE DB Provider for ODBC Drivers (0x80040E21)<BR>ODBC driver does not support the requested properties.<BR>/game1/test.asp, line 18<BR><BR>where line18 is the line of code trying to open table "question".<BR><BR>Is there any setting wrong? I&#039ve already include the file "ADOVBS.INC".