General information
Category:
Internet applications
Hi,
What is the actual DataBasePath on the server?
>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.
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only