Advertisement
If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)
Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie

Foxpro ODBC driver for Windows 7 64 bit

Options
  • 13-04-2012 11:16pm
    #1
    galvo_clare
    Registered Users Posts: 678 ✭✭✭


    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?
    Tagged:


Comments

  • Options
    #2
    Torqay
    Closed Accounts Posts: 5,835 ✭✭✭Torqay


    galvo_clare wrote: »
    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.
    galvo_clare wrote: »
    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.


  • Options
    #3
    galvo_clare
    Registered Users Posts: 678 ✭✭✭galvo_clare


    Torqay wrote: »
    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.


Advertisement