> > > Is there a new ODBC Driver for VFP8? If so where can you find it? TIA.
> > > Buffiie
> >
> > I belive the new driver is the OLEDB driver that first shipped with VFP 7. (VFPOLEDB).
> >
> > The Version installed with VFP 8 is : 8.0.00.2521
> >
> > Simon Arnold.
> I have vfp8 installed and running on winxp. I try to set up an odbc connection and it tells me I must get the latest driver from microsoft. Any ideas? TIA.
>
> Buffiie

The last ODBC Driver that was available for VFP is the one that ships with VFP 6, this is the download link.
http://www.msdn.microsoft.com/vfoxpro/downloads/addons/odbc.asp

To use the new VFPOLEDB driver you can't set up an ODBC driver, you need to connect via a DSN-less connection, also this new driver allows access to VFP tables from other languages like VB, C#, VB.NET, etc..

CLEAR
LOCAL oConn as "adodb.connection"
LOCAL oRS as "adodb.recordset"
oConn = CREATEOBJECT('adodb.connection')
oRS = CREATEOBJECT('adodb.recordset')
cConnStrng = "Provider=vfpoledb;Data Source="+HOME(2)+"northwind\northwind.dbc"
oConn.Open(cConnStrng)
oConn.BeginTrans()
oConn.Execute("UPDATE Customers SET contactname = 'Patricio X. Simpson';
   WHERE customerid='CACTU'")
oRS = oConn.Execute("SELECT * FROM customers WHERE customerid = 'CACTU'")
?oRS.Fields("contactname").Value
oConn.RollbackTrans()
oRS.Requery()
?oRS.Fields('contactname').Value
oRS.Close()
oConn.Close()

Hope this helps.

Simon Arnold.