Link to home
Start Free TrialLog in
Avatar of woodwyn
woodwynFlag for United States of America

asked on

FoxPro app with SQL ODBC connection won't run on 64 bit system

We've added our first 64 bit system to our domain.  Per our usual new system setup we installed the VFP 6 libraries, created an ODBC SQL connection ("CES SQL") and are trying to run our VFP app over it.  The ODBC Data Source Administrator allows me to connect to the 2000 SQL server and tests OK, but when we run the FoxPro app it generates an Invalid Handle error message and cannot connect to the SQL server.  

Users are added to a group on the domain ("VFPAppUsers").  This group is a login on the SQL server.    

Is there anything we need to do differently for 64 bit systems to run our VFP app over an ODBC connection?  It's not something stupid like the space in the connection handle ("CES SQL")?
ASKER CERTIFIED SOLUTION
Avatar of Pavel Celba
Pavel Celba
Flag of Czechia image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
The second problem is, when you setup SQL Server to use shared memory or pipes for local connections. As VFP is 32bit these technologies can't work from a 32bit process to a 64bit process, you need to allow a remote tcp/ip connection even for a local VFP app towards the SQL Server.

Bye, Olaf.
Olaf, does SQL 2000 has 64 bit version? I am also not sure about the possible connection options but pipes could be avaibale.
Avatar of woodwyn

ASKER

Using \Windows\SysWoW64\Odbcad32.exe did the trick.