AtvSoftware
Home
Products
About Us
Contact Us
« Return To Products //



Xp_pop3 Extended Stored Procedure For MS SQL
Description How to Install How to Use How to Uninstall

Version: 1.0
Requirements: All Windows Platforms
File Size: 40 KB
Download License: Free to Try

// Description

The extended stored procedure xp_pop3 makes accessing a POP3 email boxes very easy from your MS SQL Server. Using this procedure will enable you to build a powerful email processing system based on the MS SQL Server.

Copy the xp_pop3.dll over to your SQL Server \Binn directory.

Add your new Extended Stored Procedure from a Visual Studio Data Project, or using the SQL Server Enterprise Manager, or by executing the following SQL command:

sp_addextendedproc 'xp_pop3', 'xp_pop3.dll'

exec master.dbo.xp_pop3
    'server',
    'username',
    'password',
    'command',
    message_id

Where:
'server'
- The name of POP3 server.

'username'
- The email account.

'password'
- The password.

'command'
- One of the following commands:

READ
    - Read the message.

READ_TOP
    - Read the message header only.

READ_TOP_DEL
    - Read the message header only and delete the message from the email box.

LIST
    - Read the message ID and size of the message (in octets).

DEL
    - Delete the message from the email box.

'message_id'
Is a positive number when:
    message_id = 0 - 'command' affect to all of the messages in the email box.
    message_id > 0 - 'command' affect to the message with ID = message_id.

You may drop the extended stored procedure by using the SQL command:

sp_dropextendedproc 'xp_pop3'

You may release the DLL from the Server (to delete or replace the file), by using the SQL command:

DBCC xp_pop3 (FREE)

// Top Products   WinCrypto
  Xp_Pop3
  Xp_smtp
  Xp_adsi
  DB Event Alerter [MS SQL]
  DB Event Alerter [Postgre SQL]
  DB Event Alerter [Firebird]
  DB Event Alerter [MySQL]
  DB Event Alerter [Oracle]
  VFP Post_event Library

Go Back Go Up Go Forward Copyright © AtvSoftware 2023