SQL Mail Sever Connected with VB

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

Development Tools

Other Development Tools

SQL Mail Sever Connected with VB

Author

Topic

amitkumarmadhukar
Starting Member

45 Posts

Posted - 2004-07-23 : 05:36:28

i want to Configure SQL Mail Service of SQL Server
( Is there is a facility of INBOX,OUTBOX,SENT ITEMS like any other Mail Servers ? )

and if yes then i want to Connect the SQL Mail service from VB Application.
please tell me connection string for SQL Mail-VB

how i can read mail/write mail using connection

give me an example code and also if possible then give me location of web address or name of suggested readings regarding such kind of deveopment

amit kumar madhukar

derrickleggett
Pointy Haired Yak DBA

4184 Posts

Posted - 2004-07-23 : 13:30:39

There is no connections string. All it's doing is using a MAPI client to read/send email. For the full functionality, look up the follwing in Books Online:

SQL Mail
SQL Agent Mail
xp_sendmail
xp_readmail
sp_processmail
xp_findnextmessage
xp_deletemail

What you can do is have the MAPI client point to an exchange mail box. You can connect to that in your VB program. You can also use the functionality of SQL Server with the above stored procedures.

MeanOldDBA
derrickleggett@hotmail.com

When life gives you a lemon, fire the DBA.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2004-07-23 : 13:38:37

http://support.microsoft.com/default.aspx?scid=kb;EN-US;263556

Tara

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources