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