Re: windows service - C# Discussion Boards

14-Jul-08 21:45

Hi,
I have developed a windows sservice on my dev machine.
The project installer is also created.
This service is tested on my machine and it is fine.

Now I would like to give it to the management to install/run it on the required machine.

Question:

How should this windows service application be setup on the requred machine which may or may not have .net framework?

Thanks

J4amieC14-Jul-08 21:53

J4amieC

14-Jul-08 21:53

if(!TargetMachineHasDotNetFramework)
{
  InstallRequiredDotNetFramework();
}
InstallWindowsService();

well, you did ask in the C# forum.

arkiboys14-Jul-08 21:56

14-Jul-08 21:56

I think you mis-understood.
I would like to know how to install the windows service on another machine? I mean do I just copy the whole development codes to the other machine, etc?
Thanks

J4amieC14-Jul-08 22:07

J4amieC

14-Jul-08 22:07

You said you had an installer for your service, wouldn't logic tell you to install your service you would use the installer?

arkiboys14-Jul-08 22:16

14-Jul-08 22:16

On my machine which has visual studio, I run the vs command to install or un-install the service.
The question is:
What do I do if this service needs to be installed on another machine? If the installer is required for this purpose, then how do I run it on another machine. I believe I can not get vs command on the other machine.
Hope you follow my question.
Thanks

J4amieC14-Jul-08 22:42

J4amieC

14-Jul-08 22:42

arkiboys wrote:
What do I do if this service needs to be installed on another machine

Easiest way is to create an installer, take that installer to the other machine and run it.

A Google search[^] will provide you with a plethora of information on the subject.

wurzel_cidermaker14-Jul-08 22:45

wurzel_cidermaker

14-Jul-08 22:45

To install the Windows Service on another machine you would add a
Setup project to your solution which would then create an MSI package.

Run the MSI package on the target machine and this will create the Windows Service.

Obviously you would need the relevant .NET Framework version on the target machine.

arkiboys15-Jul-08 3:14

15-Jul-08 3:14

Can I do this by the click once method to install the service on another machine?
Thanks

How to set batch file argument in "Execute Process Task" (SSIS Packages)

leppie15-Jul-08 3:16

leppie

15-Jul-08 3:16

I highly doubt ClickOnce will work for services Smile | :)

xacc.ide - now with TabsToSpaces support
IronScheme - 1.0 alpha 4a out now (29 May 2008)

saving into database

Metik14-Jul-08 21:36

Metik

14-Jul-08 21:36

Hi,

How can i save value from textbox into database
or change some value in database with value in textbox.

Re: saving into database

leppie14-Jul-08 22:28

leppie

14-Jul-08 22:28

Read some books/tutorials, your question is so vague, I assume you are a beginner. You will need some background knowlegde on the process, but once you do, you will find it is trivial Smile | :)

xacc.ide - now with TabsToSpaces support
IronScheme - 1.0 alpha 4a out now (29 May 2008)

Re: saving into database

Rupesh Kumar Swami14-Jul-08 22:28

Rupesh Kumar Swami

14-Jul-08 22:28

i think you need to first learn Database Programming in C# Smile | :)

Rupesh Kumar Swami
Software Engineer,
Integrated Solution,
Bikaner (India)

My Company
My Article

Chintan.Desai14-Jul-08 21:27

Chintan.Desai

14-Jul-08 21:27

Hi Guys,

I have one batch file. I set argument in it and when I double click the bat file,it work perfectly Smile | :)

. Argument only suggest to execute other SSIS packages on a given path.

Argument is:

FOR %%V IN (*.dtsx) DO dtexec /f "%%V" /Config "cfg%%~nV.dtsConfig" >> log_PkgExecution.txt
pause

Now, I want to set the same argument in SSIS Package called "Execute Process Task" in Execute Process Task editor -> Argument property. I did it, but getting problem during execution.

On executing the package, DOS prompt is coming blank...

I think, it is not getting the argument...

Please help, if I am doing something wrong.

Thanks in advance.

Chintan

Re: How to set batch file argument in "Execute Process Task" (SSIS Packages)

leppie14-Jul-08 22:29

leppie

14-Jul-08 22:29

Chintan.Desai wrote:
On executing the package, DOS prompt is coming blank...

It will be. You are redirecting output to the log_PkgExecution.txt file. Have a look in there.

Your question is also not C# related.

xacc.ide - now with TabsToSpaces support
IronScheme - 1.0 alpha 4a out now (29 May 2008)

Re: How to set batch file argument in "Execute Process Task" (SSIS Packages) [modified]

Chintan.Desai14-Jul-08 23:07

Chintan.Desai

14-Jul-08 23:07

Thx for the reply Smile | :)

Log file is showing the following:

Microsoft (R) SQL Server Execute Package Utility
Version 9.00.1399.06 for 32-bit
Copyright (C) Microsoft Corp 1984-2005. All rights reserved.

Started:  12:19:02 PM
DTExec: Stopping the package execution.
Started:  12:19:02 PM
Finished: 12:19:10 PM
Elapsed:  7.938 seconds

I couldn't see the rows affected in my DB by packages which are executed by this bat file...In short, this batch file is not executing the argument.

Regards
Chintan

modified on Tuesday, July 15, 2008 5:18 AM

ORA-00936:mising expression

varun_mca_ju14-Jul-08 21:20

varun_mca_ju

14-Jul-08 21:20

I have a textbox called "textBox6.text" in a C# Windows Application in Visual Studio, and i want that the text entered by the user in the textbox should be added to the "PURPOSE" field in a table "TABLE2_HDB1" in Oracle database "HDB1" on clicking a "submit" button.

the coding for submit button is as follows:-

private void button1_Click(object sender, EventArgs e)
{
string OracleStmt;
string ConString;
OleDbConnection cn = null;
OleDbCommand cmd = null;
try
{
OracleStmt = "insert into TABLE2_HDB1(PURPOSE) values(@PURPOSE)";
ConString = " Provider=MSDAORA;Data Source=HDb1;User Id=SYSTEM
;Password=*****;";
cn = new OleDbConnection(ConString);
cmd = new OleDbCommand(OracleStmt, cn);
cmd.Parameters.Add(new OleDbParameter("@PURPOSE", OleDbType.VarChar , 20));
cmd.Parameters["@PURPOSE"].Value = textBox6.Text;
cn.Open();
cmd.ExecuteNonQuery();
textBox8 .Text = "record inserted successfully";
}
catch (Exception ex)
{
textBox8 .Text = ex.Message;
}
finally
{
cn.Close();
}
}
on executing this code u get the error :-
ORA-00936:missing expression
plz. help Confused | :confused:

Crystal Report Help

Saiyed Alam14-Jul-08 20:59

Saiyed Alam

14-Jul-08 20:59

Hello friends can any one tell me how can I get the total number of records found and print that on top my report?

error monitoring thread status

George_George14-Jul-08 20:58

Exception in EventLog.WriteEntry

14-Jul-08 20:58

Hello everyone,

When using !threads command to monitor thread status for a dump, there is an error message. Does anyone meet this before? What is wrong?

0:001> !threads
Failed to load data access DLL, 0x80004005
Verify that 1) you have a recent build of the debugger (6.2.14 or newer)
2) the file mscordacwks.dll that matches your version of mscorwks.dll is
in the version directory
3) or, if you are debugging a dump file, verify that the file
mscordacwks_<arch>_<arch>_<version>.dll is on your symbol path.
4) you are debugging on the same architecture as the dump file.
For example, an IA64 dump file must be debugged on an IA64
machine.
You can also run the debugger command .cordll to control the debugger's
load of mscordacwks.dll. .cordll -ve -u -l will do a verbose reload.
If that succeeds, the SOS command should work on retry.
If you are debugging a minidump, you need to make sure that your executable
path is pointing to mscorwks.dll as well.

thanks in advance,
George

George_George14-Jul-08 20:45

14-Jul-08 20:45

Hello everyone,

The exception is occured in EventLog.WriteEntry, error message and error stack are listed below. Does anyone have any ideas?

"A device attached to the system is not functioning"

System.Diagnostics.EventLog.InternalWriteEvent(UInt32, UInt16, System.Diagnostics.EventLogEntryType, System.String[], Byte[], System.String)
System.Diagnostics.EventLog.WriteEntry(System.String, System.Diagnostics.EventLogEntryType, Int32, Int16, Byte[])
System.Diagnostics.EventLog.WriteEntry(System.String, System.Diagnostics.EventLogEntryType, Int32)

thanks in advance,
George

N a v a n e e t h14-Jul-08 21:25

N a v a n e e t h

14-Jul-08 21:25

George_George wrote:
A device attached to the system is not functioning

I guess some required DLL's are missing. Are you getting this for all application or only for this one ?

All C# applications should call Application.Quit(); in the beginning to avoid any .NET problems.- Unclyclopedia

How to use google | Ask smart questions

George_George14-Jul-08 22:13

14-Jul-08 22:13

Only for this application, N a v a n e e t h!

And this happens only once, looks strange. Any ideas? What do you mean DLL missing? Which DLL? CLR DLL?

regards,
George

S. Senthil Kumar15-Jul-08 9:12

S. Senthil Kumar

15-Jul-08 9:12

Was the event log full by any chance? IIRC, the default setting is to overwrite entries older than a specific date, and if there are lot of events after it, the event log could get full.

Regards
Senthil [MVP - Visual C#]
_____________________________
My Blog | My Articles | My Flickr | WinMacro

George_George15-Jul-08 22:00