Just upgraded to WinXP Pro to get IIS (5.1) functionality on my home computer for testing my own web applications. Handles ASP just fine until it gets to a conn.open statement, and then I get the HTTP 500.100 - Internal Server Error message. The detailed error message is: Error Type: Microsoft O...more >>

I am adapting a login script to suite my specific purposes by require guideance on best practice with regards the following: Should I be initiating the database connection in the global.asa or via the existing database include file I have at the moment.... My current database utitliy include...more >>

I created a new procedure in the query analzyer (sql server 8.0) It appeared to execute correctly on creation. However, upon trying to open it within the 'stored procedure' menu I get the following error: '//ERROR Error 0:[SQL-DMO]Object 'dbo.sp_adduser' was not scripted. It is possib...more >>

Hi Folks, I'm trying to delete 2 files using fso. The mail file name is stored in an access db. using the code below I can delete the main file but not the thumbnail. The thumbnail has the same file name plus the suffix "_small" so if the main file is called "mypicture.jpg" the thumbnail i...more >>

Would it be possible for me to simply paste this access query into a SQL Server stored procedure: SELECT asplGroupTbl.groupname, asplMemberTbl.userid FROM asplGroupTbl INNER JOIN asplMemberTbl ON asplGroupTbl.groupid = asplMemberTbl.groupid WHERE (((asplMemberTbl.userid)=5)); Is this okay?...more >>

Is it possilble or advisable to implement a double primary key on an sql server table to match an Access Table.... As I understand it, I could create a 2 "Int" datatypes on the two fields with "Primary" and Seed enabled.... Thanks Jason ...more >>

What would be the corresponding data types for the following existing Access data types: Autonumber = (UniqueIdentifier?) Number = (int?Numeric?) Yes/No = (?) Thanks...I am trying to convert an access table into an sql server table but this is my first attempt...sql server seems to have mu...more >>

Hi, I have two or more sql statements that depends on the other on the same page. For example I have strSQL3 and then strSQL4 will need the result from the dropdown of strSQL3 to start its sql. I actually need this to work on the same page with ASP. strSQL3 = "SELECT DISTINCT tblEV3L...more >>

Hi All I've seen quite a number of ASP sites that highlight certain keywords in a page and sometimes these words are links so that you can read the definition on them, eg ADSL is highlighted in a page of text and if you click on it then it takes you to a page explaining what this means. Not...more >>

What is the most efficient way to build an extract database? Specifically, I want to read, via ODBC, one non-MS-Access database table with dozens of fields and hundreds of rows and update an initialized MS-Access database table with only a couple of fields from all rows. Is there a more effi...more >>

Hi this question deals with displaying unqiue values in the drop down and not repeating items. Thanks...more >>

Hi, Lets say I connected to an Access database and created an sql and then created a drop down list. <% strSQL = "SELECT tblEV3Location.Division, tblEV3Location.Code FROM tblEV3Location ORDER BY tblEV3Location.Division;" set cars=adoCon.execute(strSQL) %> <select name="Divisio...more >>

Hi, Lets say I connected to an Access database and created an sql and then created a drop down list. <% strSQL = "SELECT tblEV3Location.Division, tblEV3Location.Code FROM tblEV3Location ORDER BY tblEV3Location.Division;" set cars=adoCon.execute(strSQL) %> <select name="Divisio...more >>

Does anyone have any examples on how to remove dupliate entries from a table? I have 1 temp table that holds about 300,000 records - about 110,000 of those are [at minimum] duplicates. The table layout is somethign like: pk email id 1 me@here.net 0001 2 you@there.com 0002 3 me@h...more >>

This subroutine is for an error logger, and I'm trying to check if a similar error already exists, only update a few things (time, number of occurrences). Unfortunately sometimes it works, sometimes it manages to delete the old error record and add a new one, even tho they're both the same erro...more >>

Hi Guys Wonder if you can help with my problem that seemed simple enough at first, but now appears to be a real pain. Basically I have created a few ASP web pages which have the following form fields on them: Net Amount (standard textbox) Tax Amount (standard textbox) Tax Rate (drop-dow...more >>

Is it tough to code ASP for a simple database results page? I've only ever used FrontPage wizards to create my database results ASP pages before, but I would like to (based on Ray's suggestion) try something bigger and better. Also are there any websites that offer a tutorial or somethin...more >>

Running asp pages against an Access 2k database. 2 questions for those vastly more knowledgeable than myself. - Are wildcards allowed in Access 2k SQL statements? If so, what are they, and what, if anything, do I need to be aware of programmatically in ASP? - Can I use the 'LIKE' key...more >>

Having re-jigged the UNIQUE to the proper syntax it does do what I want - wahey!! Just to finish this off here is my final table DDL: CREATE TABLE `WEBSTRINGS` ( `STRINGID` INT NOT NULL AUTO_INCREMENT, `TOKENID` INT DEFAULT 0, `LANGID` VARCHAR(30), `STRINGTEXT` VARCHAR(255), `P...more >>

Here's my tables: [ServiceCategory] [ServiceCatID] [int] IDENTITY (1, 1) NOT NULL (PRIMARY KEY) [ServiceCategory] [char] (50) NULL , [Services] [ServiceID] [int] IDENTITY (1, 1) NOT NULL (PRIMARY KEY) [ServiceCatID] [int] NULL , [ServiceName] [char] (100) NULL , [ServicePrice] ...more >>

Not too sure if this is the correct NG, but here goes.... I am in the process of creating a website (http://www.continental-translations.com - well someone is creating it for me) and I am hoping to put an interactive userform in the website. Basically I have an MS Access Database set up so t...more >>

I've originally posted this in the front page extensions page, but was told to stop by here. Here's a copy of what we said. Any ideas on how this is happening and if I can fix it? ---------------------- The limit isn't 10 people, it's 10 connections. Unfortunately, there isn't a 1-to...more >>

I'm baffled... I'm just trying to update data in an access db. All works well when I have text and memo fileds only. When I change one of the fileds to number, it bombs with 80020005 Data Type mismatch The 'stockStatus' filed is the one in question. Here's my code... 'UPDATE PROD...more >>

Please Help!!! I am trying to populate a dropdownlist from information in two other dropdropdownlists on my web page. Everything else works, but I keep getting this error - Incorrect syntax near the keyword 'INNER'. here is the code I am using in the selected index changed event of the 2...more >>

Hi All I know the subject of this post might seem a bit cryptic, but I wanted to get all of the keywords in. Basically I'm using a combo of a local array var and GetRows to get my recordset data and seems to work fine. The only problem I have is that I know the main benefit of this GetRow...more >>

Hi, I developed web application with ASP, it was running well before we changed to use new server. After we started using new server since last year, we always have this problem that we only can retrieve one data from database(SQL Server 7). For example: The data is suppose to be showm as when...more >>

I have a few questions about creating folders. 1.) using the CreateObject functions, since I use a server and not a local host, would I use my root path to my server them? 2.)Is it possible to have the folders created, based on a loop, that checks for say, the last number, and creates the new fo...more >>

I recently moved hosting companies, we went from a Windows 2000 = environment to a Windows 2003 environmennt. Since the move I have started to get timeout errors about once a day. I = maybe got an error like this once every 4 months before the move. Microsoft OLE DB Provider for SQL Server...more >>

My MS Access database use "link table" to connect the SQL Server by ODBC. But I failed to access the table which link to SQL Server with the following error in ASP. Microsoft JET Database Engine error '80004005' ODBC--connection to '[ConnectionString]' failed. /test.asp, line 21 My conn...more >>

Hi, My provider has provided me with an IP address and a DNS name to the SQL server I use. Whilst both obviously work does anyone know if there is any performance increase in using the IP address to avoid DN resolution? I imagine any performance will be negligible. ...more >>

In my mdb, the data is as below : ProductID Qty Name Month CID ------------------------------------------------------------------------ Product A 2 Harddisk July A-Company Product A 5 Harddisk July A-C...more >>

Our graphic designer is developing our new company website. We have switched providers and currently she is working on the new website which currently ressides on the new providers server as they support the ASP development environment. Their server is a Win2K3 server. She is writing an ASP mo...more >>

I know this may sound stupid, but when you use a disconnected recordset can you check for eof or bof, i assume you can just i get an error even when checking for this I just dim the RS but dont use set creatobject(recordset) i assume this bit isn't needed if you arent using a dsn. Then i us...more >>

After I run IIS lockown on windows 2000 standard with IIS 5.0. My website - built using FrontePage is getting the following error when accessing access databse Description: Syntax error in query. Incomplete query clause. Number: -2147217900 (0x80040E14) Source: Microsoft JET Database Engi...more >>

Hi there, I am storing asp code as content in a table field (MS SQL Server). When I try to display it via a HTML page only the HTML is interpreted, but not the asp code. What is the problem? Regards...more >>

Yesterday I wrote about an error I am getting on a ASP page using DSN people responded with some suggestions which I have tried and now I get the following error message : ( Microsoft JET Database Engine error '80040e69' Could not start session. /argusnet04/contractlist.asp, line 53 I al...more >>

Here's my WHERE clause on an SQL statement I wrote: WHERE blnLive = TRUE AND blnVacPromo = TRUE AND (dtToPost <= Now() AND dtToRemove > Now() ) What I'm wondering is how can I use parentheses (sp?) to invoke this order or precedence? 1.) Is blnLive equal to TRUE? 2.) Is blnVacPromo equ...more >>

Please could you tell me if it is safe to remove the dt_ stored procedures from my database? I have spent some time searching the web/groups for information but all I've found out is that they are created by Visual Studio and have something to do with source control. I'm not using Source S...more >>

Is there any way to group like objects, then count them in asp. I have a table with 60,000 + part numbers that I need a total of each one that is the same. For example. Table: 000000-cpq 000000-cpq 000000-cpq 000000-cpq 199888-001 199888-001 199888-001 244166-001 Results: 000000-...more >>

I would like to know how I can improve performance in inserting data from an XLS sheet into SQL using a Stored Proc. Steps: 1) Upload XLS file to server 2) SELECT sheet from XLS file and inserting it into an array 3) Do a FOR loop through the XLS import array and executes a parameterized c...more >>

Hi, I'd like to pull the results of a sproc within ASP as a text field, e.g. PRINT statements, "### Rows Affected", etc. How would I go about doing that? Regards, Scott...more >>

I am using Accss not SQL. ProductA sold 2 sets yesterday and 1 set today, Product B sold 3 sets yesterday and 2 sets today. By using "while not rs.eof" I can only show the records like that : ProductA 2 ProductA 1 ProductB 3 ProductB 2 How to sum the total amount and display to...more >>

Good day to you all I'm trying to see all the records in the database older than 2 years from today, and I can't seem to be getting it to go. SELECT * FROM comments WHERE (currentdate < 2002 - 07 - 20) ORDER BY currentdate I get null records returned, even though I can see some records ...more >>

I hope one of you SQL Guru's can assist me on this one. I want to create a report in my ASP app (SQL 2000 backend). This report will show the number of orders flagged as 'Complete', grouped by month. For example, If I 'run' the report, I should see: Jan 2003 : 37 Orders Feb 2003 : 43 Orders ...more >>

Does anyone know what this problem means??? Microsoft OLE DB Provider for ODBC Drivers error '80004005' [Microsoft][ODBC Microsoft Access Driver] Could not start session. /argusnet04/contractlist.asp, line 53 Line 53 refers to Conn.Open we have this exact same connection string ru...more >>

Hi, I want to add a row to library table. Table has total 7 fields. But I want to create the new row with 5 field data. When I run the following query in MS Access strQ = "INSERT into library (index,title,author,itemtype,createdate) VALUES ('B-096','Hihihihihi','hello','Book','07/18/04')" ...more >>

Hello there, Am I right in thinking all connections to a database have to be closed and objects set to nothing? I'm finishing up a web site in ASP someone else started and most pages have this type of code: ========= dim conn set conn = server.createobject("adodb.connection") conn.con...more >>

Ok. I have a kind of weird question, and I hope you all Understand it. Is there any program, or anyway, that You can edit an image, kind of on the fly on a website. For example, if I have a pic or avataar if you will, lets call it a template, and I want to edit that template and place a new me...more >>

Hi All I know an SQL Server timestamp seems to be as useful as rocking horse for show jumping, but I'm hoping you know a 'fudge' to get me round a problem or at least confirm that it isn't possible. I have 2 tables, one called ACCOUNTS and one called STOCK. These tables have the usual int...more >>

i set up IIS and made a test asp script, that worked. I am trying to get some database connectivity, but I'm just not getting it. I copied to code straight from MS's Help file. (and made a few changes) for some reason i keep getting the following error: HTTP 500.100 Error Type: ADODB.Records...more >>