Hi all,

Guess what.... my vb.exe didn't work in sending an autoemail to our daily artist spotlight. What's going on is that the server is still executing the script but the email isn't being sent out.

I'm starting to think it's the connection string I'm using or ASP Mailer.

DZ

* Here's the code *
First, the connection string:
***********
Dim Connect, Connect_String, rsSpotlight, strSpotlightQ

set Connect = Server.CreateObject("ADODB.Connection")

Connect_String = "PROVIDER=SQLOLEDB;Data Source=databaseserver;Initial Catalog=name;USER ID=username;PASSWORD=9999999;"

Connect.Open Connect_String

set rsSpotlight = Server.CreateObject("ADODB.Recordset")
set rsSpotlight.ActiveConnection = Connect

strSpotlightQ = "Select * from AtlasSpotlight WHERE ID = '" & lnID & "'"
rsSpotlight.Open strSpotlightQ

*******
then I'm using a Server-Side include to read in the letter...
Dim strMessage

<!--#INCLUDE file="SpotlightLetter.asp"--> (this writes to strMessage)

***********
Then sending the email with ASP Mailer (I'm not using CDONTS because our server no longer supports it)

Set Mailer = Server.CreateObject("SMTPsvg.Mailer")

Mailer.FromName = "Atlas Artist Spotlight"

Mailer.FromAddress = "name@host.com"

Mailer.RemoteHost = "relay.host.com"

Mailer.Subject = "Your Spotlight Notification For " & Trim(rsSpotlight("Artist_Name"))

Mailer.AddRecipient Trim(rsSpotlight("Contact_Name")), Trim(rsSpotlight("Contact_Email"))

Mailer.cc = "techperson@host.com", "me@host.com"

Mailer.BodyText = strMessage
Mailer.SendMail
Set Mailer = nothing

rsSpotlight.Close
Connect.Close

I wanted to say that the above works in an ASP page, but not with autorunning - calling up the ASP page from the server.

I'm really dumbfounded. So is the hosting company.

DZ

Test the pieces individually on your local machine. You might not be able to do the mailing part, but you can comment that part out and test the database stuff. Then put it all together once you know each piece is working.

Do you have to use SMTPsvg.Mailer? I dont know anything about it. Can you use CDOSYS? There's a lot of support on the web for CDOSYS that you could use to put a script together.

Perhaps you're looking at the problem from the wrong angle, Donna. What if you wrote a VBS file that called an ASP page with the same code?

Having said that, I can see a few things off the top:

1) VB doesn't support Server.CreateObject (it's just CreateObject).
2) VB also doesn't support server-side includes in the sense that you tried it.

Donna, I'm going to PM you a link that may help. I'd drop it like it's hot in the forum, but it's my own link so I don't want to be accused of link dropping.

As far as CDOSYS is concerned, you may want to use CDOSYS instead, as Dan said. It's usually supported on both Windows 2000 and 2003 servers (whereas CDONTS is only supported on Win2K).

Everyone, thanks

Adam... I suspected that was the problem that VBS wasn't supporting certain functions.

It's funny because I saw a book yesterday at Barnes and Nobel on VBScript. I may go back and get it.

Thanks for the code you sent. I'm going to give it a try this week. I officially left my company - but I'll be doing some asp/asp.net coding projects for them as I work for my new. I can use the cash.

What I find interesting is that there's are real place for us ASP/VBScript dinosaurs. I was shocked that no one at our hosting company had a clue about any of it.

Donna Z.

They're server admins, not coders, Donna. You can only expect so much from them.

Seriously, they very rarely get involved in that sort of thing and don't offer much (if any) support. You're on your own in that regard unless you get lucky and someone's already gone down the path for you.