ASP :: ASP / XML Issue With IIS

Issue With ASP And Win XP
We are using Microsoft Office Web Components 11.0 in our asp page to use Pivot Table component.

It is running well on all OS except Windows XP. On Windows XP system the pivot table control is not displayed in ASP page. Am I missing something? Any workarounds?

IIS Issue
I am getting the following error:

Unable to open web project 'DNCWebApp'. Unable to validate that the file path 'C:InetPubwwwrootSamplesDNCWebApp' matches the URL path 'http://localhost:/DNCWebApp'. A connection with the server could not be established.

I have copied the samples directory to the wwwroot folder and created a virtual directory pointing to the DNCWebApp directory which is inside the Samples directory. When I try to open the csproj file I get the error mentioned above.

Cookies Issue
I have an application that when it loads, it checks for a cookie on the client side. If the cookie exists, it sets a variable on the specific ASP page for certain fields to be populated. Our problem is that some user sessions have data left over in cookies that
are from a previous user session....

ASP/IIS Configuration Issue
I think this error that I am receiving is a simple one to resolve.

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

I have downloaded and installed the latest version of MDAC but the error remains.

I am attempting to configure IIS on a different drive ( E:inetpubwwwroot, instead of c:inetputwwwroot ). Could it be that SQL, ASP and IIS just have trouble talking across multiple drives? ( I have sql installed on a third drive ).

CDO Issue With Badmail
Usually when I setup a web form with CDO I either set the "From" field
in the email to either:

1. The email address of the person filling out the form, in which case
user errors often result in the mail getting stuck in the badmail folder
and not being sent

2. An alias for the client (like Join Bytes!) to guarantee that it
gets delivered, but this is less convenient for the client as they can't
just reply-to the message, they have to manually change the address (not
a big deal, but annoying)

Is there another way to guarantee that even with a bad "from" address
scenario #1 will work every time? Or some other option I'm too dense to
have realized?

ASP And Query Issue
I have an issue trying to render a report. The report comes from a submitted ASP page that exports into Excel. My data comes from a stored procedure. That data outputs a current rank, previous rank, dealer name, current total, previous total, difference of totals, and % of totals.

For some reason though, the stored procedure has a loop hole somewhere. I am comparing Dealers sales from one year to the next. They are uniquely identified by the phone numbers. I am UNABLE to get dealers who did business in 2005 but currently have less than a $1 in sales for 2006. However, I do get dealers with sales in 2006 but no sales in 2005. Am I making any sense? Code:

Rs.GetRows Issue
Since I never user .GetRow, (because arrays drive me crazy) I thought I'd give it a shot with something I had to do, unfortunately I get several errors. Code:

AdUseClient Issue..
I do not see what I am missing from this partial code to return values from a SQL db and then eventually use paging with the recordset. It errors on the line with adUseClient. The error that is returned is...

Object doesn't support this property or method: 'adUseClient' Code:

ASP Session Issue
We have recently upgraded to a Windows 2003 Standard Edition Server, running IIS 6.0 and have subsequently had some issues with our ASP sites. When the user logs in, it does not immediately recognize they are logged in (based on the session variable we set) and stays on the login page. Once you hit refresh then it shows the logged in interface.

Furthermore, once they try and navigate the site, it timeout after maybe 5-15 seconds and brings them back to the login page. So for some reason the session variables are being eliminated prior to the timeout we have set, which is 30 minutes (set in IIS).

I also set the Session.Timeout value directly in the script and that still has not solved the issue. All of our ASP sites were functioning correctly prior to the upgrade so this leads me to believe that it has to do with that.

The only other significant software change was that we upgraded or Cold Fusion software from 4.5 to 6.1 (CFMX). While this should not be a factor I thought I would include it as another potential cause.

Money Issue
i have a field which has datatype as money
when i add a value in it like 110.00

rsadd("Amount")=txtamount

it comes like $110.00 which is right
what i want to do is instead of $110.00 i want -$110.00

i tried like this
rsadd("Amount")="-" & txtamount

when it added it came like this ($110.00)

Storage Issue
I want to have a variable in wich I will store a date.
this variable should be stored in a DataBase, because I want it to be in all my website pages and I don't want it to be erased after the web host starts over (that marks out application variables).
The real problem here isn't were to store it, cause that's gotta be in a DB (I think), but how to store it.
I don't want to make a whole table with one feild in it only for one row, thats total waste of place on my host.

Validation Issue
Im dynamically generating the contents of a form with details read from a text file and the names im assigning to the controls are also dynamic.[The Labels of the Control.]
The problem now is that, i dont know how do validate these controls for the mandatory check!!

[Is there any option to iterate the entire controls present in a form??]

Connection Issue
This website is running on IIS 6, SQL Server 7 back end, asp scripting.

It has public and private areas, but uses the same connection scripting
throughout the entire site.

SET conn = server.createobject ("adodb.connection")
conn.open Session("DSN")

strUserID = request.form("txtUserID")

SET rsUserCheck = Server.CreateObject("ADODB.Recordset")
rsUserCheck.CursorLocation = 3
rsUserCheck.open "SELECT * FROM tblUSERS WHERE UserWebAuthorityLevel = 1 AND
UserID = '" & strUserID & "'",conn

From Global.asa: Session("DSN") =
"dsn=AWS_SQL;uid=IUSR_Hurricane;pwd=<>;DATABASE=AWS_SQL;APP=ASP
Script;Trusted_Connection=yes"

Although thousands of users connect successfully using the above every day,
2 users are getting the following message when going to the page, even when
using the correct UserID and password.

The connection cannot be used to perform this operation. It is either closed
or invalid in this context.

The error references the line "rsUserCheck.open "SELECT ..."

One of the users has a 3-computer home network, with 2 of the 3 computers
logging on without a problem. The same is true within another network,
where some work and others don't. Otherwise, the vast majority of users are
having no problem whatsoever.

Have you heard of this happening before? Is this an IIS issue?

Display Issue
i have a problem with a image displayed in pop up window

i have a radio button and next to it some text which says View image

when you click on view image a pop up window pops up and shows the image

with my case i cant see the image

i have the image in the folder

can someone tell me whats wrong Code:

Issue With ServerXMLHTTP
I am trying to use ServerXMLHTTP to grab the HTTP Header from a page using the following code but it doesn't work.

<%
Response.Write "Output"
Set getPage = Server.CreateObject("MSXML2.ServerXMLHTTP")
getPage.Open "HEAD", "http://www.example.com", false
getPage.SetRequestHeader "Content-type", "text/html"
getPage.Send
Response.Write(getPage.responseText)
Set getPage = Nothing
%>

I want to use HEAD instead of GET in order to save bandwidth. I don't want to retrieve the full html of a page, just the HTTP header to know that a file exists:

HTTP/1.0 200 OK
or that a file is not found
HTTP/1.0 404 Not Found

This is for a link checker that I am writing. Does anyone know what I am doing wrong or does this object not recognise the HEAD parameter?

ASP Currency Issue
i have a textbox where a user enters a number when he submits that page i want to show the number entered as currency:

say for example he entered 12

next page i want to show $12.00

i did this:

txtprice=Cast(txtprice AS MONEY)

but its throwing an error

any idea how to work this out

ASP - Excel Issue
The following is the 5th line of my ASP page and while executing the page im getting the

Set MyExcelChart = Server.CreateObject("Excel.Sheet")

the following error!!

Error Type:
Server object, ASP 0177 (0x8001010A)
The message filter indicated that the application is busy.
/tpp/Dynamic/myexcelchart.asp, line 5

What should i do to proceed further??

<Backspace> Key Issue.
I created a full asp web application. I have most of the bugs worked out of it. However, when I turned it over to the end-users for testing they found a wierd situation, as end-users will, that I hadn't come across.

When a users is filling in a form and they land on a dropdown box, if the user hits the <Backspace> key it takes them back one page.

Since this is my first asp project and Im not that experiainced with web applications, I wasn't sure if this was really an issue. Since this doesn't happen when the user lands on any other control, text, check box, option button etc... Code:

Date Value Issue
I am trying to retrieve a count of booking entries made 30 days ago, below
is the end of the query I am having problems with.

dbo.booking_form.TimeOfBooking = DATEADD(day, -30, GetDate()) GROUP BY
dbo.booking_form.TimeOfBooking")

When I use the = sign the error reads

Either BOF or EOF is True, or the current record has been deleted. Requested
operation requires a current record.

for the entry on the page

(rsCash30("CountOfTimeOfBooking"))

But I know the record exists

Date Issue
I have a field in the table which stores date and datatype is datetime name is Dept_Date
for example the values in the field are like this

5/16/2005 9:11:13 AM

now i have my code like this

d="5/16/2005'

Code:

Set rs= Server.CreateObject("adodb.RecordSet")
str ="SELECT * from Dept where Dept_Date='" & d & "'"
rs.Open str, Conn, 2, 2

Date Issue...
Would anyone know how to format the year as the last two numbers? Like this - May 5, 05

Minor Issue
I have an asp page which posts a form (made up of fields with drop down lists) to itself. The page then queries a sql server database when the form is submitted and creates a table with the results below the original form. This all works fine.
However, when a user submits the form and the page is reloaded with the results, I want the page to focus on the newly created table + results rather than the top of the page (form).I have tried using vbscript to get the page to focus on the table everytime the form is submitted but have had no success. Is there a way to make this work?

Printing Issue
I have this code on the page which displays a image.

<a href="print.asp?id=<%=ID%>"><img src="/image/imglink.gif" border="0" /></a>

When a person clicks on the image it opens up print.asp
What i want to do is when a person clicks on the image i want to print the page print.asp
i tried window.print but its not working
can someone tell me what i am doing wrong

Exporting To CSV Issue
I am using a SQL 2000 server and am trying to export results from a
query to a text file. The code is working, expect my CONTACTNAME field
has a comma, and my export is splitting that into 2 columns when I only
want it to be one. Code:

Connection Issue
i have this code on my page and whats happening is when the user fills out all the information and submits the form it times out i think i am doing something wrong with closing the connection

the data is added in the table in thr right way i am just not getting where to close the database connection here is my code:

HTTP_REFERER Issue
Just wondering if anyone has found a way to grab the referring URL if the resulting page isn't from a HREF link.

To explain further:

I am creating an ASP driven weblog and am trying to avoid using the queryString to pull out the correct posts (Primarily for better search engine results). To do this I would like the user to be able to click on or type in something like

http://host/weblog/year/month/shorttitle

Under normal circumstances this would look for the default page in a folder called "shorttitle" but instead I defer this to a custom 404 error page which would strip out the URL and do a database query depending on the year, month and shorttitle.

However - this all works a treat when you click a generated link as the HTTP_REFERER is sent through in the headers, but if this is simply typed into the address bar the HTTP_REFERER is blank upon reaching the 404 page.

ASP Database Issue
Does anyone know what this error message means?

ADODB.Recordset.1 (0x800A0BB9)The application is using arguments that are of the wrong type, are out of acceptable range, or are in conflict with one another.

I get it while trying to load my default.asp

Security Issue
I wonder whether it is safe to store the database username and password in a
ASP page. Is there any chance that a user can down load the actual file?

Server Issue
FirMy default.asp will not load. It shows the directory listing instead.

Second problem...
When I do load the default.asp page I get this error message:

The Include file '../includes/inc_config.asp' cannot contain '..' to indicate the parent directory.

/home/default.asp, line 1

This is the first line on my default.asp page:

Connection Issue
i have a access file connected to a site through asp, and the connection i made is :

dim adocon
dim rsaddcomments
dim str
Set adocon = Server.CreateObject("ADODB.Connection")
adocon.Open "cmpda_all"
Set rsaddcomments = server.CreateObject("ADODB.recordset")
str = "SELECT * FROM plaint; "

rsaddcomments.cursortype = 2
rsaddcomments.locktype = 3

but on condition on the server they must do the system DSN and calle it cmpda_all and point to the database file, but they didn't do it and i am still waiting for them,is there another way to connect to the file, because the interactive site is not working he is giving a message error of ODBC.

Datatype Issue
i am having a small problem here i use sql server 2000 and in it the fields datatype is money i am displaying some items and here is how i do Code:

Drop Down Issue
i need some help i have a drop down and when the user selects the value in drop down i want a page called display to be called and pass a value to that page here is my code

i have written the onclick event but its not working i have also tried onchange Code:

Display Issue
the problem i am having is i only want to display the transactionid and customer name and date recieved right now its showing the orderid and customerid

i know i have to change the code in this line

Response.Write "<a href=""orderdetails.asp?transid=" & objPagingRS("Transaction_Id") & "&orderid=" & objPagingRS("Order_Id") & " &customerid=" & objPagingRS("Customer_Id") & """>"& objPagingRS.Fields(I) & "</a>"

i want the orderid and customerid to be send through querystring Code:

Another Minor Issue
I wasn't sure where to post this as it is more to do with html but it arises within an asp page. Basically I have a form which collects information (search strings) from users, These strings are then used to query an sql server database and the results printed to a table. An example of what the table looks like is shown below. Code:

Internet Issue
Issue: whenever I try to get online, a window pops up on the screen
and gives a message, "the webpage you are requesting is not available offline. To connect,
click connect tab".

And later I can get online, or sometimes it never let me to connect to
internet. I'm fed up with this problem. I tried doing many steps to
block this message. Nonetheless, I always see this pop up.
Steps which I performed: 1. uninstalled the network drivers &
restarted the computer.

List Box Issue?
i have a registration page which user can register. in admin side i want 2 see month wise register people. i mean i want 2 see how many peoples are registered in a month and
and also i can see the multiple month. here is the screeshot

the database is in access. when i click show list it can show me the user which are register in january, feb, april...

Cdonts Issue
We are using CDONTS to send email through ASP.However, occassionly, a constant stream of emails is being placed in the 'inetpub/mailroot/pickup' directory with the "TO:" email address set to "none". The email is valid but the "To" address is not. These are filling our hard disk and slowing the server.

Conurrency Issue
I have a webpage,where users enter data and submit the data,after which they r edirected to thank you page(with their id generated on submit),where there is a link clicking which a new window is opened with their submitted data..what concurrency issue I will face.

CDONTS Issue (SMS)
I'm setting up an ASP page that will take a cell phone number/carrier and e-mail some info as a text message to a client's cell phone. I have the e-mail addresses for the major cell phone carriers. The problem is, it seems that certain carriers interpret the HTML BR tag differently. If I use BR, it shows up "properly" on a Cingular phone, but doesn't break at all on a Verizon phone. Is there a way I can handle this within CDONTS or is there some other method I can use? Would vbCrLf work?

Secure Issue
there is a way to post form variables in the best secure way... i don't sure how or what is the technical way to do this and that is the aim of this subject... but somehow the form write all the inputes into cookie and than the asp file read the form outputs from the cookie and not from the form itself... why? how it works?

Session Issue
I have a form that has few text boxes to input. However,after saving, if the user comes back to the same form, then the input boxes should be locked. I would like to know whether this can be handled by session("locked") variable or any other way.

Security Issue
Is it possible to define an account in <Identity> in web.config which dosen't exist in domain?

I was viewing somebody's application I found the following line in his web.config

<identity impersonate="true" userName="DOMAIN_NAMEASP_NET_TESTER"
password="TEST"/>

but problem is that I didn't find user ASP_NET_TESTER on the domain and application is working fine. By the way,he has enabeld annonymous access to his web application using a completely diferent account called "IUSR_DEV"

Mysmartupload Issue
I'm trying to rename the aspsmartupload filename but having issues.

Set mySmartUpload = Server.CreateObject("aspSmartUpload.SmartUpload")
mySmartUpload.Upload
set mySmartUpload.Files.Item(1).FileName = mySmartUpload.Form("year") &
mySmartUpload.Files.Item(1).FileName

this is the error I get

Microsoft VBScript runtime error '800a01a8'

Object required: 'FileName'

the filename will write to the screen with no problems, as well, I tried assigning a simple string to the filename but with no success. Can you even change mysmartupload data? I hoped you could.

Timeout Issue
I am having a time out issue when multiple users are accessing the server. This time out does not happen all of the time. My understanding is that the time out value is actually set in two places. I believe one is in the asp pages for the session itself, and the other is more of a system timeout settting in IIS. Would one of these supercede the other if the two are different?

I have already looked at the time out setting in IIS, and it is set to 900 seconds. However, the actual timeout is happening in much less than 900 seconds, so either the setting on the asp page is controlling this, or the "900" is not really seconds but some other measure.

Www.<dynamiclink> ISsue
I am developing a site where we will have different kinds of products

for example
Electronic items
Electrical Items
Mechanical items
Food Items.

so what the client want is like this

www.<fixedname>.com/<ITEMNAME>
eg.
www.ItemsSelling.com/Electronic

< user dont know weather the files are asp or cfm or php or html and so we cant expect them to type electronic.asp > if user type like this then it should go to that page loading electronic items.

Forwarded URL Issue
I have a domain name assume "www.domainnew.com" which I am forwarding to "www.domainold.com/new" with mask. It works fine. My problem is I have a page call login.asp in the directory new.(I don't want to give the link from www.newdomain.com) I want the admin to go directly to www.domainnew.com/new/login.asp.(which I cannot)and not
through www.domainold.com/new/login.asp (which I can).

Asp Security Issue
i have a security issue, once you have logged into my website you can add the logged in page to your favourites so that in the future you can by-pass the login page an go straight to that page. a) prevent them adding the page to their favourites or b)make the page check if they are logged in and if they are not re-direct them to the login page.