I need an ActiveX component, Module, or class object written for vb will preferably take an ADO recordset as a parameter (or any custom dynamic array structure) and execute the SQL statements in one field, and write error codes (if encountered) into another field.? Commits can be performed whenever, as long as the individual records have error codes assigned to them.? To be more clear, if a commit is performed every 1000 records and fails, the specific records in the 1000 have to be singled out, and the rest attempted again.
The component would have to be written to directly access the Interbase client API, and in all cases must get at least? 1500 transactions per second (higher tests could get bonuses)? to a V7.1 Interbase server on the local network.? The test data that must be used is 15 character fields with an average of 30 characters per field, per record.? Tests must be performed with 100K, 250K, 500K, and 1M records.
My own understanding is that this would have to be written in C since the Interbase Client Library is not written with stdcall. Any language is acceptable as long as the required speed is attained. An external script or executable is not desired. Any code must be able to operate within VB6 itself. On this particular network the IB servers have been tested to 15,000 tps. This was accomplished with the same IB server and a Visual C++ front-end using native borland IB objects. I would imagine that the component would be written using pretty much the same methods and be called from VB.
1) Complete and fully-functional working? component in executable form as well as complete source code of all work done.
2) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).
Visual Basic 6.0, Windows 2000 SP4, and Interbase V7.1