HI

I have to copy a large text file with records in sql server.
so i created a windows service using stored procedure for actuak work,
It worked fine but when the file gets bulky around 70-80 mbs it failed
can anyone tell how to modify my windows service or tell some another better way.
I am using bulk insert in the backgrounnd.

avats

hi avats,

wht do u exactly mean by "it fails"???????
does it give sum Error???

Ashu

hi ashu

fails means it didn't work but i work out a solution for that problem

Now ,do u have any knowledge how to install any Windows service developed on my computer to another computer having same version of vs.net installed as that on mine.I added a installer to the developed Window service which worked fine if i have to install on my computer on which i developed it but didn't install that service on other computers.

how can i do it


thanx

Anand

Hi Anand

After long time of browsing the web I finally found an article describing how to install/uninstall a service with only two lines of code.

Install:

String []installParams= {filename};
System.Configuration.Install.ManagedInstallerClass .InstallHelper(installParams);

Uninstall:

String []installParams= {"/u", filename};
System.Configuration.Install.ManagedInstallerClass .InstallHelper(installParams);

You have to add System.Configuration.Install reference manually.

Ashu

hi ashu

thanx for looking forward

but where i have to use these 2 lines of code
In which file of the installation package created by VS.NET i have to insert the lines and where to insert it?

pl clarify a bit to me on it
can u tell me webaddress of the article/site/code for these lines , so that i can look at it

thanx

Anand

hi anand,

actually i saw tht article on Google
and i dont exactly remember the web link :(


Ashu

Hi all,
       I want to knw as to how we install windows service in a remote system i searched the web but i get all unclarified ans so if any 1 knws it please tell me

Karthi