Is there an alternative database format to MS Access or SQL? What other database formats are supported that do not require extra software (other than IIS)? ...more >>

Hi All First of all I want to thank you all for your time and patience this weekend. Much appreciated. Secondly, I'm stuck with the following: 1) Tab-delimited file consisting of 4 data columns (code, pic, productname, price) with variable record size. File size ranges from 2KB to about...more >>

Hello, I am using access database in aspx. I did something like this : .... currParam = new oleDbParameter("@create_date", OleDbType.DBTimeStamp) currParam.value = Now cmd.parameters.add(currParam) In the sql I wrote : insert into mytable ( ... , create_date , ....) va...more >>

Hi All Just trying to clear my cluttered mind and wondering if you can help. IYHO, if I have say 10 different product categories that extract their data from say 10 text files or an Access DB, is it more efficient to have an ASP for each product category to query each section or 1 which par...more >>

Hi All Due to using a combo of OLEDB/ADO/ASP and JavaScript I was having trouble reading in CSV data so I converted my client's web site to use tab-delimited instead. Better for me, but client is adamant that their site's recent timeout problems are since I converted to this tab format?? G...more >>

Thanks to a lot of excellent advice from this newsgroup I have managed to get a site working which is database driven. I would now like to know if it is possible to get information out of the database in a form such as an Excel spreadsheet or similar. What I would like users to be able to do is t...more >>

This is snipit of code, supplied by PayPal with explanation about what has to be done to access their back end. I am confused because they first speak of reading a POST then tell to use Request.Form to get variables from them. But then they say to add on "&cmd=_notify-validate". Am I wrong o...more >>

Got a very strange IIS 5.0 sp3 problem. Basically after a restart, everything works as expect. We have a very large report that will return enough data to the client that the IE process will increase to over 300 meg in memory. Again this is not a problem after the IIS server is restarte...more >>

I'm writing the simplest of search routines in ASP versus an Access database w. ADO. The application relies heavily on the database, my project includes a general purpose RecordSet.Open routine to handle queries. Basically, I pass a query to the routine, it opens a connection to the database, cre...more >>

Hi Guys I've been using text files for Tab-Delimited/ADO/ASP sites so that users can update and display their products lists through my system with relative ease. Only problem is that for the last few months or so, this system has been generating loads of timeouts. ISP has said that I shou...more >>

I am trying to collect information from a form on one page and then pass it to the page with the code below for processing. I can get the data to update when I use code as below. My problem comes that I want to use the data collected in my form in the UPDATE statement. Any assistance would be gr...more >>

Hi! I'm coming straight from php and mysql and I want to run this INSERT command from asp.net to mssql with ID as PK and auto incremented. ID PK int(4) name varchar(50) nummer int(4) When doing e.g.: INSERT INTO test (name,nummer) VALUES ('tom','2222') it doesnt work because ID ca...more >>

I have recently been brought on to a project that is integrating SQL Server 2000 as a new backend choice for an .asp application (now supporting both Access 2000 and SQL Server 2000). The primary developer OO'd the code to death and manages ADODB objects (i.e. connections, recordsets) thr...more >>

Is it possible to create a form on a page for updating a record in a database where the initial values in the form are taken from the database? If so how is it best done? Geoff Wickens ...more >>

I am trying to write an application that will include as one of its features the ability to track login times (entrance and exit). I think the whole exercise is rather trivial especially so if the user actually logs out. What I am not too sure how to go about handling is the situation that ...more >>

I now have to change my database from my MySQL to Access. Does it mean a lot? Do I have to do a lot? Can anyone throw light on this issue? thanks ...more >>

Hi, I'm creating a website based on one of those awful generator WSYWYG editors, A site in ASP and VBscript, Now i've created a page to post feed back to a table in my database, I created a Textarea for users to provide comments, but then when it came to defining what kind of field it is, al...more >>

Hi, I posted this two days ago at msde group but got no response. I installed msde 2000 on my W2k SP4 system but I can't see the tables and stored procedures from within Access db projects, and the stored procedures from VID 6.0 projects (here I see tables). I have installed and reinstalled MS...more >>

Hi, I get this error: Microsoft OLE DB Provider for ODBC Drivers error '80040e31' [Microsoft][ODBC SQL Server Driver]Timeout expired I use SQL7 and IIS 4 on NT 4. Where can I change this timeout value? Regards, Marcin ...more >>

I'm developing a system that is all database driven. The problem I find my self running into is that it will not be able to be indexed by search engines. I am aware of third party commercial products to make my dynamic pages static, but I thought of another solution. It is a content m...more >>

I inherited a small project tracking app, and after migrating the app to my machine, started receiving the following error message.... Error Type: Microsoft JET Database Engine (0x80004005) Operation must use an updateable query. /vzr/init_add.asp, line 115 Browser Type: Mozilla/4.0 ...more >>

Many thanks to all who have given so much advice already. This is much appreciated and I have now got my system sort of working. I am having more trouble with deleting a record from my database. I want to be able to select the event in a form and then collect this and use it in my delete state...more >>

this may be a stupid question but, I want to put my access Database online so users can look at the data and enter new data. Which would be better to use: Data Access pages or ASP.net. Also does anyone know where I could find information comparing these two. Thank you for your help, Jo...more >>

I'm having a problem getting one piece of code to work on my app. It's a simple password change. For some reason, I've been getting the following error: "Microsoft JET Database Engine error '80040e14' Syntax error in UPDATE statement. editPwd.asp, line 19 " Here's the pertinent cod...more >>

I have not been able to view any of my sites on my local machine. When trying to I simply get blank browser pages. I am using IIS5.1 on Windows XP Professional. When selecting Administrative Tools -> Internet Information Services I notice a red stop sign that says Error beside the icon for De...more >>

Hi all Win 2kpro, sql 2k, vbscrip asp iis 5 I'm currently doing something along the lines of: dim exists msExecutedSQL = "sp_memberexists '" & strName & "' " lOptions set rs = moConnection.execute (msExecutedSQL, ,lOptions) exists=false if not rs.eof then if rs(0) = 1 then e...more >>

I just tried to view a page that I had earlier on my own personal web site and was not able to view it. I then tried just plain old localhost and was again not be able to view anything. I then tried to stop and re-start IIS. When trying to restart IIS I received an error message reporting that ...more >>

Does anyone know what is the licensing fee for .NET software for non-profit organization ? I am trying to use ASP.net to develop a web site for my church, but don't know how to find out licensing fee for non-profit organization... thanks ...more >>

hi ... i am checking if the password is matching with either the student_table or the teacher_table then it shoudl display "welStudent.asp" page else it sould go to another page called "newstudent.asp". I have created 2 recodsets because i need 2 different queries to be executed using ...more >>

I have written the following query with a subquery to add a counter to be added to a drop down list, which works in SQL Server, but when I transfer the statement into my .aspx page it doesn't. I keep on getting the error : Line 1: Incorrect syntax near ','. The SQL statement is : if (S...more >>

This is just a warning for anyone thinking of hosting with http://aspwebserver.com these guys are a big fraud. after they get your money all you get server crashes on daily basis. none of their server can serve asp pages for more than 2 hours a day then it will crash and wait for them 24 hours t...more >>

Session("UID") = 10 Session("Name") = "John Doe" I have an ASP application loaded on a Win2k SP3 server in Anonymous Authentication Mode. When I try to access the site, none of the session variables work. I have to lower the security to Low in Internet Explorer for the session variables to ru...more >>

Hi, in the past I have used the file system to write a text file then set a link to downloaded By using Response.ContentType = "text/csv" I can create a csv and download it. However it wants to call itself the name of the asp page Is there anyway of controlling the name thanks jonatha...more >>

I'm developing a content management system to use for the web. I want to allow users to alter data, delete data, and add data for each individual user so that when a new user comes to the area, they will have a clean slate to start from opposed to seeing what the other users have done. I...more >>

I've imported some data from a mainframe db via text file. The file contains this: credit_hours pic 9(2)v9 (COBOL, it basically says 3 number fields with an implied decimal before the last number) For simplicity, I imported it as char(3) Now it shows up in SQL as: 050 Using the cas...more >>

Hi All, I am attempting to use a standard HTML form to pass a parameter to an ASP stored procedure, which searches a database for customer records. I include the stored procedure below, as well as the form code and ASP commands. Everything on it works fine, until a user puts several full stop...more >>

hi... i am creating a table : create table student_content (student_id varchar(10) references student_info (student_id), story_id numeric(4) references story_table(story_id), status_student varchar(5), story_original varchar(100), story_status_date date, story_word_count numeric(1...more >>

I always heard the term "data/database driven programming" model in ASP database, SQL programming, and web programming circles. But I don't quite sure what does it mean? Does it mean the web software's responds are based on data request from the user? Just like in Windows, we call it "event-driv...more >>

Hi, I have an asp page that uses ADO to send a query to an=20 sql server and puts the result data in a recordset. Then I=20 use: -- variable =3D result_recordset.getrows(number_of_rows) -- to put the result data in a variable, but in that line=20 sometimes I receive the error message...more >>

Hi All: I would like to have certain areas of a site that I am developing password protected but I am not sure how to go about doing this. I know that I definitely do not want to use Session variables (as the client may have cookies disabled). So the other option I guess is to have the userna...more >>

Greetings. I have a site with several pages that connect to a SQL 2000 database with a connection string stored in a session variable. After navigating through a number of pages with database access, there are a plethora of database connections left open on the server. This is an IIS 5 ...more >>

For some reason I am getting an error when trying to open a recordset on an Access database on my Win2K3 machine from my INDEX.ASP page, but the same code accesses the database fine when coming from the GLOBAL.ASA page. I'm using a DSN to connect to the database. The error I'm getting is: ...more >>

can anyone tell me what's wrong with this? searchSQL = "Select * FROM Events WHERE Date >=#" & DateBegin & "# AND Date <=#" & DateEnd & "# ORDER BY Date " & sort & ";" I have a form sending the correct data but I can't get this to recognize the 'Date<=' For example, when I do a search and a...more >>

Hi, I am sending an SQL Insert query to my ADO connection object, my Insert query looks a litte like this... INSERT INTO tblRequests (RequestedBy,ContactPerson,RequestReason) VALUES ('Test Person','Joe Bloggs','The main reason's are this...') Notice that the value of the RequestReaso...more >>

Hi folks, Here is what I am trying to achieve. I have a database with about 20 columns(fields), the first one being a unique ID. I am trying to get a page which will dispaly the fields in a specific format. So far I am able to do this to a certain extent. What I want to happen is that when I cl...more >>

In a web anabled program we want to read some info of a user. Therefore we wrote Private Sub ReadUser(ByVal Username As String) 'Step by step '1 De connector = MyConn '2 Make a SQL String (= SqlString) '3 Make a OleDbCommand ( cmdUsers = New OleDBCommand( Sql...more >>

Dear Friends, I'm working on a web besed project. In visual studio I have a solution and multiple web projects in this solution. How can I use the same session state(or cache) for all these projects. Thanks, Amir Davoodi. ...more >>

I want to add a "quick search" functionality in ASP or ASP.NET page. I heard we can use Microsoft Indexing Service to accomplish the task, but not sure how to do it. Is this the correct approach?? Please advice. Thanks, John ...more >>

Hello, I've seen this posting many times, but there are no responses to it... I hope it's not too difficult to fix. I have two databases, one primary one, and another one which contains a table that I need to use. So, I linked the table I need in the secondary db to the primary database. ...more >>

I Get following error:: ADODB.Recordset error '800a0e7d' The connection cannot be used to perform this operation. It is either closed or invalid in this context. /guestbook/guestbook.asp, line 7 I'm not really a ASP-programmer, so if anyone could it would much appreciated.. My Cod...more >>