thank you for the information. Yes i am working in VB.net. when i was not able to register a dll created with vb.net i tried VB 6.0. Now VB6 dll is working fine. i am calling this dll using a trigger which is for INSERT record. But when my application inserts a record to the table, Trigger runs succefully but record is not inserted and gives this Error:
Description: Receipt. Database error (operation=INSERT, error=0). [Microsoft][SQL Native Client]Connection is busy with results for another command Please refer this error to your database administrator or see your database documentation for further assistance.
Source: 12:27:08

so i want to try , call a VB script from sql. if it possible and if u know about this, pls tell me how can i proceed.

You will also need to give the user in SQL Server "special" permission to run external DLL's. See the documentation for sp_oacreate.

You may want to check permissions like CornerAnalyst suggested. However, I think you would get a different error message if it were permissions.

Here's another MS TechNet forum thread. It's for VB.NET but I think the points in that thread can apply to VB6 too. The two points that might cause that error are inserting a null value to a "not null"-field and explicitly disposing data-adapter commands. So in the case of VB6 the issue may come from any previous command (or command object to be more precise).

Also, the SQLProfiler was mentioned. It might be worth to try to see what actually happens.

Teme64 already showed you how to create a class in vb.Net, compile the code to a DLL, and register it.

If you are using VS just go to the BUILD menu item and it will be done for you automatically.

What problem are you having with Teme65's instructions?