I have a program that works correctly in the development and runtime environment of VFP7 which does an ODBC SQLCONNECT() to a MS-SQL Server data source. The SQLCONNECT(), SQLPREPARE(), etc. commands all work properly when testing. However, when I attempt to execute the program under the Citrix Metaframe environment(Terminal Server) as an ICA Client it get the following error:

ERROR # = 1527 - Cannot load ODBC library, ODBC32.DLL

Has anyone else gotten this? It may be related to the access rights that the client needs to access the library but we're not sure. Surely this is a problem that has been hit upon before by anyone running VFP / ODBC / Citrix. Any help would be greatly appreciated.

Thanks!

Jim White