VFP ODBC drivers and Stored Procedures

[DennisKeith]

I have a VFP6 database in which I have some stored procedures that are used to generate keys that are unique to each table contained within the database. The system is designed to handle multiple users with simultaneous requests by RLOCKing on a central key table. The primary stored procedure is called GetKey and is passed the parameter of the table name. The default value for the unique key field is set to be GetKey('TableName') and all of this works exceptionally well within Fox. I am now trying to access this database from VB and am having some problems.

1. The default condition, if it is a stored procedure call, is not handled when doing an INSERT through ODBC.

2. The VFP ODBC driver apparently does not support stored procedures and I can't figure out how to get the value for the unique key field directly from VB.

3. I have created a Fox dll that seems to work on the machine on which I created it but when that is shifted to another machine on the LAN, I get the everpresent ActiveX Object can't be created message.

This has to be a common problem and I know there must be a solution out there somewhere - I'm just too dumb to see it. All I really need is a truely unique key under the condition of many simultaneous requests. Any help would be greatly appreciated.

Thanks

Dennis Keith