Need to add the FoxPro ODBC drivers on a server (2012R2) and they do not show uip on the list. Is there a way to add the 32 and 64 bit drivers for VFP Tables?
TIA, regards, Desmond
--- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---
Desmond,
The last I recall, there was not a 64-bit version of the VFP ODBC driver. To work with the 32-bit version of the ODBC driver, you need to start that app in 32-bit mode. Or you might find the app in the C:\Windows\SYSWOW64 folder. I don't recall the name of that tool off the top of my head.
HTH, Tracy
-----Original Message----- From: ProfoxTech [mailto:profoxtech-bounces@leafe.com] On Behalf Of Desmond Lloyd Sent: Monday, August 10, 2020 5:43 PM To: profoxtech@leafe.com Subject: ODBC for VFP Tables
Need to add the FoxPro ODBC drivers on a server (2012R2) and they do not show uip on the list. Is there a way to add the 32 and 64 bit drivers for VFP Tables?
TIA, regards, Desmond
--- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---
[excessive quoting removed by server]
You can see my old blog post https://saltydogllc.com/in-visual-foxpro-using-32-bit-odbc-drivers-on-a-64-bit-machine/ for how to add ODBC drivers, but if you're looking to add ODBC drivers for *VFP* tables, they stopped working after version 7 I believe.
Eric
On Mon, Aug 10, 2020 at 4:42 PM Desmond Lloyd desmond.lloyd@gmail.com wrote:
Need to add the FoxPro ODBC drivers on a server (2012R2) and they do not show uip on the list. Is there a way to add the 32 and 64 bit drivers for VFP Tables?
TIA, regards, Desmond
--- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html
[excessive quoting removed by server]
VFP's ODBC driver understands only DBF/DBC up to version 6. This means: All those new fieldtypes, database events etc from Version 7,8,9 render the MS ODBC driver useless, since he can't open such tables.
VFP7: Database Events VFP8: AutoInc, VFP9: VarChar, VarBinary, Blob
The MS OLEDB driver is more modern, and understands all of that stuff.
There are also Thirdparty ODBC drivers available, which are fully equipped. The "Advantage Database Server" (now from SAP) has a free ODBC driver.
wOOdy
-----Ursprüngliche Nachricht----- Von: ProFox profox-bounces@leafe.com Im Auftrag von Eric Selje Gesendet: Dienstag, 11. August 2020 03:53 An: ProFox Email List profox@leafe.com Betreff: Re: ODBC for VFP Tables
You can see my old blog post https://saltydogllc.com/in-visual-foxpro-using-32-bit-odbc-drivers-on-a-64- bit-machine/ for how to add ODBC drivers, but if you're looking to add ODBC drivers for *VFP* tables, they stopped working after version 7 I believe.
Eric
Desmond,
Devart supplies 32 and 64-bit xBase ODBC drivers that are VFP compatible.
Details in https://www.devart.com/odbc/xbase/.
On Mon, Aug 10, 2020 at 10:43 PM Desmond Lloyd desmond.lloyd@gmail.com wrote:
Need to add the FoxPro ODBC drivers on a server (2012R2) and they do not show uip on the list. Is there a way to add the 32 and 64 bit drivers for VFP Tables?
TIA, regards, Desmond
--- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html
[excessive quoting removed by server]
You need to use the c:\Windows\sysWow64\OdbcAd32.exe for configuring 32Bit drivers.
Also there are no 64bit drivers from Microsoft. And you can use 32Bit Drivers only from 32Bit Apps. Thus: Never ever install Office 64bit.
wOOdy
-----Ursprüngliche Nachricht----- Von: ProFox profox-bounces@leafe.com Im Auftrag von Desmond Lloyd Gesendet: Montag, 10. August 2020 23:43 An: ProFox Email List ProFox@leafe.com Betreff: ODBC for VFP Tables
Need to add the FoxPro ODBC drivers on a server (2012R2) and they do not show uip on the list. Is there a way to add the 32 and 64 bit drivers for VFP Tables?
TIA, regards, Desmond
--- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---
[excessive quoting removed by server]