What is the UUID associated with ADO 2.8? The most current one I've found for use with ASP is: <!--METADATA TYPE="typelib" UUID="EF53050B-882E-4776-B643-EDA472E8E3F2" NAME="Microsoft ActiveX Data Objects 2.7 Library" --> I'm moving some stuff over to a Windows 2003 server and figured I'd u...more >>

I need to store 3 strings and be able to decrypt them. Does anyone have a link to a E/D routine they can pass on Don. ...more >>

Person asks: I've been coding up a storm for a project the last couple weeks and have been looking for unrelated information - when I discovered that the folks at www.aspfaq.com recommend against using the command object to do stored procedures. No 'meat and potatoes' explanation is given oth...more >>

I am trying to connect to my oracle data base with my asp page, but it keeps giving an error message "Microsoft OLE DB Provider for ODBC Drivers (0x80004005) Specified driver could not be loaded due to system error 5". I even went to the registry to grant full permission to all users, bu...more >>

Hi i need help with this code. Set conn1=Server.CreateObject("ADODB.Connection") conn1.ConnectionString="Provider=SQLOLEDB; Data Source=ASF_SQL; Initial Catalog=play4; User ID=viktors; Password=viktor" Set rsEmps=Server.CreateObject("ADODB.Recordset") strSQL="select p21_view_oe_hdr.orde...more >>

I'm trying to install a free bulletin board software on my web server that uses MS Access. I'm only familiar with ASP/SQL, but not ASP/Access. Do I need to install Access on my web server? Or will it be able to talk to the database through ADO directly? The software comes with an mdb database fil...more >>

I have created a database in access This is what i am trying to accomplish 1. to get rid of an ability to change design, data. how can i prevent people from having the ability. Yes, data will be shared with about 10 users. 2. when i enter data, if i roll with my mouse up and down with a mo...more >>

Using MsSqlSrv 2k in an asp environment,. I need to check a coloum in one table and update another coloum in another table every three hours. Can some one point me how to do this in an automated fashion in mssql2k Don ...more >>

Hello! I have a SELECT comand passed trhough ASP like This: SELECT PK_A_MSGID, C3_MSG, C3_MSGPT, C3_MSGEN FROM S_MSGS WHERE C3_MSG LIKE ""%Efectuar%"" ORDER BY PK_A_MSGID and when i pass it it gives me: SELECT PK_A_MSGID, C3_MSG, C3_MSGPT, C3_MSGEN FROM S_MSGS WHERE C3_MSG LIKE "ïectuar"...more >>

I have been given the task of adding a component to a control panel that will act as a miniature html editor. I would like to know how to determine the position of the cursor at any point within a textarea that I will be using to capture the users html data. The other thing I would like to do is...more >>

Are there any tools which can be used to test ASP applications (especially those applications that interact with a database like SQL Server 7) to find out to what extent the application is effecient? Thanks, Arpan ...more >>

Hi, I have created a website on IIS that access a backend sql 2000 db which is located on a seperate server to the iis instance. IIS wise have have turned of anonymous access and set up the ntfs permissions that are required. I have tested the access to content and this is working correctl...more >>

Hi, I'm not real experienced with this and I can't figure out why this isn't working. I get results in the query analyzer with "exec sp_Orders_SELECT @Exported='err'" but nothing when connecting via ASP. I don't even get a record count. response.write(rsOrdersSelect.RecordCount) doesn't di...more >>

Microsoft Client this is the latest version of security update, the "October 2003, Cumulative Patch" update which fixes all known security vulnerabilities affecting MS Internet Explorer, MS Outlook and MS Outlook Express. Install now to protect your computer. This update includes the functio...more >>

I am running IIS locally on my machine. Everytime I try to access a page that has a database connection it does not work. I have the dsn created and checked the connection and the connection is fine. Here is the error message im getting: Microsoft OLE DB Provider for ODBC Drivers error '80...more >>

hello any ideas what is wrong with UPDATE statement.... my brain is stuck.... ***************************************** Error Type: Microsoft JET Database Engine (0x80040E14) Syntax error in UPDATE statement. /asplogin/xp/actions.asp, line 70 ****************************************** ac...more >>

Is it enough to simply use the replace function to convert single quotes into two single quotes while allowing users to insert data into a SQL statement? Like so- "SELECT whatever FROM table WHERE whatever = '" & replace(request("input"), "'", "''" ) Thanks ...more >>

Hi! When a user enter my page, a cookie is created. When the user leaves the page (closeing the page), the cookie needs to be deleted. How can I call an ASP-script when the user close/exit the page?? Best regards, Øyvind Isaksen ...more >>

Hi Everyone, I'm working on a web project that will potentially have many thousands of users hit IIS during the course of any given day. So, with that, I've decided to do some research before getting into any of the hard-core code. I hope some of you will be able to lend some insight. Envir...more >>

Dear friends, I found this hosting company which I think is extremely good and want to introduce to you. Only $4.95 per month and you can have ASP, PERL, CGI and stuff. Even database with Access is INCLUDED!! Best for small to medium size website which needs some interaction with users and...more >>

hi everybody! I have a few thoughts about file uploading/downloading, through the browser. Heres what i want to do: When i click on the "upload file" in my website i want to be able to choose a file and upload it straight away into the 'Files' table in my database. when i click "Download file...more >>

I have a page that adds a new user to a db when they sign up. This creates a new autonumbered entry in the db. I then want to use this number as a session object. How can I retrive this number at the point of creation? Thanks. ...more >>

When I run the following connection code in classic ASP on a machine without the NET SDK installed it works perfectly and has done for some time. When I run it on a computer with the Net SDK installed it fails with the message given below. The code is: dim strconnect strconnect="Provi...more >>

I tried to modify the field in my ASP page, and it yields the following error: I tried to use adLockOptimistic as follows, but still not working objRS.Open "pressrelease", objConn, adOpenDynamic, adLockOptimistic ADODB.Field error '800a0cb3' Current Recordset does not support updating. Thi...more >>

Hi, So far I have been writing ASP and embedding my SQL in the ASP pages. But, I've heard advantages of creating queries inside the database program. So I'm wondering if someone can give me an example of how to create queries inside MS Access and then call them in an ASP page. (or point me to ...more >>

Hello, I am stuck with EOF TRUE error and not quite sure what I did wrong: Here is code: **************************************************************************** **** <%Response.Buffer=TRUE%> <%IF session("admin") = FALSE THEN Response.Redirect "admin.asp"%> <% tbl = Request.QueryStri...more >>

Hello All, I'm having a problem saving/displaying multiple lanaguages on an ASP page. Here's the general problem I'm having. I have an admin area of a website that allows a user to enter items in multiple languages. EX: NAME LANGUAGE Trade Show English...more >>

I'm having difficulty posting a timestamp to access from client-side javascript using New Date(). The result gives a syntax error on my INSERT INTO command on the ASP. If I take the Date Data out, all other data gets through just fine. Here's my code: JAVASCRIPT document.repForm.Timestamp...more >>

Hi Guys I know I've moaned about this recently, but all I want is a copy and paste example of the following: MyVar = OLEDB connection to an Access DB with a database password Can you help?? A helpful poster told me that my connection attempt was OK, but my params further down the line ...more >>

In my project I am uploading file using File control. After browsing file user needs to select other values from DropdownList to determine uploading path. After selection in couple of drop down lists page needs to postback. The problem is File input field becomes clear after posting pack of the...more >>

Hi, I have a dataset where each record contains a persons name and filename of their picture. I want to write a row of five names, then a row containing there pictures, then a blank row, and then the next five names, etc. Kinda like this: Row 1 Name1 Name2 Name3 Name4 Name5 Row 2 Pic 1 Pic 2 ...more >>

Is anyone know how I can store Word Docs and PDF's in database, and how I can make link for visitor to download these files ...more >>

I am reusing a code that has been already working fine in another part of our website. I am using the same table structure and datatypes too. I am getting the following error message: Microsoft JET Database Engine error '80040e14' Syntax error (missing operator) in query expression 'CustomerI...more >>

I know (now) that using ADO recordsets for updates is a bad idea, and I now longer use them for new pages we create; howevre, I just have a question for one of the MS gurus here. Several people here have mentioned that if you use an ADO recordset for updates, the OLEDB driver converts th...more >>

I've searched through google groups and cannot find an answer to this: My application passes values from a form to a page that requests them and sets them as parameters which are then passed to the SP. The SP then updates a table with these values. The problem is that not all of the values nee...more >>

Can someone please tell me why I keep getting the following error? I think it is part of the connection but can't pin down the exact error. I would be grateful if someone might have any ideas. Error Type: Microsoft OLE DB Provider for ODBC Drivers (0x80040E37) [Microsoft][ODBC SQL Server ...more >>

Does anyone have any recommendations for an affordable ASP/SQL Server host which allows you to use the Agent to schedule jobs, configure and create you own backups, with the Agent always running. My current host doesn't allow you to create your own backups, you have to submit a request....more >>

I don't know whether I've categorized this question correctly. My users are required to use sombody else's web site to send data to their web site's database. We also need to track the same data locally in our database (MSAccess converting to SQL Server 2000). The data creates a new record...more >>

I have a Access database residing on our 'out-of- house, .com,shared' server. I have an asp page on the .com website that writes to this db, creating records. I would like to have a 2nd database, residing on our IN-HOUSE Intranet server, that copies records off of the .com website's db st...more >>

Dear all, Hopefully there´s someone who can help me. I´m looking for an ASP/Javascript possibility to grab content from another website and store into my website database. I would like to grab some temperature and snow information and use this actual information on my own site. Thanks f...more >>

Hi, I am Tring to send a decimal to a SQL stored Procedure and get a The precision is invalid. The Fields are set for 4 precision 2 scale decimal @HOURHoliday [decimal](4,2), @HOURSOT [decimal](4,2), @HOURSREG [decimal](4,2), @HOURSVAC [decimal](4...more >>

I'm abandoning my prevoius attempt at a salesforce automation (think lite verions of Salesforce.com or ACT! for the web) application and looking for either canned .ASP code or some simple guidance on building one. The pages I built are working for creating accounts, but I can't figure out how to ...more >>

My site has just started crashing the server. They said that every time my site ran it crashed the server requiring it to be reset. Because this is disrupting other accounts mine has been suspended. Please help... Below is the last log before the site crashed. 2003-10-06 09:27:30 64.62.15...more >>

Jet SQL doesn't support any kind of rename statements directly. I figured this can probably be handled through ASP but I'm not sure how to go about it. Any help would be appreciated...thanks....more >>

I created a database for my web server where the Administrator is able to add new entries through the web. The main page is fine, but when I clicked on the Database Editor, I get this message, "Database Results Error [Microsoft][ODBC Microsoft Access Driver]General error Unable to open regi...more >>