Hello, I have used SESSIONS on mission critical pages on my site, and if sessions are not enabled / supoorted - these pages will fail. When and why would a session fail? They do not store any info client side, and rely on the server to store session objects in memory, am I correct? Would sec...more >>

Am I doing something wrong? set conn = Server.CreateObject("ADODB.Connection") conn.open "Provider=SQLOLEDB; Data Source=P400; Initial Catalog=Database; User ID=Mantle; Password=4700" strSQL = "SELECT * FROM LoginIDPermissions WHERE (LoginID='thomas');" set recsetLoginIDPermissions = conn.exe...more >>

Hi We have a site with ms access backend, hosted remotely with a hosting company. Can we read the tables in the site database within our office desktop app either using web services or some other way? Are there any links to how this can be accomplished? Thanks Regards ...more >>

I am new to developing Webs that contain databases and want to get off to the right start. I am hoping someone will take some of their valuable time to answer. How much more difficult is it to "start" with SQL Server than Access? None of the Webs I design, at least until now, need any transa...more >>

My web app is undergoing the simple task of inserting the results of a form post into a database. Blank form fields are OK, but I want the database to have a null instead of an empty string. I'm a big fan of tidy code, so it bothers me that I need to use this longwinded IF statement in ASP to ...more >>

I am having problems putting text into fields when the text contains single or double quotes. Can I escape them or something?...more >>

I want to create a cookie that remembers the member's log in password and username. But i do not know how to set an expiry for the cookie. I understand that if I set to the one below, when the user closes and reopens the browser, he will still be logged in. But i wish to let the cookie expire once t...more >>

OK I know this NG is primarily for Access and SQL Server users, but the NG does signify asp and 'a' db. I've got MySQL 4 and MyOLEDB 3.0 installed and it seems to run OK with the test ASP page that I have just done. Before I go for hell for leather into my new shopping cart system, could you...more >>

How can my members log out of my shopping website? I can't seem to figure it out. I'm using a session cart where users can log in before shopping or log in upon checking out products. How do they log out??? I'm using ASP and oracle sql. Thanks *****************************************************...more >>

I am writing some code for a customer. The code integrates with his current SQL Server Database which resides on his server. We agreed that he will not pay me until the project is complete. Because I do not have a long history with this person I am somewhat uncomfortable just "handing over" th...more >>

When I try to Alter Column in Access Database, following error occured. Technical Information (for support personnel) a.. Error Type: Microsoft JET Database Engine (0x80040E09) Cannot modify the design of table 'tbl'. It is in a read-only database. /luq/createdb.asp, line 6 b...more >>

When using SQL commands in ASP, is there a need for using the "GO" command as is used in typical SQL scripts? ...more >>

I have a form on a webpage that someone enters a number (SponsorID). After then enter that SponsorID into the form, I need to somehow query my SQL database and find the record that has the same ID as the SponsorID entered into the form and return the SponsorName (and write it out on the page us...more >>

i am trying to host a data access page on iis 5.0 i am receiving an error message when i navigate to the pages that says, this page is hosted on an incorrectly configured webserver. i am at a loss as to what i am missing? i add mdac as the ms website instructs. i am pulling out the proveri...more >>

Hi, I've encountered a small, but in the end non fatal problem in my a response form I would greatly appreciate if someone could help me. Its a 2 page form with a 3rd form to check all the results. Data is transferred between the forms via hidden inputs. The check results is built into a...more >>

I have a question that bothers me from time to time and I"ve never been able to come up with an elegant solution... Here's a real simple example... Let's say I have a database with a field containing people's first names and I want to find out how many of each separate name there is. (How...more >>

Hi Can someone tell me if it is at all possible to create a web application using Microsoft Project. I want to create a web application that provides users with the possibility to view the gant charts and main details of the project file I would be really grateful to anyone that might be able t...more >>

This should be a really familiar question but i cant seem to find any similar related questions. I am in the midst of making a shopping website whereby customers can sign up to be a member and adminstrators can add products to the database. I'm using sql Oracle and i've created the tables and ins...more >>

I'm using the following code to insert a new record into an Oracle 8.1.7 database using the stored procedure below: set conn = Server.CreateObject("ADODB.Connection") conn.open connStr SQLString = "TABLENAME_INSERT_SP(COLID => TABLENAME_SEQ.NEXTVAL, COLNAME => '" & tmpName & "', COLSNAME => '...more >>

Hi all professor, I have a big problem in sqp with db programming, would you please help me, thanks first. I have 3 table, structure as following ================================= exhibition exhibition_id exhibition_name 1 toys show 2 ...more >>

Hello All I want to do some paging with a data set that I retrieve from the db. The data is about 500 records. I want to display about 25 records per page. The user would look at these records and make appropriate changes and proceed to the next page and see the next 25 records. If he wanted t...more >>

I am in the midst of creating a shopping website. However i'm stuck here. I can view my list of products and click to further go into an update form with previously entered details. But when i click "update", i always get this error below. Microsoft OLE DB Provider for ODBC Drivers error '80040e1...more >>

I am currently using 2 frames called "left" and "main". Right now i am having a user log-in table that is in the frame called "left". My code will then check if the user is valid. If it is, the successful log-in table will be shown in the same frame, "left" while if the log-in is unsuccessful, a reg...more >>

Hi, Could anyone help with this please, I on the verge of ripping my hair out. I'm trying to just add a new record into a database, a task that I thought may be relatively easy, doh! I'm using proper hosted webspace + asp etc is all installed on there servers, and I can send email from a...more >>

hi just for test, i wrote this asp code if i include the line of "activeConnection" i get the 800a01fb error : "exception" i reinstalled MDAC again and again i close all objects see the example ONLY open and close a connection connections seems be POOLED ok but executing the asp code sev...more >>

I am experiencing a problem writing to a memo field from my website. I am running windows 2003 server and access 2000. The problem I have seems to be when I call a page to write a large chunk of text to a memo field it seems to hang the server. I do not get any error mesages the page just ...more >>

What is the SQL used to clear the data from a table but not bother the table structure or design. While using and "import" feature I just need to clear the table of old data before importing a load of new data into it. -- Phillip Windell [MCP, MVP, CCNA] www.wandtv.com ...more >>

I'm trying to use a stored procedure to insert a new record into a table on an Oracle 8.1.7 database. My stored procedure is similar to: PROCEDURE DO_AN_INSERT_PROC IS COLX VARCHAR(50); COLY VARCHAR(50); COLZ VARCHAR(50); BEGIN INSERT INTO COLUMN_NAME (COLX,COLY,COLZ) ...more >>

Hi al How can I compare two database records such that the query returns the matched records and their percentages to which they are alike. ...more >>

Hi I am trying to make a simple connection in an asp page Dim DConnect Set DConnect = Server.CreateObject("ADODB.Connection") DConnect.Open "dsn=mydata;uid =xyz;pwd=xyz" DConnect.Close Set DConnect = nothing I am getting this error. Microsoft OLE DB Provider for ODBC Drivers (0x80004005) [...more >>

Hello All i have an XML string which I create in asp and send to a stored procedure. When I try to execute it for more than 20 records I get an error of data truncation. Cna anyone help the code is as follows strUpdtXML = Request.form("Message") - this is a valid XML string set Conn = s...more >>

I have a form that posts to a page with a SQL INSERT statement. I then want to automatucally redirect to a page with links on it. I need the entry variable, which is my primary key and an identity field to be passed to the third page. Can anyone help me with this? Thanks! Darren MCP ...more >>

Hello, Thank you in advance for taking the time to look at this for me. Problem I have a single table with multiple records group by PatientID. Each PatientID can have multiple records. I'm trying to setup a report, which will display if certain fields are NULL. I only want the field to ...more >>

I'm trying to write a SQL statement that selects records from a database and returns the record count using the COUNT keyword. I know I can use objRecordSet.RecordCount but I would prefer using the internal COUNT keyword for better performace. I have a database called users with 1 table named ...more >>

Hi all, My problem: When I use the following code, I get "unspecified error". And when I debug the code using "response.write", I get "ADODB.Recordset (0x800A0CC1)Item cannot be found in the collection corresponding to the requested name or ordinal." The code is simply trying to get a sing...more >>

Hello All, First of all apologies for the double post. I am posting through google and it can be confusing. My problem is this: I am trying to update a table using the connection string below. It doesn't work, I don't know why. I am able to write the values below to the screen and I a...more >>

If Request.Form("Submit") <> "" then set conn=Server.CreateObject("ADODB.Connection") conn.Open "PROVIDER=MDASQL;DRIVER={SQL SERVER}; SERVER=DUBLIN04;DATABASE=DUBLINTESTV4; UID=whoopwhoopthat's;PWD=thesoundofthepolice" (This line is unbroken in my page) ..CommandTimeout = 60 ..Ope...more >>

Hi I have a ASP page accessing a Oracle database and a SQL string that should return 1 line (record). I have tested my String in another program and I get what I am supposed but in my page a get an empty Recordset. I have been everywhere to find a solution to my problem and I can't fi...more >>

I have ASP web pages which were running on the NT IIS and querying access databases on 2 different PC's. I had to replace the PC and the new PC has windows xp. I have fought for the last week trying every combination of settings but cannot get anonymous access to work. The query's work fine f...more >>