SQL Server Call C++ function?

[xy]

Hi,

Does anyone know if/how SQL server can call a function in a C++ library?

Cheers,

Xiaobing

[Ray Miao]

Yes if you can build them as extended stored procedures.


------------
xy at 12/11/2001 7:40:31 AM

Hi,

Does anyone know if/how SQL server can call a function in a C++ library?

Cheers,

Xiaobing

[xy]

Thanks a lot Ray.

Xiaobing

------------
Ray Miao at 12/11/2001 9:31:15 AM

Yes if you can build them as extended stored procedures.


------------
xy at 12/11/2001 7:40:31 AM

Hi,

Does anyone know if/how SQL server can call a function in a C++ library?

Cheers,

Xiaobing

[JeffP]

If you are not able to build, but must use an existing dll, you may wish to consider...

declare @object int, @result(int, or varchar(n)) @myvar varchar(10)
,@intMyinput int --some input value

exec sp_OACreate 'ThierDllName.Class' @object out ,1
-- the ,1 denotes a Dll only

exec sp_OAMethod @object ,'FunctionName' ,@result out @IntMyinput
-- then something happens, or if an @output
-- value similar to result is added you would get
-- a value back.

HTH

JeffP...
------------
Ray Miao at 12/11/2001 9:31:15 AM

Yes if you can build them as extended stored procedures.


------------
xy at 12/11/2001 7:40:31 AM

Hi,

Does anyone know if/how SQL server can call a function in a C++ library?

Cheers,

Xiaobing

[xy]

Great! I'll try it out. Cheers
/Xiaobing

------------
JeffP at 12/11/2001 11:25:54 AM


If you are not able to build, but must use an existing dll, you may wish to consider...

declare @object int, @result(int, or varchar(n)) @myvar varchar(10)
,@intMyinput int --some input value

exec sp_OACreate 'ThierDllName.Class' @object out ,1
-- the ,1 denotes a Dll only

exec sp_OAMethod @object ,'FunctionName' ,@result out @IntMyinput
-- then something happens, or if an @output
-- value similar to result is added you would get
-- a value back.

HTH

JeffP...
------------
Ray Miao at 12/11/2001 9:31:15 AM

Yes if you can build them as extended stored procedures.


------------
xy at 12/11/2001 7:40:31 AM

Hi,

Does anyone know if/how SQL server can call a function in a C++ library?

Cheers,

Xiaobing