[galvo_clare]

Hi

Our accounts system (Pegasus Opera) is off the shelf 32 bit software and based on MS Foxpro files.
We also have a separate sales booking system, which is written and supported by a third party.
Everything worked fine under 32 bit XP Pro.
We have now switched to Windows 7 64 bit and both Pegasus and the sales system work fine.
What doesn't work is a custom import routine which was written to link the two systems. i.e. sales orders are imported automatically into the accounts system for invoices to be raised etc.
The problem seems to be than MS never released ODBC drivers for Foxpro under W7 64 bit.
Any ideas how to get around this?

[Torqay]

Originally Posted by galvo_clare

The problem seems to be than MS never released ODBC drivers for Foxpro under W7 64 bit.

1. Visual FoxPro, a 32-bit application, runs just fine on 64-bit machines.
2. Visual FoxPro cannot use 64-bit ODBC drivers however.
3. You can use 32-bit ODBC drivers on 64-bit Windows, but you must set them up in the 32-bit ODBC Administrator. This is not the one that’s going to come up if you go through Control Panel. To invoke it, run C:\Windows\SysWow64\odbcad32.exe and add your DSNs there.
4. Do not just Start, Run, ODBCAd32.exe, as it will not bring up the right one.
5. The 32-bit drivers for SQL Server come with Windows 7 x64, so you don’t have to download them.

via Salty Dog Solutions.

Originally Posted by galvo_clare

Everything worked fine under 32 bit XP Pro.

If all fails then there is XP Mode for Windows 7. Business computers with Windows 7 Professional have this option to deal with this type of compatibility issues.

[galvo_clare]

Originally Posted by Torqay

1. Visual FoxPro, a 32-bit application, runs just fine on 64-bit machines.
2. Visual FoxPro cannot use 64-bit ODBC drivers however.



via Salty Dog Solutions.

Thanks

That looks to be very useful.