Sound to me like Ric is on the right track, the DLL is not registered. However - how was the DSN created in the ODBC Administrator? For all users to see the available connection it must be created as a System DSN. Otherwise, you will have to individually configure each user. Also, if you installed an updated version of MDAC, make sure to do it through Add/Remove Programs to ensure things get loaded where they are supposed to.
HTH,
Randy
>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
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement