Very Computer

by **Guillermo Casta?o** » Thu, 24 Apr 2003 05:18:09

Hi, i have a dll and want to know if i can use it from a SQL Server 2000 SP.
Its not an ActiveX, just a plain dll.
thanks

--
Guillermo Casta?o A.
www.GrupoMillennium.com

by **<n..** » Thu, 24 Apr 2003 05:37:25

How about calling it from.... an application?

Quote:> Hi, i have a dll and want to know if i can use it from a SQL Server 2000
SP.
> Its not an ActiveX, just a plain dll.
> thanks

> --
> Guillermo Casta?o A.
> www.GrupoMillennium.com

by **Mary Bra** » Thu, 24 Apr 2003 07:00:28

The short answer is no (until Yukon anyway) - the long
answer is "Only if it can be set up as an Extended Stored
Procedure" - see books On Line for more info. Essentially
thought, the answer is still probably "no". :-)

Quote:>-----Original Message-----
>Hi, i have a dll and want to know if i can use it from a
SQL Server 2000 SP.
>Its not an ActiveX, just a plain dll.
>thanks

>--
>Guillermo Casta?o A.
>www.GrupoMillennium.com

>.

by **SriSam** » Thu, 24 Apr 2003 21:16:58

No, you cannot. The "sp_OA*" set of procedures work only with OLE objects.
Incidentally, why call this DLL from SQL Server? Why not from your
application?
--
HTH,
SriSamp
Please reply to the whole group only!

Quote:> Hi, i have a dll and want to know if i can use it from a SQL Server 2000
SP.
> Its not an ActiveX, just a plain dll.
> thanks

> --
> Guillermo Casta?o A.
> www.GrupoMillennium.com

by **Guillermo Casta?o** » Fri, 25 Apr 2003 01:28:22

Thanks for answering...
Answering your question: i need the process to run in the server, not in
client machines. But i need to re-use a big set of mathematical functions
that i already have in the dll.

--
Guillermo Casta?o A.
www.GrupoMillennium.com

> No, you cannot. The "sp_OA*" set of procedures work only with OLE objects.
> Incidentally, why call this DLL from SQL Server? Why not from your
> application?
> --
> HTH,
> SriSamp
> Please reply to the whole group only!

> > Hi, i have a dll and want to know if i can use it from a SQL Server 2000
> SP.
> > Its not an ActiveX, just a plain dll.
> > thanks

> > --
> > Guillermo Casta?o A.
> > www.GrupoMillennium.com

by **Louis Krie** » Fri, 25 Apr 2003 03:08:04

create an axtiveX "wrapper" , using c, c++, Delphi or another compiler, then
create your actice_x class with sp_oacreate ...

Quote:> Hi, i have a dll and want to know if i can use it from a SQL Server 2000
SP.
> Its not an ActiveX, just a plain dll.
> thanks

> --
> Guillermo Casta?o A.
> www.GrupoMillennium.com

Very Computer

calling dll functions

calling dll functions

calling dll functions

calling dll functions

calling dll functions

calling dll functions

calling dll functions