-
1
- #1
Olaf Doschke
Programmer
Recently there were two posts to an old MSDN Foxpro General thread about the location of the VFP ODBC Driver.
The first one thanked for finding the download, the second recent one doesn't find it anymore.
To get the ODBC driver, you may download and install a runtime installer from where language resource DLLs, OLEDB Povider and also the ODBC driver are optional side installations of the core VFP runtimes. All Runteime Installers for VFP6+ should contain the latest VFP6 ODBC driver. In itself they can also help make VFP applications "migrated" by copying to a new machine run for customers not agnostic to keep setups for reinstallation or other ways of migration ie by image backup/restore.
You can still get several VFP9 downloads including the VFP9 OLEDB Provider from how long that may ever stay, but you don't have to wait for any newer downloads, and so if you don't have a central repository of all VFP related downloads especially for things not coming with VFP itself, it's a good time to take what you can still get.
I'd have to check, but IIRC the VFP9 CD does not contain the ODBC driver. The OLEDB Provider should be a possible side installation, but it's also not in the core VFP installation, since any DBF access in VFP is native, you only need these things for other software accessing DBFs, but it may be a central part of Mail Merging with MS Word, for example, if you do it from Word to DBC with Word defining a data source to a DBC/DBFs via ODBC or any other third party software was integrated with your databases. It may also be used and a loss, if a VFP database is used from MSSQL via linked server. So keep an eye on it, if there is still something valuable operative, candidate to need a fix or migration.
Bye, Olaf.
The first one thanked for finding the download, the second recent one doesn't find it anymore.
To get the ODBC driver, you may download and install a runtime installer from where language resource DLLs, OLEDB Povider and also the ODBC driver are optional side installations of the core VFP runtimes. All Runteime Installers for VFP6+ should contain the latest VFP6 ODBC driver. In itself they can also help make VFP applications "migrated" by copying to a new machine run for customers not agnostic to keep setups for reinstallation or other ways of migration ie by image backup/restore.
You can still get several VFP9 downloads including the VFP9 OLEDB Provider from how long that may ever stay, but you don't have to wait for any newer downloads, and so if you don't have a central repository of all VFP related downloads especially for things not coming with VFP itself, it's a good time to take what you can still get.
I'd have to check, but IIRC the VFP9 CD does not contain the ODBC driver. The OLEDB Provider should be a possible side installation, but it's also not in the core VFP installation, since any DBF access in VFP is native, you only need these things for other software accessing DBFs, but it may be a central part of Mail Merging with MS Word, for example, if you do it from Word to DBC with Word defining a data source to a DBC/DBFs via ODBC or any other third party software was integrated with your databases. It may also be used and a loss, if a VFP database is used from MSSQL via linked server. So keep an eye on it, if there is still something valuable operative, candidate to need a fix or migration.
Bye, Olaf.
