Hello, I've been struggling with the syntax for adding new columns to an Access 2000 db table through an admin .asp page. I found lots of examples, but not 1 gives me the right combination. I am getting errors on everything I try. Some errors are syntax, some say there is an invalid or unqu...more >>

OK, I have a tool I've developed but now I have a challenge that I need to = overcome.=20 I want the desired query output: Home About Us History Founders Pictures Contact Form Services Inspection Approval=20 Residential Commercial =20 Category CategoryID - IDentity...more >>

Hello, I am working with ASP.NET, When i pating any Server side controls in my page, it is not visible in the run time, also server side scripts are not executing. What is the problem and how to solve it. whether it is IIS rights problem or ?. Give me a solution for it. Thanking yo...more >>

Hi and merry Christmas to everyone! I create a guid using the following code: accountguid = server.createobject ("scriptlet.typelib").guid and get it to response.write OK to the screen. However, when I try to write the accountguid to a sql table using the following: writeToTable = "INS...more >>

Hi All I know there are numerous postings on the web about this, but none of them seem definitive and they haven't resolved my issue. I'm running WinXP Professional and IIS v5.1 to create my ASP sites. JMail, ASPupload, ODBC, OLEDB all work fine, but I keep getting: ActiveX component ...more >>

I guess this is very common, but can't find it on the web: I would like to do site statistic and find out the visitor of our website: - ip address - the corresponding time - referal address Where can I download sample asp? Thanks ...more >>

I created a simple web-app for the company I work at. It consists of several 'queues' (new, pending, completed, etc...) each containing records which are customer cases. Each user should only be able to open a case that is not being viewed/worked by any other user. This is accomplished by...more >>

Hi The following error is generated when I run the code underneath. I am trying to write a guid from a session variable to a SQL table. I cant't see an 'unclosed quotation mark anywhere! Any ideas? Thanks! Phil ERROR: Microsoft OLE DB Provider for SQL Server error '80040e14' Unclo...more >>

Whenever I use the 'as' keyword in my sql statement I get this error Response object error 'ASP 0104 : 80070057' Operation not Allowed /amplifiers.asp, line 0 I can't find any information anywhere on this error. Basically I have 2 tables, a products table and an amplifier table that...more >>

Hi Why does the following line throw up an 80040e14 error? <%Set qry_items = Connect5.Execute("Select * from items_table WHERE fld_ownerGUID = " & Session("UserGUID")) %> I have a session variable (userGUID) that is set and is correct, and the ownerGUID field is a 'uniqueidentifier'. ...more >>

Hello, I have an asp application using 2 Access Databases (on the server) In order to join tables from 2 databases I have created a 3rd database as a “bridge” In this data base I have only views, through which I access the other databases. It is working fine, but I have found t...more >>

Dear All, I am working on a mdb database which is hosted by a company in the US. I enter the data here in hebrew but it shows up on the web apge like this????????. Is there a way that I can fix this and make sure all browsers will correctly show the hebrer chars? Raffi ...more >>

i am still at a loss from after all my time searching for a solution to this query (litteraly). Here are my tables featured_wine ============================= ID wine regionID countryID 1 thunderbird 1 1 featured_w...more >>

I have an ASP page that uses an MS-Access database. When I run it on my Web host's server the databases's ".LDB" file still exists after completion. I gather this happens when a connection is left open. I believe I am closing all my connections by using "Set objXXX = Nothing". Below is...more >>

Error Type: ADODB.Recordset (0x800A0CB3) Current Recordset does not support updating. This may be a limitation of the provider, or of the selected locktype. /asp_data3_add.asp, line 30 (line 30 read:s : rsAddComments.AddNew) <% 'Dimension variables Dim adoCon 'Holds th...more >>

hi, iis5, Access 2000 db I am writing some values from one field to a page using response write and a loop. Here's my code to do the write: <% Response.Write (rstRespond.Fields("eMail").Value & ";") rstRespond.MoveNext Loop %> This is successful, but it is returning the text...more >>

Do you want manage ASP Sessions variables without Session Object and without Cookie ? A free sample code (GNU license) http://www.prioregroup.com thanks. ...more >>

Apologies if this is in the wrong group, but I need some help. I have been developing with a DataGrid and OleDb and everything is fine, except that when I want to sort columns (which is fine ordinarily) it forgets the sorting information when I tell the grid that I want to edit. I am using ...more >>

Ok I need some help. Up until Tuesday my application was working fine. It is an asp.net application written in VB. It is very data heavy and makes multiple calls to a database. The application itself sits on an IIS6.0 server. And the database is on an SQL2000 server with SP 3a. On Tuesday we s...more >>

Is there an easy way to trim everything from the right side of a string after a certian point? Here's my string Product One: 1 Vial auto-shipped every 30 days and your 5th is FREE! I'd like to trim everything after the : - colon, but her's the catch... This is going to be a dynamic...more >>

Hi All, I know this error means the recordset is empty and I am trying to use it, but I am getting this error while checking .EOF. The following code works if .EOF is false If Request.ServerVariables("REQUEST_METHOD") = "POST" Then <<.....>> Else 'it's not a post so let the form load with th...more >>

Hi All I have a big problem, I am always getting an error message when I browse a ASP page I created with Dreamweaver MX, the page is supposed to use VBScript, the page consists of: <HTML> <HEAD/> <BODY> JON </BODY> </HTML> I have been told that this page should load. The error m...more >>

Hi I have been trying to post from a form to a SQL dab=tabase for a couple of hours. I've done it before, but i must be having memory problems. I have 2 files, one with a form, and one to do the INSERTing. These two files are below (only small as they are only test) - can you see what's...more >>

Hi all, I have a problem opening an Excel file in ASP with OLEDB. The opening can works for a lot of page calls but after an unspecified duration, it not work at all and give me the error for all page calls : Microsoft JET Database Engine error '80004005' Erreur non sp=E9cifi=E9e /Exce...more >>

Hi, I've a table like below :sno: :name: 123 abc 234 xyz 123 orp 984 wer 912 nbvm 912 iirrrr i want to find out how many sno are repeated and its values using query. please help DNK ...more >>

Is it possible to assign a value to a server varaiable? i have installed a program and i want to set a value to a new varaiable HTTP_NEWVARIABLE. How can i do this? Please Help. ...more >>

I need a free, ASP-Access discussion application.. Is there one available? Thanks ...more >>

Ok gang, I am going to try and explain my question. I have a page where a person's position is listed. This is what I am using to get that position. I first sort by the round field in the DB, then I display the table on the page. The problem I have is, if there are say 2 people with the same...more >>

Hi I,m new to Server 2003 and I'm moving an ASP website to it. This is what I have; an basic ASP web site that connects to a "SQL server 2000" database on Windows XP box, using IIS. Now I have moved the site to Server 2003, on IIS 6, but I'm still using "SQL Server 2000" However I can't ...more >>

Hi there I am using windows xp and SQL server 2000 as database and trying to run one application on localhost... I have got default.asp (which is basically login page) and then veripwd.asp and then redirects to index.asp on successfull login. On veripwd.asp, First I'm validating user login de...more >>

Hi, I am having ASP with the following code to access the file with windows scripting host. The page run on local server IIS 5.1 on Win XP Pro SP2. The IE never show me any error with this, but will keep access the page for very long. This code is running fine on other system. strFilePath =...more >>