Now I know this is a looong shot...but it appears to me that it might be possible to access my dumpy, legacy, FoxPro, Free Table directory, based database from Postgresql by:
- Setting up an ODBC datasource to the FoxPro database.
- Creating a linked table to the ODBC datasource in an MS Access database...
- Generating a
VIEW
(a query in MS Access terminology) to select from the table in the foxpro database, so that... - In
SQL Server 2008 R2
I can create aLinked Server
to the MS Access file... - ...and finally use a FDW in Postgres 9.3.4 to access the data waaaay back in the Free Table Directory.
I may be going about this the long way around, but from what I can tell the odbc fdw doesn't work for Postgres versions higher than 9.1.
Does this sound possible? Should I even bother trying this? I already know steps 1 - 4 work, but I'm not certain about step 5.
Also I have a hunch that since I installed the 64-bit version of Postgresql on Windows, it's not going to work anyway since the database's that I'm trying to access are all 32-bit.