Board index » delphi » MS SQL Server 6.0 Extended Stored Procedures

MS SQL Server 6.0 Extended Stored Procedures

How do you successfully create a DLL in Delphi that MS SQL
Server 6.0 will allow to be used as an extended stored
procedure DLL.  If I create a Delphi DLL and "export" the
function I get "Can't find xxx.DLL" when trying to execute the
function in SQL Server.  The DLL has been placed in the
appropriate directory and the appropriate calls have been made
to SQL Server.  If I do the same thing in MS C++, everything
works fine.  What is C doing that Delphi is not when creating
the DLL...I guess this is the main part of the question to
answer.

Thank you,

Bruce
br...@centcon.com

 

Re:MS SQL Server 6.0 Extended Stored Procedures


How do you successfully create a DLL in Delphi that MS SQL
Server 6.0 will allow to be used as an extended stored
procedure DLL.  If I create a Delphi DLL and "export" the
function I get "Can't find xxx.DLL" when trying to execute the
function in SQL Server.  The DLL has been placed in the
appropriate directory and the appropriate calls have been made
to SQL Server.  If I do the same thing in MS C++, everything
works fine.  What is C doing that Delphi is not when creating
the DLL...I guess this is the main part of the question to
answer.

Thank you,

Bruce
br...@centcon.com

Re:MS SQL Server 6.0 Extended Stored Procedures


Never forget that any application that would call a C++ DLL with a
parameter that is a string always passes a null terminated string.

To avoid errors in Delphi DLLs always use type PChar when declaring and
passing strings.

Other Threads