Database Querying Times

I ported a script I made over to SQL Server 2k from Access and went from queries that took a tenth of a second to up to 30 seconds! Typically they are between 5-10 seconds.

All I can think of is I screwed something up in the connection procedure, and here that is:

Code:
set objConn=Server.CreateObject("ADODB.Connection")
objConn.ConnectionTimeout=30
objConn.Open "Driver={SQL Server};" & _
"Server=ipaddress;" & _
"Address=ipaddress,1433;" & _
"Network=DBMSSOCN;" & _
"Database=databasename;" & _
"Uid=userid;" & _
"Pwd=userpass"
set recordset=server.createobject("adodb.recordset")

View Replies


ADVERTISEMENT

Querying A Database Through An Image

I'm building a path making tool, that is i have a network of paths for a park and each section of the path is its own image.

What i need to do is, when a certain piece of the path is clicked, it querys my path database and returns the information for that section of the path to a table.

Im designing in ASP VBscript and database is connected n all but im a beginner, is it feasable?

As well as this i need to be able to add to the table each time a piece of path is clicked, and also take away, like a stack.

AND aswell as this i need a seperate table which adds up the length of all the paths selected (length is in the database).

View Replies View Related

Multiple Drop Down Boxes Querying A Database

This is the solution needed to have Multiple Drop Down Boxes querying a Database(s) that will not wash out you other textboxes and objects on the select. Copy the code, change the connection to get you data and fly. Code:

View Replies View Related

Querying More Than 255 Characters From FoxPro/DBase Database Field

I've been tasked with integrating an older management system based on
DBF files with my snappy new ASP application to provide users of the
ASP application with real-time data from the management system.

I figure with DBF files, I should use either the DBase drivers or the
FoxPro drivers to connect to the database. Code:

View Replies View Related

SQL/ASP Querying

I created an ordering system using DMWMX 2004, and Access DB. On one page I have an insert form and below a display table that shows their orders and calculates dynamically the value of those orders.

As is right now, the display table show orders for 7 days, but It doesn't discriminate what 7 days. I want to be able to display only orders from monday to Sunday until 5pm.

View Replies View Related

Querying The First Record

how to locate the first record...i sorted the numbers and i want to display the first record based from the query...

View Replies View Related

Querying 2 Tables

I have a database with 2 tables in it.

Each table contains the fields: ID(autonumber),Title, Artist, Description, DiscNo, and TrackNo. The second of the two contains an additional field: Price.

How would I make an asp page in which a person enters DiscNo and Price into a form and the code would read all the fields of that record from table1 and then add those and the Price into table2?

View Replies View Related

Querying A Recordset?

I have a recordset that pulls a list of products that a customer has purchased within the past year to date.

Now I need to sum up the total quantity by month that the customer purchased during that time period and dump all of that info into an html table. I am wondering if it's possible to query the first recordset instead of creating a new nested recordset.

View Replies View Related

Querying From Two Databases?

Given if tables A and B are in the same database, writing a query for them is relatively easy. But what if tables A and B are in different databases? Is it possible to query them together? If so, can anyone provide a generic example?

View Replies View Related

Querying Sql Server

I'm having trouble retrieving one field from a table. Bascially i have two asp pages. On one u select a company field this then loads another page that finds the company details and posts it back to the first page etc.

Problem: The address field has line returns in it. When there aren't line returns it works perfectly otherwise it comes back with 'unterminated string error'.

In query analyzer my query works and i can use replace or update statements to remove
them in query analyzer however when i try that in an asp page it doesn't work.

View Replies View Related

Only Querying Once, Passing Arrays

just wondering if this is possible. i have a page where option boxes are dynamically generated. each time they change the form is submitted, so that it can populate another option box.

these are both database driven, and i was hoping that i could query the information from the database first and then load that into an array/record source. my next task would be to have that array/record source be passed once the page is submitted so that i can use the information again without re-querying the database. (its an efficiency thing) is that even possible? if not what other options do i have?

View Replies View Related

Querying Multiple Tables

I want to query multiple tables (all with exactly the same field names) and then display the records returned in date order.

I've written the SQL to query all the tables (they start with the same name, but end with sequential numbers), but it's returning no records when I know there should be some. Any ideas? Code:

View Replies View Related

Joining/querying 2 Recordsets?

I�ve got 2 recordsets, 1 called �special� and the other called �A55�

Special has a field called �Email_Address��.

A55� also has a field called �Email_Address��.

What I need to do is display all of the records in the recordset �A55� but only the records where the email address field is in the "special" recordset I am using ASP so is the solutions ASP or SQL and how is it done..

View Replies View Related

Querying A DateTime Field In An SQL DB Using ASP

I have a small (still) SQL database, which I am trying to query from an ASP
page.

The field I am querying is of DATETIME data type, and is populated
automatically using the GetDate() function as a default value.

When I try and search on this field, using a date/time in the format
dd/mm/yyyy hh:mm:ss as the search criteria, it fails with the following
error:

[Microsoft][ODBC SQL Server Driver][SQL Server]The conversion of a char data
type to a datetime data type resulted in an out-of-range datetime value.

Can anyone tell me why this is? Surely if I am passing a value in the
correct format for the data stored in the field it should work? Or am I
missing something.

View Replies View Related

Querying Msx 5.5 Public Folders

Would anyone have a way to access certain Exchange public folders that
contain news group emails, perform a query on the folders for keywords and
return a list of those emails?

Basically, I've been asked to put a simple
single field on a web page that will query a list of exchange public folders
and return a list of those emails that have a key word match.

sort of like the MS Index server does on folders with files where one has an
asp interface to query the index data base.

View Replies View Related

Querying Single Quote

I have a rather basic question. I have a simple username and password front end that queries a SQL database, I run into problems when one of the user names has a single quote in it (IE: O'brian).

I get the "Microsoft OLE DB Provider for SQL Server error '80040e14' Line 1: Incorrect syntax near 'brian'." error message, any clues on how to display those particular cases? is there anything in particular that should be done to my SQL statement?

View Replies View Related

SQL Connecting & Querying Function

Does anyone have any functions to start a connection to the database and to query a database instead of typing it all over.

I am new to asp and i got a few days to learn it to get started on my sch project. I have the php database abstarction class, wondering is there any for asp and how do i go abt using it?

View Replies View Related

Querying Two Table In One Select

Is there any way to quiry two tables in one select command to limit the number of database connections. One quire displays members from a members list the other quires achievments for each member. i.e.

select name, memberno from memberlist
then select * from achievements where member = memberno

currently this is done by a loop which requires lots of connections

View Replies View Related

Problem In Querying A Data Field

I'm trying to select all the records of a Database that have the value of the "giorno" ( giorno = day in english.. i'm italian) field bigger than today.... but there's something wrong in my query. The date is in the format dd/mm/yyyy Code:

View Replies View Related

Querying Msx 5.5 Newsgroup Public Folders

we would like to be able to put a simple query field on a webpage whereby users could enter keywords and then have some of the msx 5.5 public folders searched and return a list of those emails that match the criteria. would anyone know how that might be done useing asp and mapi?

View Replies View Related

Querying IISMimeMap .. Access Is Denied

I wrote a Windows Form Application to query the IIS MimeMap on the localhost which worked fine.

I ran the same code in asp.net and got "Access is Denied" exception. What is the least permissions set I should grant the aspnet account to avoid the exception. Or any other suggest would be fine Code:

View Replies View Related

Script Times Out

well, the following script that i wrote using the aspSmartMail component, keeps timing out on me. i tried setting the timeout higher through both IIS and in the script itself, but all that does that it take longer for it to timeout.

i have written a few email programms using this component, so i don't think it is the component. i have just never tried sending emails with it automatically that each have certain unique fields in it. well anyways, here is the code:

View Replies View Related

Download Times

I need to show how long a given file size will download.

View Replies View Related

Pages Times Out

I've written a page that uses a emailer component and it keeps timing out.
It takes 2-3 seconds to send each mail, gets part way through the list of
recipients and dies.I have tried changing the Script Timeout setting in IIS to some huge number(2147483647?).I hve tried setting Server.ScriptTimeout = 0 and Server.ScriptTimeout =2147483647.
None of these make any difference. What can I do now?

View Replies View Related

Compare Two Times

I want to compare two times 1 time is in a variable and the other time is todays time.

i want to get the time in h.m.s

e.g.

12.30.00
13.00.00

this would then output

00.30.00

which i then can then split and if their are 0 i can have get 30 min out of it.

View Replies View Related

Substract Two Times

I need to subtract two times
Example : 1:45 AM - 2:55 PM or 5:45 PM -1:00 AM

View Replies View Related

Loading Times

I have a asp page which pulls alot of data back from a SQL database, is thier any way to show the page while its loading.

I did some diging and found this:

<%
response.buffer=true
response.flush
%>

View Replies View Related

Multiple Times

I have a class that access an MS SQL database.I have another class also accesses an MS SQL database and this second class uses objects from the first class.I have a third class using the DB and objects of the second class.

Each of these classes contain all the code needed to access the database and this means much duplicated code. What I'd like to know is if there is a way to avoid the duplicated code?

I know I could write the code once,then do an #include to include the code into the class,but that still means multiple occurances of the code.

View Replies View Related

Loop Times Out

There is 600 lines of code. This page gets available rooms from RoomInfo and compares the rooms againest rooms in use from EventRoom by RoomID. RoomInfo RoomID field is text. It can contain multiple rooms (i.e. 5,6,7) based on room setup type. I had to do it this way so that users could book multiple rooms based on configuration and how many people.

Line 412 is where the time out occurs. Also if I use split on rs2(RoomID) {line 415} then I can't start at 0, I have to start on 1. Which means 1 room is not being checked. I tried to annotate the code as best as possible. The page is zipped so you can download and view it. It will bomb if you try to run it on the server it is being hosted on.

View Replies View Related

How Many Times Character Appear

I've done this before but cannot remember how. I have a field (FIELDNAME) in a sql2k environment. I just need to know how many times an "_" appears in that field. I cannot figure it out right now.

View Replies View Related

Problem On Querying Access Link Table In ASP Page

I connected MS Exchange Server to MS Access database using Access link
table function. I can open the database table and see the fields and
data inside the link table. However, the table seems cannot be queried
by SQL statement.

My situation is:

I'm building an intranet. I have a ASP login page for all staff in the
company to login. Other people can't register or login the intranet.
That's the reason I use the company email address to verify username
login name.

After I made the link to the Global Address List (rename to
StaffList), I can see the Alias field. I wrote ASP code to use Alias
field to verify user login name. But, the ASP page seems experiencing
difficulties. I always got the "Connection Timeout" Error. Code:

View Replies View Related

Querying Active Directory For Current User's Info

I'm working on a logon script that needs to query AD for the current user's information. Phone numbers, email address, etc. One thing that makes it a little bit more difficult is that I don't have the full dn for the user; I only have the base dc and cn.

Microsoft's documentation on all of this is lacking greatly, so I've been racking my brains quite a bit.

View Replies View Related

Calculate The Differnce Between Two Times

I am trying to calculate (in minutes) the difference between two times. In the database the times are in this format:

Start Time (Game_Time): 1/1/1900 12:00:00 PM

End Time (GameEndTime): 1/1/1900 1:00:00 PM

Here is the code I'm trying:

Code:

GameLength = DateDiff("n",Game_Time,GameEndTime)

The result is: 780

I would expect it to be: 60 minutes

What am I doing wrong?

View Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved