Test ...more >>

Hi, im running windows 2000 and sql server 2000 I have added a job to my database on a 5 minute run schedule. The TSQL statement you can find below DELETE FROM online WHERE (DATEDIFF(n, tid, GETDATE()) > 25) But it don´t fire at all. Any now why? Regards Mikael ...more >>

I am looking to do the following from a C# ASP.Net applicatio 1. Generate a DS from a SQL pull of a single table. Once I have pulled the data (Display to user is not required, just notification that the data has been gathered) 2. Convert the DS to a .CSV format and place the file in a directory w...more >>

Greetings, I have a question about a database query from an asp page. My query is functional and produces the data that I need; however, one column contains a numeric value that I need to translate to a name. For example, the number 1 needs to show up as "VZE" on the loaded web page. The seco...more >>

Trying to get the ID (autonumber) of a record that has just been inserted and insert it into a different table but I either get a syntax error or a data type mismatch. Ive tried switching the Sched_CustID field type to both number and text. I think it has to do with my quotes or double quotes on ...more >>

I have a time field in an access database and I want to be able to add 15 minutes to it. I can do this manually by taking the minute, adding 15 and then if it is over 60, changing the hour, but is there an easier way like with adding a day to a date by simply adding 1? Many thanks ...more >>

I am using MS SQL for my ASP application and have several 'comments' fields. Obviously in these fields users are going to enter invalid characters and when they try to submit they will receive an error message. How can I deal with these invalid characters so the information they are trying to sub...more >>

the application i'm working on stores user_ids as a session variable. many stored procedures throughout the application accept this user_id as a parameter. the problem is that often times a user's session will expire without them knowing it (like if they left their browser open for 2 hours wit...more >>

I have a question for you, it involves IIS and database connections. When I got hired, we were using an asp include file with database functions and would open and close the database connection multiple times in 1 script. Common sense dictated we should only open the connection once, get all...more >>

Dear all, I am working on a re-development project. The objective is to replace an old "system", which make use of local MS Excel, with a new web-based application. Platform: SQL2K, Windows Server 2K3, ASP.NET My users are damn familiar with MS Excel. They can work fine with huge spreads...more >>

I have an access table with fields including a Memo field. When I try to update that table using ASP page (using OLEDB for ODBC driver) the record after the update command is updated alright. But the memo field in the recordset after updation does not contain the value from the record just updat...more >>

My Authorware training piece sends user scores to a Microsoft Access database through an .asp page. In opening the connection to the database, I use this code: function OpenConn() strConn="Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & Server.MapPath(".") & "\open_database.mdb;" ...more >>

The application I have to maintain uses dynamical views. I have the following code: oOrgDbConn.BeginTrans DropStr = "DROP VIEW MV_22_" f.WriteLine Now() & " " & "trying to drop view " f.WriteLine Now() & " " & DropStr oOrgDbConn.execute DropStr, , adExecuteNoRecords + adCmdText ...more >>

Hi Guys If poss, could you please answer the following queries: 1) Is there any way in Access 2000 that I can get the DB schema out? Ideally its for point 2 below, but just so that I can print it out to see what I've created/structured would be nice. 2) I've been doing my new site with an...more >>

This is telephone directory that expands the display at each office to show the personnel under each office or section. Everytime this page is displayed it seems to reload itself completely and this takes alone time. I have been trying to find the code or method to fix this. I tried tellin...more >>

Hi, I'm gonna ask this in a different way to see if it gets a different response. I am building a page that queries two access tables. It is in fact two quiries in one as I want to do this. Tables consist of the following. Table 1: TeamID Team Table 2: PlayerID Player Team S...more >>

We just upgrade our oracle server from 8i up to 9i and now our asp pages are failing. We were using the Microsoft ODBC drivers for Oracle V 2.573.7926.00 to connect othe 8i server and it worked great. We are using an ADO connection on as ASP page to display data. This is the error we are get...more >>

We upgraded to IIS 6.0 along with Windows Server 2003 and all of our Access Databases are not working. I believe the connections are not working because you can open them in access. These are access XP. Any ideas, We upgraded from IIS 5.0 and 2000 Server...more >>

Hi Folks Actually I am new to ASP, I will be thankful so much if anyone could help I have an Access2000 Database, I have Listing.html that has links to several ASP Pages, I pass a variable to ASP, And according to variable value I open the database and get its value The problem is that so...more >>

Hi all I am receiving the following message in a routine which logs the transaction before registering a new user. It fails on the open instruction a.. Error Type: ADODB.Recordset (0x800A0BB9) Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another. /...more >>

or since RDS is considered obsolete by MSFT, is there another way? Seems RDS way is.. <OBJECT id=rds classid='xxxx'> </Object> <Table recordsource="#rds"> <TR> <TD><span datafld="id"></span></TD> <TD><input type=text datafld="FirstName"></TD> </TR> </TABLE> <Script VBsript> S...more >>

We just upgrade our oracle server from 8i up to 9i and now our asp pages are failing. We were using the Microsoft ODBC drivers for Oracle V 2.573.7926.00 to connect othe 8i server. At the beginning we were getting and odbc error when it was trying to connect in the script. After installing t...more >>

Hi All I'd just like to confirm something with you if you don't mind. Basically when my ASP page contains 3 or 4 queries, in my own little world I thought I was conserving resources by reusing the main ADODB objects of Connection, Command and Recordset rather than continually creating, drop...more >>

Maybe this is not the right group but maybe some of you had the same problem. When writting a asp with a table and 3 vertical cells, how to calculate the hight of the last writed cell. I need to know this to fill up the 2 and 3 row with info so that the 3 cells have almost the same content as ...more >>

I've never tried this before, and maybe it doesn't work. I'm building a very simple page for someone else's Web site. It's a sort of schedule, and consists of three tables, each of which has two columns. The columns either represent a person, or the date upon which an event occurs. The tables are tb...more >>

Can anyone help me with this dynamic table I'm trying to create. I will try and explain what I'm trying to do. It's basically a tree type thing which has it's data come from two tables. Table One (T-Area) has the following fields. AreaID area Table Two (T_section) has these fields....more >>

I have a text in access database, annd it is copied from Word. Problem is that when I want to put it on screen, usin response.write, all paragrafs and new rows in tex are deleted, so when I want text to go in new row, on place where I pressed Enter, text is displayed like there is no new row. ...more >>

How can I compact an access database on the webserver of my site using code in ASP page? ...more >>

HOw do I compact the access database on my web server using asp page? ...more >>

Hi Ng, i'm a nebie to ASP so please be kind ,-) I'd like to access (read and write data) from asp on (IIS if this Information is needed) MS SQLServer 2000 installed Databased. Let's say i've got a database called TESTDB with a table called TESTTABLE. A ASP File lying on Serverside. So c...more >>

HI There, I have a question regarding the global.asa file, I want to reference the ado "TypeLib" in my application, will this be included in all files & files located in sub directories of the application? also how can I tell what version of ADO is installed on the target server? Thanks in ...more >>

Hi All Just IYHO, which is better: METHOD 1 ========= Creating the ADODB connection obejct at the beginning of an ASP page in an include file. Functions containing the requirement to create any ADODB commands or recorset ojects to do a query and then close/drop the same objects in an i...more >>

In evaluating asp and an Access database as a way to store user data from an Authorware training piece, I ran across this article: "For performance and reliability reasons, it is strongly recommended that you use a client-server database engine for the deployment of data-driven web applic...more >>

My Authorware training piece sends and retrieves data through asp pages that are connected to an Access database. Three asp pages use SQL SELECT, INSERT and UPDATE statements. The data in each user record is small: about 25 two-digit numbers. The SQL queries fail when the Access databa...more >>

I have an ASP page that submits a form to a SQL database. There is a textarea that submits to an ntext field. When I output this to an ASP page using a Select statement it is all one string. Is there a way to make this appear exactly like the user enters it into the original text box? I have ...more >>

Need help on defining a SQL query statement. I have a field in my table defined as "Date/Time". This is in Access. The data looks like this in the field, "4/19/2004 8:59:17 AM" when entered. When I run the sql query statement with date and time like this, works well. SELECT * FROM [Florida...more >>

Hi To day I suddenly got the same error message when I connected to all my databases using ADODB.conection. "Application popup: ASP Script Error : Specified driver could not be loaded due to system error 5 (Microsoft Access Driver (*.mdb))." All the codes works fine on my mirror com...more >>

Hi, I am executing the sp_helplogins on my database, in an effort to obtain all the databases and roles a user has, for usage in an ASP menu of sorts. sp_helplogins returns 2 recordsets, the first of which I could care less about. The second contains all the records I want to parse th...more >>

How can I upload any image etc to server using ASP 3.0,Is there any object supported by ASP, Also How can i make autoresponder using ASP 3.0...more >>

Hi folks I am new to asp, but I have 2 pages, I submit a value in a textbox, press submit button to open the other page that searches an Access record and display its contents. I want to replace the button with a hyperlink, I did , but how to pass the 2 variables , or one variable Please if a...more >>

I have a website running on IIS 5.0. The users are authenticated using certificates mapped to their windows username. This si done behind the scenes so the user does not actually have to login. Is there anyway to get this username into a session variable? I am able to do if I create an actu...more >>

I have a query that I would like to search on where my field is a boolean. This is the error and the sql statment below, Error: No value given for one or more required parameters. SQL : SELECT * FROM [tablename] WHERE Red-Flag = True Appreciate any help on this, since I am new to SQL. ...more >>

I am developer for windows applications I have to use asp 3.0 visual studio have asp component wizard but I anderstude almost Nothing from generated code where from begin? I know using ado 7 ...more >>

SELECT MIN(StartTime) FROM tblLocationBookings HAVING (MIN(StartTime) > CONVERT(DATETIME, '4/20/2004 10:30:00 AM', 102)) I expect the above to return the next "Booking" after 10:30 am on 4/20/2004. It returns nothing There is data in the table; 4 of which are on 4/20/2004 w...more >>

Hi I'm querying a database and returning the records using absolute page and all that stuff. The user can choose to do a keyword search or display all records. the page is set up so that the sql statement gets passed back to the page using the querystring method. This works great when the ...more >>

It is now 3 months that we are trying to connect ASP.NET to a SQLServer located on another system However we act,we get a fatal error We need someone to explain the way of connecting to SQLServer step by step from either VisualStudio.NET or FrontPage 2003 Our goal is to retrieve records from SQLS...more >>

Hi I have some blind users who use voice translation software to enter data into an MSQL 2000 db using ASP (Web) Occasionally I get ' or other puctuation characters that fail the inserts or updates. I handle these using the replace function but some still get through !!! Is there a list of...more >>

i get this error when i am trying to close my object after this operation! What can be wrong? Regards Mikael Error Type: ADODB.Recordset (0x800A0E78) Operation is not allowed when the object is closed. My code <%@ Language=VBScript%> <!-- #include file ="./connectionStr\conStr.inc" -->...more >>

I'm working on a back end for an ecommerce system that has two tables that both need data in a one to one or more relationship. The product table must have at least one corresponding record in the package table, but could have more as some products some in several packages. Of course, each pac...more >>

i m trying to connect to msaccess database from an asp page in the same folder several days ago without any success,so any help would me much appreciated. I have windows 2000 and msaccess 2000 set conn= server.CreateObject("adodb.connection") conn.Open "PROVIDER=MICROSOFT.JET.OLEDB.4.0;DATA ...more >>