Hi

I am presently changing the retrieval method of an existing FoxPro 2.6 application to retreive information from the SQL Server 7.0 instead of *.dbfs. I am using dbconnect(), dbexec(), dbdisconn() and setting the library to fpsql. I also created an ODBC connection and downloaded the lastest ODBC connection kit from microsoft. I am using Windows 95 as an operating system and using Novell 2.0 (network) .

The problem is that I cannot retrieve info from the database in the SQL Server that have unique ids as a field type. If I select only the fields that I need that do not have the unique id field type (using the dbexec() command), the retrieval is a success dbexec() returns 1. If one of the fields in which I execute the retrieval has the unique id field type (using the dbexec() command) the retrieval is not a success and dbexec() returns -1.
Is there something I can use/add that can use in order to retreive the unique ids?

Thanks for your help and input in advance....

-Nina