>Hi, Naomi,
>
>Yes, I can, but it doesn't change the outcome - works locally and failed on server
>

If you switch to VFPOleDB what error you're getting?

Also, is directory with VFP tables is opened?

>>Hi Irina,
>>
>>Can you use connection string with VFPOleDb instead? And also, can you use parameter instead of the string concatenation?
>>
>>>Hi all,
>>>
>>>I need a help with the weird behavior.
>>>Really simple ASP script trying to update VFP table. Perfectly works on the LOCALHOST (MDAC 2.8 SP2 for WINDOWS XP), but failing on the server(latest MDAC for SERVER 2003) - "ODBC driver does not support the requested properties".
>>>
>>>ASP script
>>>***********************************
>>>sqlStr = ""
>>>sqlStr = sqlStr & "UPDATE " & cTableMast & " SET client_no = '"
>>>sqlStr = sqlStr & TRIM(cCl_number)
>>>sqlStr = sqlStr & "'"
>>>rss.Open sqlstr, connStr, 1,3
>>>***********************************
>>>
>>>Connector to the VFP table
>>>***********************************
>>>set cn = Server.CreateObject("ADODB.Connection")
>>>cDatabasePath = Server.MapPath("/DATA")
>>>connstr = "Driver={Microsoft Visual FoxPro Driver}; UID=;SourceDB="&cDatabasePath&";SourceType=DBF;"
>>>cn.Open connstr
>>>
>>>adOpenStatic = 3
>>>Set rss = CreateObject("ADODB.Recordset")
>>>***********************************
>>>
>>>Will appriciate any advise.