Extracting XML content from an XML file from within SQL Server 2000 using Managed Code - Deploying the .NET component

(Page 3 of 5 )

In the previous section, you just completed developing the component.  Now you need to register as COM component and also deploy into GAC cache.  Proceed with the following steps to do this:

• If you didn’t open your Visual Studio command prompt, do it by going to Start -> Programs -> Microsoft Visual Studio.NET 2003 -> Visual Studio.NET tools -> Visual Studio.NET 2003 Command Prompt.
• Go to the “bin” folder of your project folder (which is “Utility”), using the command prompt.
• Type the following command to register the assembly as COM component:

Regasm /tlb:Utility Utility.dll

• After receiving a successful message, again type the following command to get the component registered within GAC cache.

gacutil /I Utility.dll

The screen should look something like the following (Fig1):

That completes your deployment. 

In case you want to unregister the component (say you may want to modify the code after successful registration), you can use the following commands (separately) to do the same (from the same bin folder):

Next: Testing the .NET component from within SQL Server 2000 >>
 

More XML Articles
More By Jagadish Chaterjee

Comments On: Extracting XML content from an XML file from within SQL Server 2000 using Managed Code

· Hello, did you ever work with Managed code with SQL Server 2000 (together with...   >>> Post your comment now!