Mostlikely a very simple answer to this question. I am wanting to move to the last record in a recordset and extract a value from it. When i go move last and move previous i get an error saying catch fetch backwards. I augment my ignorance,..but here goes..how do i do this ?? ...more >>

I have an ASP page on which I allow the user to delete any off the displayed records. Since the source table is too large to list on one ASP page (25,000 rows) I break up the viewing into pages of 20 rows each with navigation buttons to allow the user to move forward and back. I limit the number ...more >>

OK, it's been a while since I've written a JOIN for Access ;) so could someone take a look at this and tell me what's wrong with it? All columns exist, and data types are correct... sqlQuery = "select trip.tripname,trip.trialhead,trip.startdate from trips trip inner join users usr on usr.use...more >>

Hi all Win 2k pro sql 2k dev ed asp - vbscript I have the following code (below) which is returning an error... if I change the commandtype to adcmdUnknown or adcmdtext then it works ok except for the fact I dont get a return value at all which is not what I want. I want a recordset and...more >>

Whatever you do, don't try aspwebhosting.com . One day I got an email from them saying that my account had been suspended for using too much cpu time. There was no further explanation. Those bastards took my site offline, removed my email account, blocked my ftp access and even refused to let...more >>

This happens a lot to my databases. I store them at the root of my developing files, i.e. c:\My Projects\Proj1\database.mdb. Randomly, the security settings on this database will drop to the basic secutiry, myself and SYSTEM. I need IUSR on it so I can access it through my ASP pages... I get err...more >>

Hi once again, I have been asked to add a feature that allows a person to add content to a site via a control panel. This control panel is basically a form that will have certain fields such as subject, body, date. The site is supposed to show the content that is supplied to it via the f...more >>

Using NT4.0 sp6, IIS4, Access2002 Mercy if this has been answered a hundred times. I've googled and I've found some information on aspfaq.com which pertained to Win2000, but the principles seemed the same. So far no solution. I use asp to search a database on my Web server. While I can connec...more >>

Does anyone can tell me what is wrong with my SQL server? My database field size is 3000 with nvarchar. I got an error Microsoft]{ODBC SQL server Driver} [SQL server] Cannot create a row of size 8087 which is greater than the allowable max of 8060. [Microsoft]{SQL Server} The statement h...more >>

I want to have a HTML form that the user fills in and clicks submit. I then want the data to be stored in an Access datatbase. I've loooked and looooked... but I can't find a simple script to do the above. I'm really new to ASP... so I don't have much clue what i should be doing. Any...more >>

Hello, I want to build a database with two tables, Characters and Abilities. So in the first table I would have: # Character Abilities 0 Fred Resistance, shield, firebreathing 1 Bob Climbing, swordfighting etc... and in the second table I would h...more >>

I have a web application in which I use a PDF form to collect data from the user and submit that data directly from the PDF to ASP. All pages of the application use the same ADO connection string, and most pages are able to access the database. One page cannot access the database. This ASP p...more >>

This is my first exposure to RDS Client side recordsets. I have a wrox professional Active Server Page book that is my bible. But i cannot get Asp page to show any data. The page is below.. It does not return an error, just an empty row.. After searching the web, I have read posts f...more >>

Hi All, When i am accessing a website i am getting this error Active Server Pages error 'ASP 0115' Unexpected error /hradmin/Default.asp A trappable error (C0000005) occurred in an external object. The script cannot continue running. Thank you, Lokesh....more >>

I'm trying to get some data out of SQLServer on our Webserver. It wasn't working so I built the database on my local machine. The code pages are on my C: drive and the virtual folders are in IIS running on my local machine. The following connection string works fine (TRHXP210 is my maching na...more >>

Hi, Does anybody know what this error is about? ____ Microsoft OLE DB Provider for ODBC Drivers error '80004005' [Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query. /app/admin/admin.asp, line 201 _____ many thanks! wilbert ...more >>

Hello everyone, I have one major table that contains some data and contain keys to many other tables. I am using RIGHT JOIN query method to get all my data and everything works very well. Now I am using the same query except i have a bunch of WHERE clauses in it to create a 'search engine', he...more >>

Hi All; I'm trying to create an ASP function called CleanX that removes the punctuation and some characters like (*&^%$#@!<>?"}|{..) from a text string I came up with this but It doesn't look like it's working. Can anyone help please. THANK YOU. Function CleanX(strString) ...more >>

Hi: Using MS Access in a server-side application (Win2k Adv. Server, IIS 6, ASP) we suddenly are getting the following error on most pages: Microsoft OLE DB Provider for ODBC Drivers error '80004005' [Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key...more >>

I have an ASP web application which ties into an access HelpDesk DB. The site includes use of the CDOSYS.dll (with updated code from the older CDONTS). Everything worked perfectly well on my XP Professional laptop. We upgraded a 2000 server machine to 2003 and experienced no problems with th...more >>

Hi, I made this code the retrive some info from my access DB, then choose another image from Products folder(images were not saved in DB) Everhthing is O.K., but when I changed the Image name from the drop down box the image became empty, and when I checked the image properties I found it looki...more >>

I;m trying to use an authorisation script in my page - the only problem is - only recently the "firewall" dialog box has popped up with a new "Domain" field - what do I enter into this? I've never seen this before or had it's function described to me. Thanks in appreciation (and a speedy reply...more >>

Hi All I've done an ASP which connects to an SQL DB. My problem is that I want to distribute this ASP page, but I can't do a straight DSN=MyDSN to point to the DSN, because I need to play with the Master DB first (to get a list of dbs) and then when this db choice is posted I use the actual...more >>

Hi guys, I've always used a connection like this: <% ' FileName="Connection_ado_conn_string.htm" ' Type="ADO" ' HTTP="true" ' Catalog="" ' Schema="" MM_name_STRING = "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=F:/webspace/db.mdb;UID=login;PWD=password" %> I noticed that I use the IU...more >>

The Database is Access 2000. The Statement when "Response.writing" it to the Browser (with example data)is: INSERT INTO tblEvents (fldDate, fldLocation, fldEvent, fldVehicleName, fldSignal, fldAzimuth, fldSuccessful, fldWeather, fldComments ) VALUES (#7/16/2003#, 'Decat...more >>

I'm trying to access an Oracle 9i database table and am having a difficult time finding how resolve the error. My error is as follows: --- Microsoft VBScript runtime error '800a01ad' ActiveX component can't create object: 'OracleInProcServer.XOraSession' /access_retrieve_data.asp, line 1...more >>