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 >>