Hmmmm. That's odd. Have you tried using UNC instead of a mapped drive? Also, just so you know, the VFP driver doesn't support static recordsets. Even though you're specifying adOpenStatic with that 3 in the third argument, that's not what you'll get. You'll get the default adOpenForwardOnly (0).
>I'm having problems pulling records out of a Visual FoxPro table
>(*.dbf) using the MS ODBC driver (v.6.00.8440) included on NT4.
>
>Here's how the ASP application is setup:
>I setup a System DSN that points to a VFP table on a MAPPED drive on
>the NT/IIS server. The code is very simple:
><%
>Set conn = Server.CreateObject("Adodb.Connection")
>conn.Open "DSNName"
>SQL = "SELECT FieldNames FROM VFPTableName"
>Set rs = Server.CreateObject("ADODB.Recordset")
>rs.Open sql, conn, 3, 3
>%>
>
>The code above will return the following to the browser window:
>"Microsoft OLE DB Provider for ODBC Drivers error '80040e21'
>The request properties can not be supported by this ODBC Driver."
>
>When I change the DSN to point to a LOCAL drive, the data is returned
>just fine. Also, I recreated my ASP application with a simple VB
>application that returns data from the same table and same DSN on the
>MAPPED drive. This leads me to believe this is IIS or ASP related and
>NOT ODBC. Can anyone help? Thanks in advance!!
>
>Scott Adams
>
sadams@commanddata.com
"It is an important and popular fact that things are not always what they seem. For instance, on the planet Earth, man had always assumed that he was more intelligent than dolphins because he had achieved so much -- the wheel, New York, wars and so on -- whilst all the dolphins had ever done was muck about in the water having a good time. But conversely, the dolphins had always believed that they were far more intelligent than man -- for precisely the same reasons." - Douglas Adams
