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
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only