Newbie: Deploying vb.net Console Application

  • Thread starter Thread starter Bari
  • Start date Start date
B

Bari

I have just created my first console application, and wish to deploy it.

I would like to have it scheduled as a task to run from a SQL server 2000
job. What is required for this?

The app. consists of 3 simple modules: There are data connections to SQL
server, as well as data readers in the applcation, and a streamwriter to
output text to a file.

1) Where do I locate the framework--on the the machine with the console
application, or on the SQL box running the job?

2) Which files need to be deployed? Just the .exe or do the .pdb and/or any
of the .vb/.vbproj files need to be included as well?

3) Finally, I use "Try... Catch's to check for errors, which are currently,
for test purposes set to send error messages to console.writeline(),
however, when live, I would like to send these to alert SQL server agent.
Is this possible? Any help you can offer would be greatly appreciated.
Thanks in advance.

Bari
 
The app. consists of 3 simple modules: There are data connections to SQL
server, as well as data readers in the applcation, and a streamwriter to
output text to a file.

1) Where do I locate the framework--on the the machine with the console
application, or on the SQL box running the job?
Click to expand...

I'm not sure if I've got the question right.
You have to install the .NET framework on every machine you want to run you
app on.
2) Which files need to be deployed? Just the .exe or do the .pdb and/or any
of the .vb/.vbproj files need to be included as well?
Click to expand...

Normally you only need the .exe, but if you use special references you'll
have
to register them on that machine before.
command line in the path of your programm and the dll:
regsvr32 "dllname"


Can't help you with the SQL Server details, sorry.

Bye,
Michael Liebelt
 
Thanks, Michael, for the info on which files to include. I guess, what I'm
asking about the framework, is:

Machine A has .exe file

Machine B has SQL server. This machine will call the .exe from machine A at
regular intervals.

Would I install the framework from the calling machine or the server it's
sitting on. Refphrased: Which machine does the application actually run on?
Thank you.

Bari
 
Machine A has .exe file
Machine B has SQL server. This machine will call the .exe from machine A at
regular intervals.

Would I install the framework from the calling machine or the server it's
sitting on. Refphrased: Which machine does the application actually run
Click to expand...
on?

Ok, that clarifies it.
Normally the .exe runs on Machine B.
Only possibility that it runs on A is if you make an RPC or something like
that, but it takes some extra work from you to achieve that.

Other question:
Why not installing the framework on both machines?
Then you can lower the workload on machine B by running the .exe on machine
A, if your system architecture supports that.

Bye,
Michael Liebelt
 
Back
Top