General information
Category:
Visual FoxPro and .NET
Title:
Foxpro OLE DB Driver - Does it support updating???
Does anyone know if the foxpro OLE DB driver supports updating Foxpro databases?
The following code uses ADO to connect and attempt to edit a simple foxpro table.
If I use the ODBC connection string, it works. If I use the OLE DB connection string if causes an error something like
"object or provider is not capable of performing the required operation"
I have also being playing with visual studio .net, and get a similar problem. I can connect and retrieve data happily using the oledbdataadapter object, but updating, inserting or deleting foxpro tables fails every time.
the code listing (please change the file paths and table names if you want to try it)
&&&here is the ole db connection string
constr='Provider=VFPOLEDB.1;Data Source=C:\FXCLIENT\CSDATA\CSDATA.DBC;Mode=Share Deny None;Extended Properties="";User ID="";Password="";Mask Password=False;Cache Authentication=False;Encrypt Password=False;Collating Sequence=MACHINE'
&&&here is the odbc connection string
constr='DSN=testpms;UID=;PWD=;SourceDB=C:\fxclient\CSdata\csdata.dbc;SourceType=DBC;Exclusive=No;BackgroundFetch=Yes;Collate=Machine;'
&&here is the odbc connection string
con=Createobject("adodb.connection")
con.connectionstring=constr
con.Open
Sqlstr="select client,surname from clients where client='A0001'"
rs=Createobject("adodb.recordset")
rs.cursortype=2
rs.locktype=3
rs.Open(Sqlstr,con)
If Not rs.Eof
Messagebox("record found")
rs.Fields("surname").Value="test update"
rs.Update
Else
Messagebox("record not found")
Endif
rs.close
con.Close
RELEASE rs
RELEASE con
Next
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