woodwyn
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")?
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Olaf, does SQL 2000 has 64 bit version? I am also not sure about the possible connection options but pipes could be avaibale.
ASKER
Using \Windows\SysWoW64\Odbcad32 .exe did the trick.
Bye, Olaf.