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

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/

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!

ASP pages bogged down with too much server side code

shawn.bordeaux — Tue, 03 Mar 2009 19:29:56 GMT

I have a few web applications that I have created using ASP classic. My problem is that some of the pages require running multple recordsets so the data can be used to run another recordset which stores the data which is ultimatley being accessed. In other words something like this;

Set Rs = Server.CreateObject("ADODB.Recordset")
SQL_Select1 = "SELECT idnumber from users WHERE idnumber IS NOT NULL"
if not rs.eof Then
do while not rs.eof
Set R2 = Server.CreateObject("ADODB.Recordset")
   SQL_Select2 = "SELECT reques_id from current_user_entries WHERE idnumber='&Rs("idnumber")"
if not rs2.eof Then
do while not rs2.eof
    Set Rs3 = Server.CreateObject("ADODB.Recordset")
          SQL_Seect3 = "SELECT * from catalog_merchandise WHERE productid='&Rs2("requeted_id") "
if not rs3.eof Then
do while not rs3.eof
' process stuff here including INSERT into table...
rs3.movenext
rs3.loop
End If
rs2.movenext
rs2.loop
End If
rs.movenext
loop
End If

Well anyways this is not really my code but just an example. I also run A LOT of IF Statements to check the data and assign appropriate variables. Some of my pages are nearly 1000 lines of asp code doing this.

On top of that, all the records I am loading I then have to insert them into another table and the load times are extremley long. Any advice or tips of things I can do to speed up the server load time? Can any code likes this be done on client side?
I can upload or copy and paste some of my real code so if anyone here is up to the task of looking it over and giving me some advise on more efficient ways of writing these pages I would greatly appreciate it. Keep in mind I am fairly new at this. I have created quite a few web apps in ASP without any real structured training. Just on things I've picked up on the way.

Thank you in advance!

Best regards,

Shawn

Multiple session cookies problem

neitakk — Fri, 27 Feb 2009 23:13:51 GMT

Hi. I'm gonna try to explain the problem in short terms: On a shared Windows server which my host provide me, I'm getting multiple session cookies stored in the browser. This regards all browser types.

A clean ASP file with no code other then "response.write("Hello")
Updating the page in e.g. 5 minutes intervals
Every new session seems to make a new session cookie with a new ID
Eventually the cookie storage is full

Why this is a problem? After the storage get's filled up, there is impossible to write custom cookies like for a login. This makes big problems for my users who never close the browser. The only way to get rid of the cookies is by manually deleting them or restarting the browser. How is it possible to avoid this problem?

ASP HTML MAIL Get ! inserted in various places

tdmhighway — Thu, 26 Feb 2009 01:25:42 GMT

I have written some ASP code to use HTML as the e-mail body. In the received e-mails I get "!" inserted in various places. This does not occur on the presented ASP page. Anyone have any ideas?

Error only on my PC - ADODB.Stream error '800a0bbc' Write to file failed.

shawn.bordeaux — Thu, 19 Feb 2009 18:59:14 GMT

This is the strangest thing... I have a group of asp files that allow a user to upload a file to our server. I normally process an upload file every other week. Well I went to process the file this morning and I recieved this error code;

ADODB.Stream error '800a0bbc' Write to file failed.

At first I thought the folder on the IIS server had it's write access changed, so i checked. And it is all fine. So then just on a hunch I tried loading files from another PC here at work and sure enough the files uploaded fine with no error. So for somereason the error only happens when I try to upload the file from my PC to the Server.

Okay so then I went outside of all logic and tried 3 different browsers on my pc, I.E.8 Beta, Firefox and Google Chrome, ALL WITH THE SAME ERROR.

I am at a total loss at this point. I am out of creative ideas. I thought maybe my virtual local ISS maybe the issue or my VPN connection to the server I have running however they all worked upto 2 weeks ago. I turned off my VPN and still recieved the same error.

I will be willing to try anything anyone here can suggest. Thank you!!

System Details

Server Details
Windows 2000 Server
SQL Server

Shawn Bordeaux

***UPDATE*****

By the way the file that is causing the error is;

../includes/functions/clsField.asp, line 171

That line in that file is;
Call lobjStream.SaveToFile(pstrFileName, adSaveCreateOverWrite)

The clsField.asp page is called from the clsUpload.asp page which is included into my upload_process page. It is accessing that command once it tries to save the binary file to the server and that line in the upload_process.asp page is;

objUpload("File1").SaveAs strPath

File1 is the name for the file selected from the form input. The strPath variable is defined above that line as;
strPath = Server.MapPath("../../hours/files") & "\" & strFileName

and strFileName is defined by the file name selected from the form. And like I said it works fine on other PC's....