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.
If it's not broken, fix it until it is.
My Blog