Is there a way I can call VB.net code from a stored procedure? I need to
schedule a sql job (stored procedure) and in the logic of the stored
procedure, I need to call vb.net code to generate a pdf document.
Your support will very much helpful Thanks in advance.
Regards,
Benny 5 1095
Yes, there's an extended stored proc called (IIRC) xp_cmdshell which can
call external code, though there are ome caveats on its use which you should
be able to find in the SQL documentation
there's also a way of instantiating COM objects from SQL with another XSP,
the name of which has totally escaped me - I'll look it up shortly.
--
Jason Brown
Microsoft GTSC, IIS
This posting is provided "AS IS" with no warranties, and confers no rights.
"Benny" <ag*****@lycos.com> wrote in message
news:%2****************@TK2MSFTNGP09.phx.gbl... Is there a way I can call VB.net code from a stored procedure? I need to schedule a sql job (stored procedure) and in the logic of the stored procedure, I need to call vb.net code to generate a pdf document.
Your support will very much helpful Thanks in advance.
Regards, Benny
sp_OACreate, etc. I give examples of using them to create a CDO.Message
object in http://www.aspfaq.com/2403
Not exactly the best use of resources, FWIW. Some insiders (e.g. Euan) have
alluded to some serious memory issues with some of these tools. Besides,
sp_OA* are for instantiating regular old COM objects, not .NET. I think the
OP will have to go the route of xp_cmdshell and all the security
implications that come with it.
On 3/8/05 9:57 PM, in article uk**************@TK2MSFTNGP14.phx.gbl, "Jason
Brown [MSFT]" <i-******@online.microsoft.com> wrote: Yes, there's an extended stored proc called (IIRC) xp_cmdshell which can call external code, though there are ome caveats on its use which you should be able to find in the SQL documentation
there's also a way of instantiating COM objects from SQL with another XSP, the name of which has totally escaped me - I'll look it up shortly.
Thanks Aaron
--
Jason Brown
Microsoft GTSC, IIS
This posting is provided "AS IS" with no warranties, and confers no rights.
"Aaron [SQL Server MVP]" <te*****@dnartreb.noraa> wrote in message
news:BE53E833.250E%te*****@dnartreb.noraa... sp_OACreate, etc. I give examples of using them to create a CDO.Message object in http://www.aspfaq.com/2403
Not exactly the best use of resources, FWIW. Some insiders (e.g. Euan) have alluded to some serious memory issues with some of these tools. Besides, sp_OA* are for instantiating regular old COM objects, not .NET. I think the OP will have to go the route of xp_cmdshell and all the security implications that come with it.
On 3/8/05 9:57 PM, in article uk**************@TK2MSFTNGP14.phx.gbl, "Jason Brown [MSFT]" <i-******@online.microsoft.com> wrote:
Yes, there's an extended stored proc called (IIRC) xp_cmdshell which can call external code, though there are ome caveats on its use which you should be able to find in the SQL documentation
there's also a way of instantiating COM objects from SQL with another XSP, the name of which has totally escaped me - I'll look it up shortly.
Thanks to you Jason and Aaron, Will try and get back.
Kind REgards,
Benny
"Jason Brown [MSFT]" <i-******@online.microsoft.com> wrote in message
news:eA**************@TK2MSFTNGP10.phx.gbl... Thanks Aaron
-- Jason Brown Microsoft GTSC, IIS
This posting is provided "AS IS" with no warranties, and confers no rights.
"Aaron [SQL Server MVP]" <te*****@dnartreb.noraa> wrote in message news:BE53E833.250E%te*****@dnartreb.noraa... sp_OACreate, etc. I give examples of using them to create a CDO.Message object in http://www.aspfaq.com/2403
Not exactly the best use of resources, FWIW. Some insiders (e.g. Euan) have alluded to some serious memory issues with some of these tools. Besides, sp_OA* are for instantiating regular old COM objects, not .NET. I think the OP will have to go the route of xp_cmdshell and all the security implications that come with it.
On 3/8/05 9:57 PM, in article uk**************@TK2MSFTNGP14.phx.gbl, "Jason Brown [MSFT]" <i-******@online.microsoft.com> wrote:
Yes, there's an extended stored proc called (IIRC) xp_cmdshell which can call external code, though there are ome caveats on its use which you should be able to find in the SQL documentation
there's also a way of instantiating COM objects from SQL with another XSP, the name of which has totally escaped me - I'll look it up shortly.
> Is there a way I can call VB.net code from a stored procedure? I need to schedule a sql job (stored procedure) and in the logic of the stored procedure, I need to call vb.net code to generate a pdf document.
Have you considered going the other way? Have the stored procedure log an
entry into a queue table. Have a windows scheduled task wake up every
minute, fire up a VB.Net app, it checks the database and if there's anything
in the queue, it creates the PDF document(s).
A This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Markus Sons |
last post by:
Hello NG,
I need some kind of triggering mechanism while capturing audio. I don't
need to know the audio data itself, but I need to know, at which point
in time the audio level climbs above a...
|
by: Benny |
last post by:
Dear All,
I need to send a set of Emails from my application (reminders) each month
1st. Is there anyway in ASP scripts to trigger an event to run
automatically? I have no dedicated server, so...
|
by: aundro |
last post by:
Hello,
I've been looking on the web for a solution to this problem:
I create a set of checkboxes, and 2 buttons:
- one is labeled "All"
- the other is labeled "None"
Clicking "All" is...
|
by: gustavo_randich |
last post by:
Hello,
I'm looking for a DB2 workaround on a topic already solved in Oracle:
the problem of mutating tables (which states that a trigger action
cannot read the triggering table's data). Yes, I...
|
by: OhFiddleSticks |
last post by:
Does anyone know if there is a way to add a text value to a combo box (the
text box part, not the rowsource) in VBA without triggering an update
event? I've tried everything I can think of without...
|
by: Wavemaker |
last post by:
I was wondering if there is a way to change the value of a control
without triggering an event. The ComboBox control, for example, will
trigger the SelectedIndexChanged event when its SelectedIndex...
|
by: Kavvy |
last post by:
Hi,
I have a form where I want to trigger two events one after the other.
eg. tbxDateEntry (text box) has focus and the user clicks on mCal
(calendar).
At the moment I have...
|
by: Steve Schroeder |
last post by:
For some reason I cannot get the OnSelectedIndexChanged event to fire for a
listbox I have on a page. I'm able to populate the listbox with data from a
stored procedure, but cannot trigger the...
|
by: christinamasalha |
last post by:
hello all,
I've been trying to figure this out for days but i don't know what the problem is. I have this form which contains 2 subforms on it. On one of the subforms there is a fields called...
|
by: Vincent |
last post by:
I have a bound listbox control on one of my forms that has an
associated afterupdate event. When this event is invoked, I lock the
control to prevent the user from clicking on it more than once....
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
| |