Please help...
I have upgraded yesterday from VFP7 to VFP8 as a client has given me VFP8 data that must be read from "classic" asp.
I only have the error when I acces the new VFP8 tables. VFP7 tables are still accessed fine.
The first time I used it I was informed that I needed to upgrade the driver. I previosuyl had version VFOXODBC 1.xxx something. I am running on Windows XP Professional, and VFP7 was the only version of VFP ever installed on this machune. I followed the instructions and went to msdn.microsoft.com/vfoxpro and downloaded the recommended latest driver. I now have VFPODBC 6.0.1.8629.01 though somewhat mysteriously it has a date on it of 7/12/99 (uk format date dd/mm/yy) when listed in the Control Panel > Admin Tools > Data Sources > System DSN . DSNs for both VFP7 tables and VFP8 tables are here, but only the DSN that accesses VFP7 functions correctly.
Any ideas? TIA
John
ASP via the following code:
<%
Dim Recordset1
Dim Recordset1_numRows
Set Recordset1 = Server.CreateObject("ADODB.Recordset")
Recordset1.ActiveConnection = MM_ins2_STRING
Recordset1.Source = "SELECT * FROM access"
Recordset1.CursorType = 0
Recordset1.CursorLocation = 2
Recordset1.LockType = 1
Recordset1.Open()
Recordset1_numRows = 0
%>
I have a connection string defined as follows:
<%
' FileName="Connection_odbc_conn_dsn.htm"
' Type="ADO"
' DesigntimeType="ADO"
' HTTP="false"
' Catalog=""
' Schema=""
Dim MM_ins2_STRING
MM_ins2_STRING = "dsn=ins;"
%>