Search results matching tags 'ASP Classic' and 'asp'

Cannot connect to mysql db 5.1

Perryvanz — Tue, 17 Nov 2009 15:40:06 GMT

Hello,

Im using IIS 7.5 with Windows server 2008 r2. I want to open my database, so I used the next connectstring for opening the db:

connect_string = "Driver={MySQL ODBC 5.1 Driver}; Server=localhost; UID=username; PWD=pwd; Database=db"
set dbConn = server.createObject("ADODB.connection")
dbConn.open(connect_string)

I'm getting this error....

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

What do I have to do to connect to my db?

Perry

Re: Can smone help me with "CDO.Message.1 error '80040220' " error ?

debugmm — Wed, 04 Nov 2009 21:12:37 GMT

Hi,

Try the following code: -

<!--
METADATA
TYPE="typelib"
UUID="CD000000-8B95-11D1-82DB-00C04FB1625D"
NAME="CDO for Windows 2000 Library"
-->
<%
Set cdoConfig = CreateObject("CDO.Configuration")
 
With cdoConfig.Fields
.Item(cdoSendUsingMethod) = cdoSendUsingPort
.Item(cdoSMTPServer) = "localhost"
.Update
End With
 
Set cdoMessage = CreateObject("CDO.Message")
 
With cdoMessage
Set .Configuration = cdoConfig
.From = "from@domain.com"
.To = "to@domain.com"
.Subject = "Sample CDO Message"
.TextBody = "This is a test for CDO.message"
.Send
End With
 
Set cdoMessage = Nothing
Set cdoConfig = Nothing
%>

http://prabhat.me/2009/11/04/send-e-mail-using-cdo/

odbc connection pooling with Delphi 7 & IIS7

ffsetit — Mon, 05 Oct 2009 08:04:19 GMT

We have a application that utilizes a combination of ASP.net (c#) and classic ASP (Delphi 7). When running the application on Windows Vista or Server 2008 using IIS7 we experience terrible performance problems from the classic ASP pages when retrieving data from SQL. Upon investigation using SQL Profiler it is apparent that hard connections are being opened and closed rather than being pooled. We experience the same issue with IIS6 on Server 2003 however this can be worked around by enabling IIS5.0 compatibility mode. Unfortunately there seems to be no such workaround for IIS7 Does anyone have any ideas as to why odbc connection pooling does not work in IIS7 (or 6)

Blank Page No Errors

goofy_tyran — Wed, 16 Sep 2009 14:59:19 GMT

Hi guys,

I have a website which I've brought over to IIS7 from Windows IIS6, which ran great there.

Now its on IIS7 some of my Classic ASP pages wont run and simply stop dead outputting to the browser just a blank page. The only thing in the blank page source code are the usual <html> tags etc. There are no error codes at all.

If I break the code (by adding a 'end if' in to the code where it sholdnt be) I get the relevant errors.

This happens to only a handful of pages. The only common thing I can see between the pages is that they use the 'Server.CreateObject' call to either create an instance of Jmail or FileSystemObject.

I'm really stumped with this one and any help would be would be greatfully received.

Thanks in advance!

Re: Creating a user email confirmation

salman_arshad — Wed, 08 Jul 2009 06:51:49 GMT

If I am understanding correctly, you are asking the user to enter an email address and you want to send an email to the specified email address + another, hidden email address. In this case you can call the email function twice, specifying two different values for the "To" field. Alternatively you can add one recipient to the "To" field, and the other one to the "CC" or "BCC" field. The form might look like:

<input type="text" name="Email" size="32" tabindex="2" />

There is no need to echo the user@anydomain.edu in the form. Process this part on the server side.

The server side handler for the form should include email code that goes along these lines (using CDO.Message class):

dim oMSG
set oMSG = CreateObject( "CDO.MESSAGE" )

'UNCOMMENT FOLLOWING IF YOU ARE SENDING MAIL THROUGH SMTP SERVER
'oMSG.Configuration.Fields.Item("http://schemas.microsoft.com/cdo/configuration/sendusing") = 2
'oMSG.Configuration.Fields.Item("http://schemas.microsoft.com/cdo/configuration/smtpserver") = "external-smtp-server-name.com.or-its-ip"
'oMSG.Configuration.Fields.Item("http://schemas.microsoft.com/cdo/configuration/smtpserverport") = 25
'oMSG.Configuration.Fields.Item("http://schemas.microsoft.com/cdo/configuration/sendusername") = "smtp-logon-username-here"
'oMSG.Configuration.Fields.Item("http://schemas.microsoft.com/cdo/configuration/sendpassword") = "smtp-logon-password-here"
'oMSG.Configuration.Fields.Update

oMSG.From = "no-reply@anydomain.com"
oMSG.To = Request.Form("Email")
oMSG.BCC = "address-that-receivces-a-copy@anydomain.edu"
oMSG.Subject = "Thank you"

oMSG.TextBody = "Message text goes here"
' -- OR --
oMSG.HTMLBody = "Message html goes here"

on error resume next
    oMSG.Send
    if Err.number <> 0 then
        'OOPS, SEND METHOD FAILED
    end if
on error goto 0
set oMSG = nothing

http 500. Help, my form mail in wrong

coma — Sun, 10 May 2009 20:28:29 GMT

I have vista premium home and IIS 7

I am using dreamweaver cs3 and i beginner to asp.

My problem is that the ie says http 500.

My code of the page is

<%
theSchema="http://schemas.microsoft.com/cdo/configuration/"
Set cdoConfig=server.CreateObject("CDO.Configuration")
cdoConfig.Fields.Item(theSchema & "sendusing")= 2
cdoConfig.Fields.Item(theSchema & "smtpserver")="smtp.gmail.com"
cdoConfig.Fields.Update
set cdoMessage=Server.CreateObject("CDO.Message")
cdoMessage.Configuration=cdoConfig

cdoMessage.From="yourname@yourserver.com"
cdoMessage.To="yourname@yourserver.com"
cdoMessage.Subject="This is the message subject"
cdoMessage.TextBody="This is the message body"
cdoMessage.Send

Set cdoMessage=Nothing
Set cdoConfig=Nothing
%>

where is my mistake, that ie says http 500?

i found the code in a book of tutorial asp.

thanks

ASP Scripting language 'jscript' is not found on the server Error - after DW CS4 installation

chriscoolin — Tue, 05 May 2009 11:10:24 GMT

I too have similar problem.

I've DW CS3 installed in System with Win XP as OS (IIS 6).

After installing DW CS4 trial version, I'm getting the following
error in my website.

Error Type:

Active Server Pages, ASP 0129 (0x80004005)

The scripting language 'jscript' is not found on the server.
/includes/tNG/tNG.inc.asp, line 195

The website was working fine earlier and the contents in the
live server is working fine.

DW CS4 has disturbed the existing one... Now I uninstalled DW CS4
and reinstalled DW CS3 again.

But the problem persists....

Help me pls..

site not working without mentioning the default page in IE 7 but working fine with mozilla

chriscoolin — Mon, 04 May 2009 05:57:09 GMT

I hosted a website on a remote server (win 2008 / iis 7 / asp). The default page is configured and it was working fine for around 2 months but now for the last two days we have reported a problem site is not accessible by typing the url.

The fun is if I type the url along with the default page i'm getting the site (in IE 7) In mozilla, it is working without mentioning the default or home page.

I'm clueless, How it is working in mozilla and not working in IE 7 and How it was working fine so far and suddenly what happened to the site?

How and why it is not working with IE 7? How to resolve this problem? Help me to sort out this issue.........

As most of the users are using IE 7, I can't delay....

Re: Error Recordset ASP

Daneri — Mon, 27 Apr 2009 22:02:54 GMT

Thanks alot for the help but i see the anonymous user has the enought permissions,do you have more ideas?, I think is something with the security in the webserver, or IIS, but i was checking part by part and i cannot find what more could be...This is doing me crazy, i was working with ASP and SQL in the past and in the first time i dont know why i am having this issue..

Please if you have more ideas send me the information, I did a small file to upload files to be sure if just is when i use the recordset but i dont had issues, only is when i am use the object ADODB to open my BD.

Re: Error Recordset ASP

Daneri — Fri, 24 Apr 2009 19:13:49 GMT

Thank you tomkmvp for the help, but I have the Access Database locally (c:\inetpub\wwwroot\EXAMPLE.mdb), I created one with Access just to do a test if something was wrong. I have SQL Server in a remote machine.When i try to connect to this remote machine I get that message, when i try to connect locally is the same message.

This mean locally or remotely i get:

ADODB.Connection error '800a0046'

Permission denied

The line where show that is message is when i try to use the property Open

O_Conn.Open "DRIVER..." no matter if is access, sqlserver, dns, locally or remotely

Do you have more ideas about this?

Thank you again