Hello; I know how to get a "Database Table" with ASP. But what I am trying to get is the Table Column. This is what I am needing. ( Could someone please point me to some information on how to accomplish this please? ) I need to show the Current Users name's that are logged on.? I h...more >>

I recently installed Windows XP Media Center edition included built in IIS5.1, VS6.0 with SP5, VS.NET 2003 into my computer. I loaded a Visual InterDev 6.0 project and set break proint. When running it, never stoped at the break points. I tried anoher way by menu Debug and Step Into. It ...more >>

Thanks for the tips Ray! Okay I think I can explain better now. What my asp page displays are some records from a database table and a text box after each record where a user can enter a date. I would like to be able to check if a date is entered and if so, send that line of information to a ne...more >>

My big problem is I'm a newbie working with someone else's code.(See code below) What I want to do is for the records that have a purchase order number I want a text box at the end of the line of information that a user may or may not place a date into. (You'll notice that there are two sets bei...more >>

I have been getting some rather confusing access errors when trying to use an asp page to access my Access database. I have all the security settings on the db directory allowed so that is not the problem I am having. I had also gotten similar errors when I was trygin to access the db while it ...more >>

Can anyone tell me the appropriate permissions to set on a database file so that the web user can read and write, but the file does not try to download if you type in the path to the file. Thanks a lot!...more >>

Hi I am using the following page to display my data when it is entered into an access database. It is working great the only problem is now that I have the <table> in there it adds the new record in the middle of the table not on the end.(only in display, It is at the end of the access database)...more >>

I'm selecting fields from my main table (ProductData). Each record in that table has a SupplierIndex. There is a field called SubCategory, which looks up from tblSubCatList.iSubCatID but which is not necessarily populated. My SQL statement is as follows: SELECT ProductData.DacNumber, Produc...more >>

for running asp code at the server i use the <script language="vbscript" runat="server"> so after that, for database access do you need to specify additionally set rs = server.createobject("adodb.recordset") or can you just use set rs = createobject("adodb.recordset") does it matter?? i a...more >>

Hi All: I am trying to populate a database field that consists of incremented (serial) numbers. This is the code I am trying to get to work: objRs.AddNew for i = 49999 to 50999 n2 = i + 1 response.write "n2=" & n2 & "<br>" next for n = 0 to 1000 objRs("bcksNo") = n2 next objR...more >>

Having some problems with my SQL statement syntax: Microsoft JET Database Engine (0x80040E14) Syntax error (missing operator) in query expression 'MealsExCode=0000104Amount=23.56'. Can anyone tell me what I might be doing wrong. Help apprecaited. Thanks: SQLstmt = "UPDATE Expense SET " ...more >>

I have just brought up a web site using an MDB file on a Win 2003 system and I am getting the message: HTTP 500 - Internal server error Internet Explorer I know it's the access data base giving me the problem as I will wait a while and then try the page again and the information displays...more >>

I am testing ASP application (VBScript) on a Windows 98SE system with PWS. I used to be able to run the application - which requires connection to a database - but now I am getting this error: ============================================================== Server object error 'ASP 0196 : 800...more >>

I have pg1 sending 6 vars to page2. Page2 uses the 6 vars to pull from an access database the fields of a specific tbl. under the sql stmt a function displays the records with headers, which will be sortable and pgable. Problem is this. - The initial load is fine with sortable hdrs a...more >>

I am new to ASP and would like to write a page with a drop down listbox on the top of the page. As soon as user choose a value in the dropdown, the resulting records based on the chosen value will display below the dropdown. How do I do this without reloading a new page with the results ...more >>

Please help.....! I have built a site that works/worked absolutely fine on my test server. When I transferred it to a remote web host (the intended permanent home of the site) something very worrying keeps happening to my site. I use, as is the norm, session variables to store login informat...more >>

I've built a table where each record relates to a meeting. Meetings may be independent or may be linked indicating that they occur sequentially. I have a field in the record which allows me to record the record number of the meeting the current record follows, if the meetings are linked. I want t...more >>

Hello all... I'm using asp to get records from an access database, very similar to the way datagrid would work. The title of each column in my table is a link that alternates the sort order between ascending and descending... my problem is that text WILL change its sort order just fine but nube...more >>

I'm trying to install a freebie app downloaded from the web. Its based on an Access Db, and I'm getting the a missing operator error for the following SQL: SELECT COUNT(DatabaseUsers.database_id) As Total FROM Users INNER JOIN DatabaseUsers ON Users.username = DatabaseUsers.user_id INNER JOI...more >>

Hi, I am in the middle of setting up a new IIS Server to run our intranet on and was wondering if all you gurus out there had an idea of the perfect IIS setup and the things that should be installed on it! Especially when it comes to security, and functionality... Has anyone had any b...more >>

Hi, Could somebody please tell me, or point me to an article, that shows me how to pick up an ANSI standard date directly from asp (VB Script) code. The now() function seems to pick up the date with the default settings of the server. ie if the date format is dd/mm/yyyy it will pick up 090...more >>

I need some guidance in how to control dates with regards price reductions in my product list inside an Access 2000 database. For instance: 1. I will start off with an ORIGINAL PRICE where I must record the data capturers INSERTION date 2. At some point there may be a REDUCTION IN PRICE. ...more >>

Hi, I am having trouble making an encryped connection to an sql server over the internet, and would really appreciate some help. I have tried to include as much info as possible without making this post too long. I am trying to connect to an SQL SERVER (ent edition on Win2k Server) Bo...more >>

I'm importing thousands of rows into a sql server table using ASP on a hosted machine.. I've got Server.ScriptTimeout set to 150000. For some reason it quits at a 1000 rows or so.. is it possible that my web host has set a script timeout on the server side that is overriding my script settings...more >>

hi, I made a asp form (in mm dreamweaver) to insert product in a db. on my localhost everything works just fine. But online i got the : Microsoft OLE DB Provider for ODBC Drivers error '80004005' [Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query. the line...more >>

I am trying to pull a record into a form and then edit it. (not working to well) Hoping someone can show me a better way than this: <% option Explicit Dim adoCon Dim rsedit Dim strSQL Dim lngRecordNo lngRecordNo = CLng(Request.QueryString("ID")) Set adoCon = ...more >>

I am connecting to an SQL 2000 database with OLE. My connection is fine and records are returned, but certain field names seem to cause empty or undefined records to return. If I then move the recordset request that returned undefined to a different position, it will return a value, ...more >>

I'm trying to connect with an Access database with this snip from a sample application originally designed for SQL Server. There is an include file for the ADO connection statements. Can anyone tell me why I might be getting this error? Help appreciated. Thanks. Frank Error Type: ADODB.Record...more >>

I have a MS Access database. Within this database, I have several linked tables that connect to a mainframe's database. The linked tables use a DSN to connect to the mainframe. I want to open the Access database and query the linked tables from an ASP page. However, the DSN that the li...more >>

Hi, Using the following records : PF03001 PF03002 PF03003 PF03004 PFR03001 PFR03002 PFR03003 PFR03004 How can I extract only the PF records (and not the PFR ones) using the LIKE statement ? My first idea was to search for PF and verify that the following char is a numeric one : "se...more >>

I have written a simple web app that connects to a local instance of SQL Server to run queries. The virtual directory in IIS is "myapp", and there is a default.asp file in there. In myapp properties/ directory security/ authentication, I have disabled "basic authentication" and "integrated windo...more >>

Hello I am getting the following error message: Microsoft VBScript runtime (0x800A01A8) Object required: '''' /delete_entry.asp, line 17 When I try to delete a record. The following is the code to the delete_entry.asp page. <% Dim adoCon Dim rsDeleteEntry Dim strSQL Dim IngRecordNo IngR...more >>

We are experiencing errors like the following approximately 50 times per day appearing in our logs. [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied We are currently running Windows 2000 Server SP3+, SQL 2K SP3, MDAC 2.71, .NET Framework 1.0 SP2. We run the...more >>