Accessing a SQL Server 7 db from a 64-bit workstation

  • Greetings to the group!

    We have a situation where something works when using a 32-bit workstation, but not from a 64-bit workstation.

    At a particular point in time, the application runs a command from a prompt...

    call "\\ACCHENDAF01\c$\program files\idea2000\genFea\exe\AccufastLSF.exe" 3505

     

    the AccufastLSF.exe is a compiled executable written in VB (or so I have been told.) I doubt we have the source code for it.

     

    We have checked the ODBC (when tested, it makes the connection fine). The only problem is that when this call is executed, it does not work on the 64-bit system.

     

    The database is a SQL Server 7 SP2 database. I guess my big question to start troubleshooting is this... can you send a call to a SQL Server 7 database from a 64-bit workstation?

     

    Any insight would be greatly appreciated!

     

    Bob

  • What OS is the workstation running?  And is it true 64 bit hardware or is it 32 bit with 64 bit extensions?

    /*****************

    If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek

    *****************/

  • It is a true 64-bit OS

  • Windows?

    /*****************

    If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek

    *****************/

  • Yes... windows

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply