You downloaded and tested our software?

Feel free to use e-mail support@fantom-soft.com to send us your comments, suggestions, and so on.

* Special offer *

You can buy source codes of these products and use them in the development.

We also can write Windows and Linux programs for You.

NEW!

H323 SoftSwitch

100 simultaneous calls. Very small size. Easy configuring. Flexible calls routing. Does not require gatekeeper.

It is low cost VoIP solution for office.

Sndmail.dll

v 1.3

Latest Release

30 Sep 2008

Download trial version

Sndmail.ZIP

~ 8Kb

$19.90

Win32 DLL.

NEW!

Now Sndmail.dll can read mail. Function xp_rcvmail is added.

Contains Microsoft® SQL Server extended stored procedure – xp_sndmail.

xp_sndmail – is alternative to xp_sendmail unlike which allows to send e-mail messages by means of only SMTP protocol, without use MAPI and MS Outlook.

xp_rcvmail – is alternative to xp_readmail , allows to read e-mail messages by POP3 protocol, without use MAPI and MS Outlook.

Copy Sndmail.dll to the directory containing the standard SQL Server DLL files (C:\Program Files\Microsoft SQL Server\Mssql\Binn  by default).

Add extended stored procedure functions by Enterprise Manager or by commands:

use master

go

sp_addextendedproc 'xp_sndmail', 'sndmail.dll'

go

sp_addextendedproc 'xp_rcvmail', 'sndmail.dll'

go

Extended stored procedures added.

Example.

declare @error int

exec @error=master..xp_sndmail

'192.168.1.1',              --         IP-address of SMTP-server    varchar(15)

'192.168.1.10',            --         IP-address of local PC            varchar(15)

'bob@company.com',  --         e-mail “to”                               varchar(50)

'sql@company.com',    --         e-mail “from”                           varchar(50)

'Alarm',                        --         subject                                     varchar(100)

'Message'                    --         message body                          varchar(8000)

select @error

Variable @error will contain an error code, 0 – completed successfully.

declare @error int, @msg varchar(8000)

exec @error=master..xp_rcvmail

'192.168.1.1',   --         IP-address of POP3-server    varchar(15)

'bob',   --         user varchar(20)

'bobpass',  --         password varchar(20)

@msg OUTPUT  --         message varchar(8000)

select @error

select @msg

Variable @error will contain an error code, 0 – completed successfully.

If necessary to remove procedures it is possible to use the following commands:

sp_dropextendedproc 'xp_sndmail'

go

sp_dropextendedproc 'xp_rcvmail'

go

and unloads DLL from memory

dbcc sndmail (free)

go

By a call of procedure without parameters (exec master..xp_sndmail) deduces a brief information on application.

More example.

Download SQL Scripts

Creation of stable send mail system

These SQL Scripts creates two stored procedures “sendmail” and “sendmailspl”, the table “_mailspool” and job “sendmail_spooler”.

Procedure “sendmail” has the same parameters, as MS SQL “xp_sendmail”.

It only an example of use “sndmail.dll”.

You can adapt and change SQL Scripts for the best use.

Restrictions trial versions

E-mail subject: “Trial version sndmail”