all groups > sql server msde > march 2005 >
You're in the

sql server msde

group:

External SQL functions exported by DLLs


External SQL functions exported by DLLs Peter Sullvan
3/11/2005 2:58:49 PM
sql server msde: We have a few rather advanced calculation routines
developed in C++. Currently we are using a Sybase ASA
database for our app. and these routines are accessible
by so called external functions exported by a DLL
(dynamic link library) that we wrote in C++. Sybase
supports this quite nicely.

The client app can call such routines by:

"select get_roof_angle() as angle from dummy;"
or
":angle = call get_roof_angle();"

Now we are checking if other databases can provide us
with similar abilities. So I just wonder if SQLServer/MSDE
supports the ability to call a routine exported by a
DLL? If yes, does anyone know the SQL syntax to declare
it in SQLServer/MSDE

Best regards
Peter Sullvan


Re: External SQL functions exported by DLLs Andrea Montanari
3/11/2005 3:38:40 PM
hi Peter,
[quoted text, click to view]

you can write so called "extended stored procedures" externded by dll... at
http://www.sqldev.net/xp.htm you can find some examples as long as usefull
links..
--
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtm http://italy.mvps.org
DbaMgr2k ver 0.10.0 - DbaMgr ver 0.56.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
--------- remove DMO to reply

AddThis Social Bookmark Button