cvi crashes at run time with sql in ms compitability mode

[aplication_developper]

Hi there

I have wrote a program on cvi 7.1 that involves sql
windows 2000 , sql toolkit 2.05

when the program runs in standalone exe in borland comp. mode all OK.
when the program runs in MS comp. mode under the debuger all OK no warning or errors during compilation and run time.

BUT...
when the program runs in standalone exe in MS comp. mode the program crashes.
I have isolated the exuct line that make the error:
DBerrorCheck(DBFetchNext(hStmt)) ;
DBerrorCheck -> amacro that checs the return status off the function call

Please advice how to resolve this mess

Gabel Daniel
Chaban Group
chaban@netvision.net.il

[Wendy L]

Hello Gabel,

Are you doing all your testing on the same machine? As in, do you switch from MSVC to Borland mode, and vice versa on the same machine? If not, I would make sure that you have the same version of your ADO on your test and development machine. Also, if you deploying your application incorrectly, you could be seeing similar issues. Instructions on how to deploy an application that uses the SQL toolkit functions are found in the SQL toolkit release notes.

On the other hand, if you are doing all your testing on one machine, do you see the incorrect behavior when you run the release executable from within the CVI environment, or only when you run the standalone executable?

Thanks.