Sending E-Mail from SQL 2008 Express

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Andrew Prisk » Sending E-Mail from SQL 2008 Express

48 posts, Page 4 of 5

«««1 2 3 4 5 »»

Sending E-Mail from SQL 2008 Express

Rate Topic

Display Mode

Topic Options

Author

Message

Jeff Moden

Posted Thursday, November 18, 2010 7:48 PM

SSC-Dedicated

Group: General Forum Members
Last Login: Today @ 7:18 AM
Points: 33,112, Visits: 27,038

Jeff Moden (11/4/2010)

I have to ask because I just don't know... Hopefully, one of you do. Is CDONTS and sp_OA* available in SQL Server Express?

Anyone?

--Jeff Moden

"RBAR is pronounced "ree-bar" and is a "Modenism" for "Row-By-Agonizing-Row".

First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column."

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Post #1023256

clement.degroote

Posted Friday, November 19, 2010 1:02 AM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, May 05, 2011 7:31 AM
Points: 6, Visits: 30

Thank you for answer.
I change path and permissions with a share folder with permission to everyone.
But no change : mail is sending, we receive it well but without attach file.
Other idea ?

Post #1023343

APrisk2

Posted Friday, November 19, 2010 3:32 AM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, May 28, 2013 12:13 PM
Points: 5, Visits: 64

It was changed to a shared path - do you mean a UNC path? Is the path to the file something like this: \\server\folder? If so, then try mapping that to a local drive and try it again.

Post #1023380

clement.degroote

Posted Friday, November 19, 2010 4:13 AM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, May 05, 2011 7:31 AM
Points: 6, Visits: 30

Yes, UNC path. I tried on the server and on my computer. And I tried server/computer name and with IP adress.
Same problem : mail is sending but without attach file
And there isn't any error message and I've no idea how debug this process...

Post #1023400

APrisk2

Posted Friday, November 19, 2010 4:47 AM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, May 28, 2013 12:13 PM
Points: 5, Visits: 64

And you verified the NTFS permissions?

Post #1023412

clement.degroote

Posted Friday, November 19, 2010 5:41 AM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, May 05, 2011 7:31 AM
Points: 6, Visits: 30

yes i did;
control total to everyone

Post #1023436

dmbaker

Posted Friday, November 19, 2010 7:09 AM

Mr or Mrs. 500

Group: General Forum Members
Last Login: Today @ 6:42 AM
Points: 504, Visits: 2,530

Jeff Moden (11/18/2010)

Jeff Moden (11/4/2010)

I have to ask because I just don't know... Hopefully, one of you do. Is CDONTS and sp_OA* available in SQL Server Express?

Anyone?

I'm not certain, but I don't think CDONTS will be available. Don't think it'd be part of the install of SQL Server Express, but it *might* be part of the OS install, or might come with Microsoft Office if you've got the right parts installed. You're more likely to have CDOSYS I think, if it's newer version of Windows. In googling a bit it looks like maybe SQL Server Express does have email stuff on the SQL Server side, but the core email components (DLLs) are not included and emailing-related services are disabled and buried.

Sorry for the waffly answer. Smile

Post #1023499

Gift Peddie

Posted Friday, November 19, 2010 7:33 AM

Hall of Fame

Group: General Forum Members
Last Login: Thursday, June 13, 2013 9:43 AM
Points: 3,432, Visits: 14,334

dmbaker (11/19/2010)

Jeff Moden (11/18/2010)

Jeff Moden (11/4/2010)

I have to ask because I just don't know... Hopefully, one of you do. Is CDONTS and sp_OA* available in SQL Server Express?

Anyone?

I am running 2008 developer, 2005 standard and Express and yes Express comes with the sp_OA just like SQL Server 2008 developer but no CDONTS. The reason those are COM dll which the developer division have depreciated since 2005 version of .NET.

Kind regards,
Gift Peddie

Post #1023527

Gift Peddie

Posted Friday, November 19, 2010 8:21 AM

Hall of Fame

Group: General Forum Members
Last Login: Thursday, June 13, 2013 9:43 AM
Points: 3,432, Visits: 14,334

clement.degroote (11/19/2010)

yes i did;
control total to everyone

If permissions is not the issue it may related to the attachement definition in the code. There are two ways to send attachments with System.net.mail one is to use filesystem or to use the streams both require System.IO Import or Using statement.

Kind regards,
Gift Peddie

Post #1023555

clement.degroote

Posted Monday, November 22, 2010 7:45 AM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, May 05, 2011 7:31 AM
Points: 6, Visits: 30

Hello.
Sorry, but I don't understand. Could you tell me more ?

Post #1024341

« Prev Topic | Next Topic »

48 posts, Page 4 of 5

«««1 2 3 4 5 »»

Permissions