Win2k3 IIS Server MSA 2003 I have an asp page that runs a query. The query would take < 2 seconds to run from the web page. Now it takes 52 seconds to run from the web page, but < 2 seconds when run inside of MSAccess. SELECT TOP 1 ZIP_CODES.ZIP FROM ZIP_CODES ORDER BY Abs([zipval]-...more >>

Hi, I am testing a asp page where I am trying to run a access update query from a asp page using the command object. However, it gives the error as following. I have no idea why the error is coming. Any help is appreciated. Thanks. Regards. ERROR MESSAGE: ADODB.Command (0x800A0BB9) Argum...more >>

Short version: ODBC configuration for the Oracle ODBC driver includes a checkbox for "Enable closing cursors". Does anyone know how to get the equivalent behavior with the Oracle OLEDB Provider? Long version: We have an application that manages web-based training. One of the functions ...more >>

Hi, I got a asp page where I need insert record to a access table. However, after running the page the following error is coming: Error Type: ADODB.Command (0x800A0E7C) Parameter object is improperly defined. Inconsistent or incomplete information was provided. /gwisbrandnewready8/test2/A...more >>

Hello All, I am having a very odd problem. With a database I recently created on = MSSQL 2K (Win2K Server Machine), I use a Stored Procedure to handle = getting the fields I need. If I use MS Access to open the Stored Procedure (in an ADP File) it works = 100%, same goes through Enterprise...more >>

I've set up a basic page to list the contents of an access database, which happens to be a list of names - the strange problem i have is that, although it lists the contents in order of ID number - it begins the list from half way down - for instance - beginning at O'brian rather than Adams - alt...more >>

I have this ASP page that inserts new records into an Access database via an execute statement. Taking the data from a form, I build my SQL statement like this: <% strSQL = "INSERT INTO mytable (Firstname, Lastname, Department, Extension) _ & " VALUES ('" & CStr(Replace(Request.Form(...more >>

Machine is W2K, using IIS 5, and FP 2000. I have a small site with 8 ASP pages. The home page opens fine, but the ASP's just lock up and won't open. I have checked Tools>Datbase and Verify, all my permissions, directory settings and the extensions, all come back OK. Any ideas would greatly b...more >>

I have an ASP form with the following textboxes, RegNo - Primary Key EventDate - Date of Event EventTime - Time of Event EventCatID - Category of Event How can I insert the date and time together, instead of using 2 datetime fields? Thanks, Drew Laing ...more >>

hi Can u tell me how to insert data from .sql files to oracle9i database table using jsp technology. I need it very urgently. and should be done with dsn less connections. Cheers Poonam *** Sent via Developersdex http://www.developersdex.com ***...more >>

Hi All: The following was posted to microft.public.scripting.vbscript but nobody replied there, so here goes: How come that <% tt = 3 response.write tt & "<br>" response.write FormatNumber(tt,2) %> returns: 3 3.00 but <% response.write FormatNumber(RS(0),2) %> return...more >>

I am using access DB. i have a large table that i have aquired, and all the data in the fields are actually txt. unfortunatly, the data is integers stored as txt. the future plan, is to redo the DB, and make the fields numeric, but for now, i need a way to retrieve data, and change it to nume...more >>

Hello all: Although the following question is not related to a MS flavor database, it IS related to MS flavored technologies / platforms: ASP and Windows XP. So please bear with me. I have just installed MySQL via the new windows installer program on my Windows XP Pro machine, and everythin...more >>

hi, I need to create a dsnless connection in oracle9i for my asp application. Can u plz help me in that.Its very urgent. From http://www.developmentnow.com/g/61_2004_3_0_0_0/inetserver-asp-db.htm Posted via DevelopmentNow.com Groups http://www.developmentnow.com...more >>

Is there a way to achieve this? In a DB I have fields named username rd1 rd2 rd3 rd4 rd5 rd6 total each rd is a score that is entered from form going to an asp page. that asp page updates the total. I would like to be able to get a max and min for each username. i know how to ge...more >>

I am writing data to an SQL field (data type = text). I am getting this error when the form is submitted with a large amount of text. Smaller amount of text worked fine. When I traced the size of the text being passed into the sp, this is the value="15189" Microsoft OLE DB Provider for ...more >>

Hi all, I have one field in db as integer, and i want to retreve only those who dont have value 1 and my query is like this: SELECT t_firmepopis.naziv,t_firme.mjesto FROM t_firmepopis INNER JOIN t_firme ON t_firmepopis.id_firma=t_firme.ID_firma and t_firme.sad !=1 and t_firme....more >>

<% csv="file.csv" set fs = createobject("Scripting.FileSystemObject") set f = fs.opentextfile(server.mappath(csv)) while not f.atEndOfStream line = split(f.readline, ",") SQLstr = "insert into database (firm, type, model, cat, price, cat_1) values (" for i = lbound (line) to ubound(...more >>

Could anyone help me with the following problem? In order to collect the hits to different Productpages I inserted a field (hitCount) in a table (Pagina) of a database (Kris.mdb) Unfortunately the code doesn't seem to make a connection with the database. The two records in the body cannot be...more >>

Hi Just wanted to see what the standard battle plan is when you want to allow a user to enter a retrieve data from an ASP/DB solution and the infernal single or double quote issue comes up if they've been entering these chars. For example, I have a web form that is simply: Name: <stand...more >>

Hi, In Access, i defined a field OLE ('pict')and put some jpg files in it. I want to get them, just like the other textfield, into a asp-page. I get no error, but my problem is that the text field appears but not the jpg files (only a red cross). See my code: <% set objdc = Server.CreateObj...more >>

Hello Im having problems with a simple connectionstring that's driving me crazy on a windows 2003 machine. earlier I had 2 seperate machines, running win 2000 and sql 2000, works perfectly, then I was given the task to move the site to a windows 2003 that shall run against same sql 2000. No...more >>

Hello, We are now starting a limited public beta of a new security program for Windows named "NaturalLogin". The program can use one or more hardware devices (such as standard USB storage keys) and/or custom questions to enable a multi-factor (2 or more) login. We are looking for serious...more >>

Hello All, Hope you can help. Below is the code I use to send data from form to database. Problem is if an apostrophe is entered in cQuestion field or any field for that matter the form errors out. Please Help. mySQL= mySQL & "(cEmail,cFirst,cLast,cStreet,cCity,cState,cZi...more >>

Hi I'm trying to upsize a large Jet-based ASP application to use MS SQL Server. I am experiencing a slightly different behaviour when getting results of a SQL join within a Recordset. For example, a query such as: SELECT * FROM Accounts INNER JOIN Categories ON C...more >>

I have an Test page that works fine under HTTP but fails under HTTPS (a shared SSL) with: Microsoft JET Database Engine error '80040e09' Cannot update. Database or object is read-only. All non-database pages work fine under both. My Web host tells me that my ASP page "was cod...more >>

Posting a subfunction I'm using right now.....I keep getting the following error; _______________________________________________ Microsoft JET Database Engine error '80004005' | | Unspecified error | ...more >>

I waould like to know if moving an ASP application from my Windows98 with PWS 4 to WIndowsXP Pro with IIS would cut down on the amount of crashes in inetinfo.exe? I am closing all connections to the dbf files(I am using these because the person that wants this application has all his info in t...more >>

Hello, Is it possible to include a file in a web application which is outside the web path (without virtual directory). - Or use a file in SRC (html code) for example - Language is ASP with IIS6. for example : physical web path application: e:\myapplication. = http:\\www.myweb.net ...more >>

Hi, Is it possible to include a file in a web application which is outside the web path (without virtual directory). Language is ASP with IIS6. for example : physical web path application: e:\myapplication. = http:\\www.myweb.net other directory, outside d:\securitypath how to ...more >>

I am getting the following error on the rsProd.Update line at the end of the sample code I have provided. "Query-based update failed because the row to update could not be found" I have tried everything I could think of but cannot solve this problem. can anyone help? I am new to MYSQL and I mu...more >>

Hi, I'm trying to execute the following SQL query on an ACCESS database using JET4 drivers. select distinct topic_id,* from tblThread for some reason, i'm getting this error : The field is too small to accept the amount of data you attempted to add. Try inserting or pasting less data...more >>

I'm running a simpel SQL question towards an Accessdatabase where the question is generic towards all my tabels in the database Like this MySql = "SELECT * from " & dbtable This gives the result that called table (current value of dbtable) returns all postings(rows) in rising order (AS...more >>

Hi guys, I've created a web application using ASP together with SQL Server as our db source, running through IIS 6 on a Winows Server 2003 platform. This application retrieves a list of customer codes from our db, so records returned could be as many as 2000+ for any single transaction. ...more >>

I recently have switched from using an Access Database to a MYSQL database for an ASP page driven website I have developed. Every once in awhile I am still getting a random blank white page with the message: "The system cannot find the path specified." I click the Refresh button a few times and i...more >>

I have an Order page that updates an MS-Access database. I am getting the following error: Microsoft JET Database Engine error '80004005' Operation must use an updateable query. However, I only get the error when the page runs under HTTPS. One solution is to just run it under HT...more >>

Hi all i want your help in this . I'm writing a code in wich the user can regester. the user can choose to write his ID himself , but if he forgote to write it I want the database to generate it automatecaly. So here is what I'm asking for a code by which I can select the Max Id ...more >>

I have an Intranet-based app at work, and I have it in two places there: a dev machine and a production box. In both cases, the ASP files and SQL Server database are on the same box. I have it running smoothly in both places at work. However, I've been trying to set it up at home, and cannot m...more >>

hi, it's probably a really stupid mistake, but can someone check out this delete query please? i am attempting to do a standard delete operation triggerred by a checkbox ("B_Delete") it deletes all fields, except for ID number (autonumber) in the DB - yet when i make a direct query in ac...more >>

Could somebody help me? is urgent. I failed to get the page count. when i response.write the strStoredProc.PageCount, it return value -1. Can somebody tell me that whether "rstStoredProc.Open objCommand,strConn,adOpenForwardOnly, adLockReadOnly, adCmdStoredProc" is correct to write in this wa...more >>

Another SQL question for you friendly people out there. On an ASP page I access a database that contain the following two tables (simplified here): Table name: Customers Columns: - IDcustomer (primary key) - Companyname (string) Table name: Orders Columns: IDorder (primary key) ID...more >>

Hi All I've only found one NG for MySQL and this doesn't seem to be that popular. Does anybody know of a good NG (this one!!) or forum to post a query that I have on preserving the case of my Win32 tablenames in my ASP/MySQL web app. Please note that MySQL support ain't giving me nothing,...more >>

I have a website connected to an Access 2000 database and every page retrieves info from the database. Every once in awhile out of the blue when I go to a page I get a blank white screen and the message "The system cannot find the path specified". All I do is click Refresh a couple times and the ...more >>