I'm getting a little confused about what is supported in MS-SQL ActiveX and
what is Visual Basic and what is VBScript. Can someone please point me to a
website, recommend a book or if I've missed it where in the MS-SQL help that
deals with the ActiveX supported in SQL. I'm not looking to do web pages
ASP, ect. I'm looking to use the ActiveX as add on funtionality to support
the Stored Procs I write.
Thanks,
-p
6  2591 
Pippen (12*@hotmail.co m) writes: I'm getting a little confused about what is supported in MS-SQL ActiveX
and what is Visual Basic and what is VBScript. Can someone please point
me to a website, recommend a book or if I've missed it where in the
MS-SQL help that deals with the ActiveX supported in SQL. I'm not
looking to do web pages ASP, ect. I'm looking to use the ActiveX as add
on funtionality to support the Stored Procs I write.
Personally I get confused only I see the term ActiveX. I think it is the
same as OLE, but I might be completely wrong.
Anyway, to call OLE objects from SQL Server you can use the sp_OAxxxx
routines, documented in Books Online.
Beware that if you call OLE objects that reside on the same machine as
SQL Server, they execute in-process, which means that an access violation
or similar execution error can cause the whole SQL Server to crash. While
this is useful at times, it something to use with caution.
--
Erland Sommarskog, SQL Server MVP, es****@sommarsk og.se
Books Online for SQL Server SP3 at http://www.microsoft.com/sql/techinf...2000/books.asp
"Erland Sommarskog" <es****@sommars kog.se> wrote in message
news:Xn******** *************@1 27.0.0.1... Pippen (12*@hotmail.co m) writes: I'm getting a little confused about what is supported in MS-SQL ActiveX
and what is Visual Basic and what is VBScript. Can someone please point
me to a website, recommend a book or if I've missed it where in the
MS-SQL help that deals with the ActiveX supported in SQL. I'm not
looking to do web pages ASP, ect. I'm looking to use the ActiveX as add
on funtionality to support the Stored Procs I write.
Personally I get confused only I see the term ActiveX. I think it is the
same as OLE, but I might be completely wrong.
Anyway, to call OLE objects from SQL Server you can use the sp_OAxxxx
routines, documented in Books Online.
Beware that if you call OLE objects that reside on the same machine as
SQL Server, they execute in-process, which means that an access violation
or similar execution error can cause the whole SQL Server to crash. While
this is useful at times, it something to use with caution.
--
Erland Sommarskog, SQL Server MVP, es****@sommarsk og.se
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp
After re-reading my post I did not make myself very clear... Please let me
try again. I'm looking to find resources to write ActiveX code to support my
stored procs ect... I'm confused on what the built in ActiveX compiler uses
out of the VBScript language. All of the VBScript books I pick up look like
they are written for web designers. I'm looking for a book or resource for
writing code for the ActiveX compiler in MS-SQL.
Sorry for the confusion,
-p
Like a lot of Microsoft technology terms, ActiveX is a bit nebulous. Here's
a link to google definitions: http://www.google.com/search?sourcei...ine%3A+activex
The main concept is that ActiveX is a technology/API rather than a language.
One can write a script in a language like VBScript and then execute it using
SQL Server tools like a DTS ActiveX Script task, a SQL Server Agent ActiveX
Script job step or using the sp_OA* procs that Erland mentioned. The script
can also be run independently of SQL Server using Windows Scripting Host.
What functionality do you need to implement?
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Pippen" <12*@hotmail.co m> wrote in message
news:ajUjd.4837 88$mD.296273@at tbi_s02...
"Erland Sommarskog" <es****@sommars kog.se> wrote in message
news:Xn******** *************@1 27.0.0.1... Pippen (12*@hotmail.co m) writes: I'm getting a little confused about what is supported in MS-SQL ActiveX
and what is Visual Basic and what is VBScript. Can someone please point
me to a website, recommend a book or if I've missed it where in the
MS-SQL help that deals with the ActiveX supported in SQL. I'm not
looking to do web pages ASP, ect. I'm looking to use the ActiveX as add
on funtionality to support the Stored Procs I write.
Personally I get confused only I see the term ActiveX. I think it is the
same as OLE, but I might be completely wrong.
Anyway, to call OLE objects from SQL Server you can use the sp_OAxxxx
routines, documented in Books Online.
Beware that if you call OLE objects that reside on the same machine as
SQL Server, they execute in-process, which means that an access violation
or similar execution error can cause the whole SQL Server to crash. While
this is useful at times, it something to use with caution.
--
Erland Sommarskog, SQL Server MVP, es****@sommarsk og.se
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp
After re-reading my post I did not make myself very clear... Please let me
try again. I'm looking to find resources to write ActiveX code to support
my stored procs ect... I'm confused on what the built in ActiveX compiler
uses out of the VBScript language. All of the VBScript books I pick up
look like they are written for web designers. I'm looking for a book or
resource for writing code for the ActiveX compiler in MS-SQL.
Sorry for the confusion,
-p
Pippen (12*@hotmail.co m) writes: After re-reading my post I did not make myself very clear... Please let
me try again. I'm looking to find resources to write ActiveX code to
support my stored procs ect... I'm confused on what the built in ActiveX
compiler uses out of the VBScript language. All of the VBScript books I
pick up look like they are written for web designers. I'm looking for a
book or resource for writing code for the ActiveX compiler in MS-SQL.
Since, as Dan said, no one really knows what ActiveX (save, possibly,
for the marketers that invented the term), it may be easier if you told
us what your business problem is.
Now it sounds a bit like you are asking to access SQL Server from ActiveX.
In such I assume that you use the ActiveX Data Objects, that is ADO. David
Sceppa has a good book about ADO on Microsoft Press. It's a bit old, so I
don't know how easy it is to get hold of.
--
Erland Sommarskog, SQL Server MVP, es****@sommarsk og.se
Books Online for SQL Server SP3 at http://www.microsoft.com/sql/techinf...2000/books.asp
"Erland Sommarskog" <es****@sommars kog.se> wrote in message
news:Xn******** **************@ 127.0.0.1... Pippen (12*@hotmail.co m) writes: After re-reading my post I did not make myself very clear... Please let
me try again. I'm looking to find resources to write ActiveX code to
support my stored procs ect... I'm confused on what the built in ActiveX
compiler uses out of the VBScript language. All of the VBScript books I
pick up look like they are written for web designers. I'm looking for a
book or resource for writing code for the ActiveX compiler in MS-SQL.
Since, as Dan said, no one really knows what ActiveX (save, possibly,
for the marketers that invented the term), it may be easier if you told
us what your business problem is.
Now it sounds a bit like you are asking to access SQL Server from ActiveX.
In such I assume that you use the ActiveX Data Objects, that is ADO. David
Sceppa has a good book about ADO on Microsoft Press. It's a bit old, so I
don't know how easy it is to get hold of.
--
Erland Sommarskog, SQL Server MVP, es****@sommarsk og.se
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp
After doing a little more research I think what I'm looking for is a book or
resource that deals with using VBScript in a DTS package to extend the
functionality of the DTS package; namely the ActiveX task in the DTS
package. Every book that I have picked up on VBScript deals primarliy with
webpages.
I have a process that needs to send and receive files that are encrypted
with PGP on a daily basis. Each of the files have unique names so I will
need to read tables to find the files that need to be processed. These files
will be encrypted / decrypted in the VBScript and loaded or extracted from
the DB. I would have used batch files (MS system) if not for the unique file
names. Essentially I'm looking to increase my knowledge of using VBScript in
an ActiveX task for this project and future projects.
Sorry about the misuse of normenclature, SQL is not my primary language.
Thanks,
-p
Pippen (12*@hotmail.co m) writes: After doing a little more research I think what I'm looking for is a
book or resource that deals with using VBScript in a DTS package to
extend the functionality of the DTS package; namely the ActiveX task in
the DTS package. Every book that I have picked up on VBScript deals
primarliy with webpages.
I know very little about DTS, and even less about books on DTS. However,
SQL Server MVPs Darren Green and Allen Mitchell runs www.sqldts.com, and
you might find some good tips there.
--
Erland Sommarskog, SQL Server MVP, es****@sommarsk og.se
Books Online for SQL Server SP3 at http://www.microsoft.com/sql/techinf...2000/books.asp This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: news.scarlet.be |
last post by:
Hi there,
From a VB.NET application, a VB6 ActiveX DLL needs to be used. This
ActiveX.DLL (source not available) has an Announce() method which opens a
socket to a given server for communication purposes.
Problem is the Announce() method does not work from VB.NET - nothing happens
(I can monitor incoming connections server-side but no connection is
established). There is no exception neither. The same ActiveX.DLL works
flawlessly and...
|
by: DartmanX |
last post by:
Is there a simple way to determine if someone using Internet Explorer
has completely disabled ActiveX controls?
Jason
|
by: James Pannozzi |
last post by:
I'm just starting a C++ application which will send data to someone
else's program (written as a VB ActiveX COM app)
and receive some data back from it.
I have the Visual Studio .NET 2003 develoopment environment
and I decided to use C++.
Just as #import once built the interface for me in the Visual Studio 6.0
compiler,
what .NET framework tools might I use to build the interface to the other
|
by: Rob T |
last post by:
I'm hoping someone can point me in the right direction...I've been picking
through MSDN all day and I'm more confused now what I was when I started
this! Hopefully I have the right terminology.... I'm a VB
programmer....C# is basically greek to me.........
I want to create an ActiveX control. To keep it simple, let's say I want a
windows form that just has a label that says "Hello World". I would like my
web form to load this...
|
by: Frank |
last post by:
Short Version of Question:
Can anyone provide an example of how I should embed the ActiveX and license,
and then use it in a function?
| | |
by: Frank |
last post by:
Short Version of Question:
Can anyone provide an example of how I should embed the ActiveX and license,
and then use it in a function?
|
by: Martijn Boven |
last post by:
I created a activex control in c# (vs 2005)
--------------------------------------------
public partial class ActiveTest : UserControl
{
public ActiveTest()
|
by: marcosnogood |
last post by:
Hello,
I need to dynamically load an activex object because what
object to load is based on certain conditions. Also I need to
wait for the object to have initialized before moving on. What I did
was having the activex object set a variable and have the javascript
spin on that variable (a wait function)...
function load() {
var newsection = document.createElement('div');
|
by: Budhi Saputra Prasetya |
last post by:
Hi All,
I'm trying to display .NET Custom Control (created using Inherited Control)
on an ASPX page, but no luck. I already registered the Control to Global
Assembly Cache through .NET Framework 1.1 Configuration. I have also put a
reference to the control on my ASP .NET project. The view that I get is only
a disabled text area.
Below is the code that I'm using:
|
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, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| | |
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 tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| | |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
