Hi, I am getting an error with the following code. Error is: ADODB.Connection error '800a0e78' - The operation requested by the application is not allowed if the object is closed. Any ideas how the error can be fixed? Extract of the ASP code below... <% dim dbprop, dbconn, dbsessionname ...more >>

Hi, I was wondering if it is valid to write code as follows: <%If Response.Write (l_IsChecked) Then %> document.frmMain.txt_CurrentOutlay.readOnly= "true" <%End If%> The idea is to use the value of the variable to make a text box read only. If the value is True then my intention is to...more >>

I have an Access 2000 database with tables linked from multiple Access databases. The set runs fine on my web service. That is, with all the database files present on the remote server the code on the remote server behaves. What I can't do is test locally. I've set up a virtual drive to a loca...more >>

I am still very new to ASP and am trying to create an ASP page that gets records randomly from a database. Right not I can successfully get one field of information at a time and randomize it, but I need the whole string. I've been searching the internet trying to find an answer to this quest...more >>

Hi again, another problem! I've moved from an Access database to SQL server and am now having trouble inserting dates and times into seperate fields. I'm using ASP and the code below to get the date and time, but my script is erroring. '-- Get login date and time cmdLoginDate = Date() cmdL...more >>

I am getting the following error: Error Type: Microsoft VBScript runtime (0x800A01A8) Object required: 'objReq.SelectSingleNode(...)' /soap.asp, line 10 I am using Windows XP with IIS installed. There is an ASP page sending a SOAP request to the following page. Here is the code receiving th...more >>

Can anyone point me to code examples or tutorials on importing Excel date into an Access database using ASP? Thanks! ...more >>

I've written an asp form that successfully takes a users firstname, surname, email address, username and password and then add's those details to an Access database. I've been trying to modify the code so that the script checks that the selected username doesn't already exist using the SQL IF ...more >>

Hi, I'm struggling a bit reading binary data from a database. Basically, I have a column in our table that has the binary type, and all I want to do is display that binary data in HEX. basically the table looks like this: binary_data binary(1024) binary_length int binary_length st...more >>

Hello, I use some sp:s in a ms sql, and so far it looks like (this works fine): ----------------------------------------------------- sql =3D "sp_NameOfSp @IDno =3D 1, @Name =3D 'Mikael'" (and 15 more = values...) cmd.CommandText =3D sql cmd.Execute -------------------------------------...more >>

Hi, I have an asp page where a check box is used. If the check box is checked then the value goes to an Access database as "on" while if the checkbox is unchecked before saving the asp page, the value of the checkbox that goes to the access database is "off". The datatype in Acess is on/off....more >>

I'm trying to create an ASP page that will randomly query the database and show entire entires. I found some code online that prints on entry from the table, but only one piece of information from it, and I'm hoping someone here know what I need to change to make it print the entire entry. ...more >>

How would you prevent duplicate entries in a column in SQL ? Imran ...more >>

Hello, I am testing a simple asp page. Here data is added to a database in People table. The primary key is Name (FirstName LastName). The data add part is working fine. However, after one data is added, I need to redirect the page back to the same record that was entered in the form. I am ...more >>

I'm new to this and am having a lot of trouble. I've been able to work my way through a couple of other bugs that have come up, but I just don't understand this one. I'm trying to run a very simple, small database for a project for a class. I've created my own web server on an XP Pro machine t...more >>

I am using an ASP page to access information in a SQL 2000 database. When I run the following query: ======================================================== Select Distinct [Judge Name], Caption, Avg ([Total Score] - ([Gross Score]/5)) As AvgDev, ABS(Avg ([Total Score] - ([Gross Score]/5))) A...more >>

Is there a better way to write the following statement? SELECT id, firstname, surname, age FROM sometable WHERE ( (id = 5058) OR (id = 1389) OR (id = 15075) OR (id = 1099) OR (id = 1299) OR (id = 1961) OR (id = 14733) OR (id = 1245) OR ...more >>

I have posted this to the asp.general group, but the answers given there have not addressed the problem, so I'll try here. Set up a W2003 machine at home. IIS is working. I placed an Intranet-based app that I wrote at work, onto this home machine. I rebuilt the SQL Server 2000 db exactly the s...more >>

Hi Gang I want to create a simple array that could have up to 100 - 200 rows and that always has 2 columns (and will have some number value in each column). I can't seem to figure out how to create the array initially, increase the row size 1 by 1 and populate the values of the array in a lo...more >>

Hi all. I'm looking for a tool which should act like some kind of middleware/ logical layer bewtween the SQL server and the webbased user interface. - It should be possible to easily create simple web forms (only data input and output) without programming effort by "clicking" the fields and...more >>

1. With Enterprise Manager what is required to have the script create the database, the SQL user and set their password? 2. Now that I have created the scripts, how do I execute them on a different SQL server and can it be done from ASP? ...more >>

I'm using JS getElementbyID to hide a particular table row by display = "none". Now, I need to know how to hide a column of a table that was generated by asp scripting. Me ...more >>

Howdy Experts! I have an ASP application (IIS 5.0 on Win XP Pro) that talks to an Access 2003 database via an ODBC DSN. The app works great in a hundred or more installations. However, I have one customer that when they try to write anything (it reads data just fine), the ASP page gives t...more >>

Hi, Tools --> Access2000db, win2k, asp So, I have a web form that captures 3 pieces of data: Course, SiteName, StartDate. Here's my code: ' Declare form variables to capture Dim varCourse, varSiteName, varStartDate varCourse = Request.Form(Trim("Course")) varSiteName = Request.Form("...more >>

Hi, I am testing a small asp page where addnew method is applied to add record to a table. However, I am getting the following error: Unspecified error /gwisbrandnewready4/test/REPLY.ASP, line 35 Line 35 is goes as follows: pRS.Open "People", myDSN,,adLockOptimistic,adCmdTable Any help i...more >>

Hi Gang I have IIS5 running on a Win 2000 server that hosts our asp applications. I'm creating a new application on this server but it needs to access an Access database on another Win 2003 server. In the asp how do I connect to the database on the remote server? Please help. Andy ...more >>

I am in the process of migrating from Access to MySQL I have already exported the data and the structure of the database and changed the connection string to: <% set Conn = server.CreateObject("ADODB.connection") Conn.open "driver={MySQL ODBC 3.51 Driver};server=mysql.domain.com;uid=user...more >>

Hello, I'm very, very new to ASP and am trying to run a travel and absence database for a small company on the internet. It will show as column headings 01 Tue, 02 Wed, 03 Thu..... etc for one month. Row headings will be the employee names and the cells will contain the locations where they...more >>

I have created a SQL database, a user to be used for communications in my ASP code, my tables, etc. Enterprise Manager gives me a way to create scripts of the structure. I don't really understand which scripts to create as their are numerous choices and it will take some more research but I ...more >>

Often when one registers on different web sites around the world, there is a pretty hard limitation on what characters I am allowed to use in my username and password. Why is that? What limitations should I put on my customers' usernames and passwords if I just want to store it in an SQL or Ac...more >>

I have a form which has 1 textbox in it. When the user enters a number, and tabs, it submits the form and the textbox disappears and the name of the person that the ID corresponds to is displayed (filters recordset, returns name). The problem I have is that this is the first textbox on the p...more >>

When connections are pooled in ASP to an SQL backend, is the connection to the SQL server considered to be one connection? Here's why I ask: The asp page I am working on will need to build a temporary table in the SQL database. If two people try to retrieve the same page at the same time, w...more >>

hi all, i am trying to connect to oracle thru an ASP page ... for this i write a code as below Set objConn = Server.CreateObject("ADODB.Connection") objConn.Open "dsn=OracleDSN;uid=userid;pwd=password;" after this i am trying to display the rows of a table in the database Th...more >>

Not sure how to do this but what Ive tried hasent worked. SQL = "SELECT ID,FirstName,LastName FROM MySchedule WHERE MyDate IS NOT NULL" Need to get all records that have a date in the MyDate field. What's wrong with this? Thanks! ...more >>

Can't seem to see what I'm doing wrong here.. I have attached the three files that I am using... When i run default.asp in ie, i get the message --------------------------------------------------- Microsoft JET Database Engine (0x80040E10) No value given for one or more required parameters...more >>

Hi Here is a mailing system to send html flyers via email; http://www.webwizguide.info/asp/sample_scripts/software_downloader.asp. Are there others around? Thanks Regards ...more >>

we are using ASP with Oracle 9i backend. we need to user procedures that can take up to 10-15 minutes to run (they been tuned, they are doing alot of work). Problem is that the page will either time out, or if we remove the time out they can't use it for the time is it possible to have ...more >>

Im pretty new to asp, but this just isn't right no matter what lang you use. I had a website that i was working on. hosted and designed on my laptop. (xp home w/ iis) This site was working perfectly when i left it. well not complete yet, but the major functionality was done, and there were...more >>

Hi all I are using IIS 5.0, Oracle 8.1. I am having problem with the following Insert Statement when used on Production Web server with SSL(https://...., Verisign). This doesn't occur everytime. Our studies shows that it is occurring approximately between1-2% of the total applicati...more >>

Hi everyone, I want to try and capture the amount of time a user spends on a particular page. I can figure out what time they first viewed a page, but is there a simple way to update an Access DB when the page closes or they navigate away from the page? Thanks in advance, Tom...more >>

Hi I am trying to develop a little site for myself an co-workers to enter our march madness bracket picks. With the tiny little bit of knowledge and some cutting and pasting I have created a mess that sort of works. I have a JS form that users can enter all of their own picks. However, when th...more >>

Hi, I was wondering if there is a way to get details about a current ODBC database connection. We have some pages that connect to a ODBC data source via a DSN name (ASP + VBScript) but need to know whether the database we are talking to is MSSQL, MySQL, Oracle etc.. In C++ I am using ...more >>

I am currently building a simple asp website for my college project. I have successfully completed the guestbook tutorial at http://www.asp101.com/samples/db_simple.asp (+ add, delete and update) I am looking for a simple ASP logon system which will ensure users only see their own personal d...more >>

I am trying to update an Access database using an ASP form with a date. All I return is a custom error telling me there is a syntax error with the field I am trying to pass. Help. ...more >>

Looking for a simple report solution using ASP and Access db. I want to allow the users to select table, fields to be in report. Then allow them to specify criteria for the query. Would output to simple table in browser - nothing fancy. Any free scripts for something like this? Could perhap...more >>

How can I display my db results in a multi-column table? Need to build a formatted mailing label print page. I need to display a 3 column table and also have a page break after every 10 rows. How can I do this? TIA! ...more >>

Guys, I tried to google this up but couldn't find anything related to classic ASP. How do I upload files into a SQL Server table? I need to upload a pdf related to each record in the table and display the pdf every time a link is clicked. I'm aware of potential drawbacks of doing this, but o...more >>

Hi, Does anyone know of a good sql server asp vbscript search script? I am looking to have multiple word searched with results ordered by relevance etc. Thanks...more >>

Hi All: I have an ASP page accesing an access 2000 database, which contains a couple of date columns, which I have trouble updating when an empty value is entered.. bits of my code (simplifed here for clarity): (DB Connection "Conn" previously established) (results coming from a form) ...more >>

Hi, I can successfully connect to a database located in the same server. I am using the following code to connect to a database located in the same directory as the web application, gwis. myDSN="DRIVER={Microsoft Access Driver (*.mdb)}; " & _ "DBQ=" & Server.MapPath("/gwis/GMISDATA.mdb"...more >>