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 ).
View Complete Forum Thread with Replies
See Related Forum Messages: Follow the Links Below to View Complete Thread
VB Configuration
Hi. We have an old ugly application that uses ASP 3.0. We had to move it to another server recently (basically by copying it and setting up in IIS), and as we did, we started experiencing problems with VB. The code that somehow worked on the old server produces errors. The most frequent example is If Request("ddlFilter") then .... It worked on the old server, now it gives us a type mismatch error. Also, the errors about index not being in the collection (such as recordset column) were swallowed (didn't occur) before and now they actually occur, overall it's like VB went to "strict mode" or something. How do we make it lax again? Rewriting all that legacy code will be a pita
IIS Configuration
I am trying to configure a new site with IIS. I set up the virtual directory. When I tried to view it, by typing the ip addr. it does go to the index.shtm, but goes to another page. Then when I tried to view the index.shm it shows only the html content. It gives a file not found error for the Virtual Incude (asp ) files. Is there something to be done to view the virtual include files?
Keep The Configuration
I'm using ASP to design a website. I know that I can keep some configurable values, such as Server Name, Database Name and even Login Username and Password in "web.config" under ASP.Net. As to ASP, is there a way like this? I'm curious about where to keep them.
ASP Configuration
I have looked everywhere for asp code that would allow me to change the look of my IIS server generated directory listings. Eventually, I would love to change what is listed dynamically based on permissions, and allow uploading in the current directories.
Product Configuration
I am trying to create a product configuration tool and I'm not sure where to start. I have made a database with 4 columns..ID, component, compdescription and compcode. There are 8 different componets to configure on the product and the compcode holds the letters and numbers that eventually make up the part number when you make all your selections. I want to be able to select one thing from each component category and submit to the database which will return a part number. I thought the easiest way to do this would be with 8 different drop down menus filled with all the options for that component category.
Flexisearch Database Configuration
i have downloaded the elijathegold's flexisearch coding, but when i create the database and the table DisWords, and change the database connection from DBConn.Open "YOUR DATABASE CONNECTION STRING" to DBConn.open = server.Mappath("/flexisearch/new.mdb")<-line 54 an error message pop up and shown Error Type: Microsoft OLE DB Provider for ODBC Drivers (0x80004005) [Microsoft][ODBC Driver Manager] Data source name too long /flexisearch/flexitestbed.asp, line 54, hope the creator elijathegold or someone else have tried this fleixsearch can help me with this, thx a million
Oracle Configuration Files
when I tried to run my ASP,I'm getting an error and to fix it, I need to run the configuriation file.but tnsping is not installed proper it seems.So can any one plz tell me the procedure to regenerate the oracle control files on WinXp?
Basic DNS Configuration Question
Everything appears to be (mostly) there, with one significant annoying exception. I've set up "mydomain.net" as a forward lookup zone in the DNS console. I've set up admin and www as hosts, so that I have subdomains: people can visit www.mydomain.net and admin.mydomain.net without a problem. I have each of these listed in IIS as host headers entries, so that the webserver correctly differentiates the traffic. This all seems to work fine. People can go to http://www.mydomain.net/index.html and they're served a webpage. Code:
Error: The SendUsing Configuration Value Is Invalid.
i am testing the sending email when u submit a form .. but i am getting an error: <% Set myMail=CreateObject("CDO.Message") myMail.Subject="Email Send" myMail.From="quince_103@hotmail.com" myMail.To="qb_103@hotmail.com" myMail.TextBody="This is a message." myMail.Send response.redirect("index1.asp") %> the error is: Error Type: CDO.Message.1 (0x80040220) The "SendUsing" configuration value is invalid. /middle/email.asp, line 7 line 7 is ==> myMail.send so what shell i do .. ?
Formmail :: The SendUsing Configuration Value Is Invalid
Can someone please help with this, I am receiving this error from my simple form: CDO.Message.1 error '80040220' . The "SendUsing" configuration value is invalid /scripts/formmail.asp, line 19 Here is the asp script I'm using:......
Cdonts Using Exchange Server- Configuration
I am having a problem here to send my asp form to my email! I am using CDONTS under w2k and IIS! when i submit the form, all of the message (that suppose to go to my email), went to the queue folder under wwwroot!! nothing appear to my yahoo email also... that means that my script is working...but only the configuration is need to be adjust here! the thing is that i dont know how to configure, setup or setting the configuration for Exchange server! since my organization uses exchange server instead of the SMTP!
Proxy Configuration Tool - Proxycfg.exe
I wasnt really sure where to put this thread so I have put it in both ASP and DNS forums - i hope this is ok. My problem feels incredibly complicated so Im hoping that someone on one of the forums might know a few things . Im interested in getting remote data off of a URL using ASP. There is an article about it at the URL below: Code:
Sending Email With CDO - The SendUsing Configuration Value Is Invalid.
Trying to send email via a form from my website. Have to use .asp and I have been round and round the houses trying to get this to work. On my xp pro system using IIS this works - an email appears in the folder When it is hosted I get this error message. I understood that I didn't need to set up any details about the host of the website. Lots of seaches suggest putting in the smtp address but I am not sure what to do. I have also seen a lot of talk about CDO.configuration but again despite searching I can't find out what to do. CDO.Message.1 error '80040220' The "SendUsing" configuration value is invalid. /version1/contact/email3.asp, line 51 Here's a cut down version of my page....
The "SendUsing" Configuration Value Is Invalid.
I creade a project where the user was able to sent e-mails it was working ok until I format my PC. After the format i installed again windows 2000 but i beleve is a diferent version that the previuse one and the e-mails now can not be sent the error that i get is that: Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Runtime.InteropServices.COMException: The "SendUsing" configuration value is invalid. Source Error: Code:
ASP / XML Issue With IIS
We have an ASP file (listener.asp) that is used to process SOAP transactions on our web server. The ASP file uses XML Core Services to load an XML file into a DOM document variable. We process around 50,000 transactions a day using this process. We have been getting intermittent errors while trying to load the XML file. We typically receive between 3 and 20 errors a day. We have attempted many different fixes and we recently upgraded to XML Core Services 4.0. None of our attempts have been successful in resolving the issue. Here is an excerpt of the code that fails. Set oXMLDoc = Server.CreateObject ("Msxml2.DomDocument.4.0") oXMLDoc.async = false oXMLDoc.Load (strSchemaLocPhys) where strSchemaLocPhys is "C:InetpubwwwrootcbwapiprodCBWWorkflow.xml".
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....
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: <!--#include file="../includes/inc_config.asp" -->
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:
|