Hello, How to send data through winhttpd and process the data in the target page? Any suggestions? GTS ...more >>

Hello, I have the following structure, Form page My Server 2nd server html ---------->My.asp------->2server.asp User can submit the form in html to myasp. In my.asp I am using winhttp to send the form values and some additional values to the other server's asp page without...more >>

Hi, I am new to asp and am building a gradebook app. in asp vbscript using dreamweaver mx 2004 and access 2000. I need to know, in order to calculate student averages, do I code an asp page or do I code something in the db. I also need to be able to calculate separate category averages (ie: Hom...more >>

Hello, I have the following structure, Form page My Server 2nd server html ---------->My.asp------->2server.asp User can submit the form in html to myasp. In my.asp I am using winhttp to send the form values and some additional values to the other server's asp page without...more >>

Taking data from a form, and using UPDATE tablename SET Seems to be working fine... EXCEPT.. Certain characters cause an error when the update happens. These include: ' " ' causes an SQL error (Syntax error (missing operator) in query expression) " data after or between the "" is n...more >>

hi, When I open the connection to a JET database, I get 80004005 "unknown error". I know, it's usually permission problem, but I added all users to the db directory, and have this error only if I debug the application: (environment: "celan" w2000prof, interdev server, all patches.) here are...more >>

I have a small ASP app on our intranet that handles the internal contact list. Nothing special, some tables for the department and employee details. I now have a request for providing a history of changes. Currently I capture the user ID making changes and the time, and store them in fields...more >>

Hello! I have some records in a database (access), like this: 001111-10 001111-11 001111-12 002222-10 002222-11 002222-12 I need to retrive the first record of each sequence, "001111-10" and "002222-10" in the example above. Next part is I need to show only the first part of each rec...more >>

I am really new to ASP I have not been able to find anything to help me with this question. I have a form in an asp page which pulls information from a SQL database and writes to the same database. The form has a drop down list. I check to see if a value exists in TableOne.ProjectType and i...more >>

Hi, I use ASP code to generate report that I retrieve about 100,000 to 800,000 records from database using ADODB.Recordset. But when i run the code, it show me the following error.Sometimes it wont show me this error and it can be run. But if the records near 800,000 then program show me the fol...more >>

Hi, i have a site running in asp with an access database that is being queried. If i'm uploading my database to the server, and at that same time someone is accessing the site, everything "crashes" i.e. the asp-app doesn't work anymore. Could this have to do with the way i'm opening the d...more >>

So I read in this excel file and sort it the way I need to validate it, however, I now want to get the row number where the error is and I cannot just count the records I read because the sorted recordset is not in sync with the the file. So is there someplace I can get the real row number of ...more >>

I receive an error like this: Server.MapPath() error 'ASP 0172 : 80004005' Invalid Path /conn.asp, line 2 The Path parameter for the MapPath method must be a virtual path. A physical path was used. the conn.asp code : <% cst = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=...more >>

I am working on a page that will display a list of manufacturers that we have available. I want to check against the products table to verify if a manufacturer has products in the database or not. I do not want any information from the products table, only to return a count or boolean if produ...more >>

Apologies for cross posting - I think this is a more appropriate newsgroup than the general one I originally posted in. ********************* Hi - I've got a really strange problem I can't explain - when I add new values into my database (Access) it multiplies them by 100 - for example if I...more >>

Hello I have a exceldocument im trying to insert to, and in the exceldocument ive selected whole column and picked "text" as datatype, but it says: Microsoft JET Database Engine error '80040e57' The field is too small to accept the amount of data you attempted to add. Try inserting or p...more >>

I have a site that is hosted on a Win 2003 Server, IIS6, ASP.NET, MS Access, MS SQL Server. My site pulls dbase results and some users want to be able to sort the data by clicking the header of the result. For example: Column Names = Invoice Number, Client, Invoice Date How ca...more >>

I have 2 tables merely used for viewing (no updating or deleting or adding, etc.). table one has records of shipments and includes the file number as a field (file_num). table 2 holds comments about the progress of shipments, and also includes the field (file_num) I haven't linked the t...more >>

To all interested, I am trying to run Crystal Reports via ASP through an Oracle 8.1.7 connection. Every time I try to run the webpage, I get the following error displayed on the page: Error Occurred Reading Records: Logon failed. Details: 28000:[Oracle][ODBC][Ora]ORA-01005: null password g...more >>

Our graphic designer has just finished redeveloping our website. On the site, we use SSL to secure the area where a user enters their personal information to order items from us. (we do not do many transactions - maybe 1 per day...) We are a log home mfg company so they would only order plan boo...more >>

I have come across a problem with my asp pages and the database. I am working on a Employee database, and one of the fields in the DB is Address. Well this one employee happens to live on the following road, Martha's Knob Road. The problem I am having is when I try to update this record using ...more >>

What does this mean? I am accessing an ASP page that queries Access Database thru fileDSN. I'm using IIS 5.0 Win2K SP4 Microsoft OLE DB Provider for ODBC Drivers error '80004005' [Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key 'Temporary (volatile) Jet DS...more >>

Hi, I use ASP code to generate report that I retrieve about 100,000 to 800,000 records from database using ADODB.Recordset. But when i run the code, it show me the following error. Provider error '8007000e' Not enough storage is available to complete this operation. /e-survey/progress3.asp,...more >>

Hello! Shortly: I have a simple Jet OLEDB query using "LIKE" operator, which works from VB, Access, WSH, etc.., but DOES NOT from ASP page. (As my earlier thread in asp newsgroup I wrote my strange problem, see: ASP ..mdb ADO OLE automation error - but works in access!" I had not any soluti...more >>

Hello Im having problems, I need to insert more than 255 chars into an excelcolumn and i get: "Data type mismatch in criteria expression." insert into [Synpunkter$]([Ämne],[Fel/Synpunkt],[Frågeställare],Svar,Datum,Status)values ('VAFocus - ADH','Item cannot be found in the collection cor...more >>

Hi all, Quite a newbie with this. I have created an asp page with a datagrid. I have used the data controls provided by Visual Studio (VB.Net) for the adapter, connection and dataset. I have set the DG's DataSource to the Dataset and enabled the paging property within the columns collection. T...more >>

Hello I'm using sql server 2000 database and trying to execute one query but getting error in correct syntax near word 'order'...duedate is the field name on which i performing sorting... below is the sql sql = "SELECT TOP 20 rows FROM (SELECT TOP 100 rows FROM tablename ORDER BY Due...more >>

I know this is an ASP group, but I'm curious if (and how) I can use the saved parameter query I learned to do in ASP in ASP.NET as well? Does one merely add the parameters after the sql string like in ASP. Also wondering if trying to do this in ASP.NET has any advantages, since ASP.NET compi...more >>

Hello, I am trying to do a simple update on employee information. I am a novice at both aspx and SQLServer, so I hope you are not too offended by my code. The following is the update code: --Start of code-- dim objConnection as SqlConnection dim daAddEmp as SqlDataAdapter dim strconnectio...more >>

Dear Friends Hope you all doing great. I am facing a problem connecting to my database after uploading the files to webserver. They work fine on my IIS6 server I am at home, but they dont work online. I am having following folder structure rootfolder (which containcs all the website fiel...more >>

Is there a shorter way to write the following query? I want to do it for each type of ServerRole and there will eventually be many types... not just exp/prod/q/test/etc...: select i.User, count(p.serverRole) as 'PROD', count(t.ServerRole) as 'Test', count(q.ServerRole) as 'Q',count(s.ServerRo...more >>

I'm working on an ASP Web application, and am having syntax issues in a WHERE statement I'm trying to write that uses the CInt Function on a field. Basically, I want to select records using criteria of Race, Gender and Crime Code. But the Crime Code field in the table is text, and I cannot ch...more >>

Hello! I have an ASP page using Jet 4.0 oldeb provider for mdb. (ADO 2.8). I use the _same_ code in ASP from my well working VB application. The problem is: when I do the same "SELECT * FROM table WHERE field1 LIKE '%asdf%' " query, it works in Access (SQL query) or in my VB .exe code, but...more >>

Hi, I am trying to read excel file with ADODB (with DSN) my connect going file but when my ADODB.Recordset open it give me following error ========== code ========= line:24 objRS.Source = "Select * from pro12_as" line:25 objRS.Open ==== error ============= Microsoft O...more >>

Is it possible to extend this User Login SP to return a error if the column u_ExpiryDate is < Todays Date and based on this send him to an registration-update page.....? I have included sample: SP, table, an calling asp SP code: (1) - Stored Procedure SET QUOTED_IDENTIFIER ON GO SET ANSI_NU...more >>

Hello, I am trying to insert/update a field with double quote " . But SQL database will not take it. Anyone have a solution? Thanks, ---------------------- set rs= Server.CreateObject("ADODB.Recordset") rs.open "update mytable set name= ' my name" ' where id= 100 ", strDocCon ...more >>

I dunno if this has been asked before but google didnt get my anything relevant. If i use set conn = Server.CreateObject("ADODB.Connection") strConn = "PROVIDER=MSDASQL; DRIVER={SQL Server}; SERVER=FERRARI;DATABASE=SWORDFISH; UID=application;PWD=tr4nsf0rm3r;" conn.open strConn strSQL = ...more >>

In ASP.net Is there a way of deleting all the rows in a table in the dataset. In regards to deleting all the rows is there a Delete/Remove function similar to the simple update function of an DataAdapter i.e objDataAdapter.Update(objDataSet, "TableName")? In relation to updating is th...more >>

Question, Is it possible to develope asp on a pc which doesn't have a webserver? Is there any tool who can?...more >>

I have Access 2000 and I'm trying to used stored procedures. I'm trying to create the procedure from ASP to avoid the query editor in Access from mangling my SQL. I keep getting the same error message: Microsoft OLE DB Provider for ODBC Drivers (0x80040E14) [Microsoft][ODBC Microsoft Access ...more >>

Hi, I've got a web app that has a reasonably small database. I've got a stored proc which returns around 7 recordsets, and everything works fine. Problem I've got - on ONE SINGLE RECORD every time I access it through an ASP page, I get the error: Microsoft OLE DB Provider for SQL Server ...more >>

Hello all: I have an Access 2003 database and a set of ASP pages. The database contains very basic information consisting of first and last names and 1-10 dates. I would like to create a query in ASP or inside of Access that I can use the SQL from to call data from the webpage that allows...more >>

I have a Dell Dimension computer with Windows XP, when I now go to launch the internet, I recieve 3 pop ups, need to install win2.0, one for MFC.DLL and one of win32.msirefr, what do I do to resolve...more >>

Hi all, On July the fifth I did ask about the same question on this forum. Ray answer me with a with good examples but I miss something and I cannot get the expected result. I will use the phrase Ray did use in his response, which is: Joe's cat walked up to Mary O'Brien's dog and said, "Meow!...more >>

I have just moved from IIS 5 to IIS 6. I have price lists on an asp page from a sql database. They worked fine in IIS 5 but now in IIS 6 I am getting a: Response Buffer Limit Exceeded. Execution of the ASP page caused the Response Buffer to exceed its configured limit. The page is tr...more >>

Do I need to close and destroy the database connection objects ON EACH PAGE when I have my site set up as an application (using eg. conn.Close : Set conn = nothing)? I normally close my db connection objects on asp pages that are NOT set up as an application, but does this also apply to asp pa...more >>

Hi all, I am trying to pull information by query using a pretty long SQL (feeding it by ADOConnection.Execute). I get this error: 0x80004005 Unspecified error If I change that to a simple "SELECT * FROM table", it won't happen. I put it in view so that I can call the view instead of us...more >>

In order to analyse what visitors of an ASP (classic) site are looking for, the keywords for looking in the Access databasa, are written down in a textfile at the server. The textfile is in a folder with write permission. When the textfile is too large, I want to delete the content of it. When I...more >>

Is there a way of detecting when a person leaves the web page, so you can save some variables in a database or locally in a session variable? Thanks, Mike...more >>

Hi all, I have a ASP application using MDAC 2.52 and running on a NT4 server. The application connects easily to SQLServer2000 running on a w2k0 server. But it doesn't work on SQLServer2000 on a w2k3 server. - The error message is : "Microsoft OLE DB Provider for SQL Server error '800040...more >>