By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
448,958 Members | 1,179 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 448,958 IT Pros & Developers. It's quick & easy.

ActiveX info

P: n/a
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
Jul 20 '05 #1
Share this Question
Share on Google+
6 Replies


P: n/a
Pippen (12*@hotmail.com) 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****@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp
Jul 20 '05 #2

P: n/a

"Erland Sommarskog" <es****@sommarskog.se> wrote in message
news:Xn*********************@127.0.0.1...
Pippen (12*@hotmail.com) 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****@sommarskog.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
Jul 20 '05 #3

P: n/a
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.com> wrote in message
news:ajUjd.483788$mD.296273@attbi_s02...

"Erland Sommarskog" <es****@sommarskog.se> wrote in message
news:Xn*********************@127.0.0.1...
Pippen (12*@hotmail.com) 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****@sommarskog.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

Jul 20 '05 #4

P: n/a
Pippen (12*@hotmail.com) 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****@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp
Jul 20 '05 #5

P: n/a

"Erland Sommarskog" <es****@sommarskog.se> wrote in message
news:Xn**********************@127.0.0.1...
Pippen (12*@hotmail.com) 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****@sommarskog.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
Jul 20 '05 #6

P: n/a
Pippen (12*@hotmail.com) 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****@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp
Jul 20 '05 #7

This discussion thread is closed

Replies have been disabled for this discussion.