Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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:

  1. Setting up an ODBC datasource to the FoxPro database.
  2. Creating a linked table to the ODBC datasource in an MS Access database...
  3. Generating a VIEW (a query in MS Access terminology) to select from the table in the foxpro database, so that...
  4. In SQL Server 2008 R2 I can create a Linked Server to the MS Access file...
  5. ...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.

share|improve this question

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.