[Answers] VFP ODBC Driver

[josipradnik]

MS VFP ODBC Driver does not support the 'Integer (AutoInc)' data type. If a table has AutoInc fields, the VFP ODBC Driver will report (can be seen in Lianja debug file):
'error=[Microsoft][ODBC Visual FoxPro Driver]Not a table.'
Q:
Is there anyway of connecting to an existing backend VFP database?
A:
Use an ODBC Driver for VFP and Lianja Virtual Tables.

---

Q:
I know vfpoledb is really just activex.. Are there any issues using vfpoledb to connect to my vfp tables and doing updates... I'm going to be running parallel with our old system... I was told that lianja itself can open vfp tables and update them, however, the indexes don't update...
A:
I have not tried it but if you install the vfpoledb driver then in Lianja;

SET DEBUG ON
vfpda = createObject("OLEDB.Connection")

I'd be interested to see if it loads and what is in debug_client.txt

---

Q:
I'll use odbc then.. I was going to only use the prgs for reports.. this way I could tweak them on the fly without a recompile...
A:
Then you would need to set the connectionstring.
vfpda.ConnectionString = "Provider=VFPOLEDB.1;.....

---

---

​All topics in [Answers] alphabetically:http://www.lianja.com/community/show...ll=1#post12352