ASP Search Screen And MS-SQL 2k

Jul 20, 2005

Hello,

I am looking for help with the following situation.

I have created a simple call tracking system that is integrated
with our accounting / warehousing program in the company. The call
tracking system uses ASP 3.0 and MSSQL 2000 sitting on an Intranet web
server. All appears to be working well with the software. I am
trying to create a search screen to search through the calls based on
different criteria.

I have an ASP script that generates a SELECT statement based on
the selected criteria but this is sent off to the SQL server as the
statement. I want to use a stored procedure to speed up the process.
Is it possible to create a stored procedure for this search even when
the WHERE clause and criteria keeps changing?

TIA

View 3 Replies


ADVERTISEMENT

Trying To Use A Image That Is On The Network That Show On The Layout Screen But Not On The Preview Screen?

Oct 25, 2007

get the following error when I click on prview.

Build complete -- 0 errors, 0 warnings

[rsWarningFetchingExternalImages] Images with external URL references will not display if the report is published to a report server without an UnattendedExecutionAccount or the target image(s) are not enabled for anonymous access.

[rsInvalidMIMEType] The value of the MIMEType property for the image €˜image1€™ is €œtext/html; charset=utf-8€?, which is not a valid MIMEType.

Preview complete -- 0 errors, 2 warnings


This is the URL:

http://air101/airmaps/amsexpress.aspx?sym=bigdot&mlat=42.2446&mlon=-71.1649&lat=42.2446&lon=-71.1649&wid=0.012500&ht=0.012500&mpanv=0&mpanh=0

I've been told that image is a gif how should I set the mimeType?Or is this a security issue of some sort?

View 5 Replies View Related

SQL 2000 MS Search: Boolean Search Doesn't Work When Search By Phrase

Aug 9, 2006

I'm just wonder if this is a bug in MS Search or am I doing something wrong.

I have a query below

declare @search_clause varchar(255)

set @Search_Clause = ' "hepatitis b" and "hepatocellular carcinoma"'

select * from results

where contains(finding,@search_clause)

I don't get the correct result at all.

If I change my search_clause to "hepatitis" and "hepatocellular carcinoma -- without the "b"

then i get the correct result.

It seems MS Search doesn't like the phrase contain one letter or some sort or is it a know bug?

Anyone know?

Thanks

View 3 Replies View Related

Blue Screen

Sep 4, 1999

if you encountera problem of blue screen and then you reinstall NT server, what is the quickest way to restore sql back. after installation of windows nt sql will not start, please advice anyone who knows

View 1 Replies View Related

Full Screen

May 4, 2007

Hi all,



I have a simple question about RS.



I need to show all my reports in full screen mode but I don't find any properties in report.



I read in some threads to use ToolBar options but toolbar show or hide print, refresh, etc. but I want to hide the top bar because I don't want show search box or navigation bar!!!



Thanks for all your help.

View 3 Replies View Related

Bypass Login Screen

Jul 3, 2004

Well im trying to install some software on someone's cpu. I dont know his password, and he has forgotten. How do I get pass the login screen? and assign a new name and password. :confused:

View 2 Replies View Related

Is It Posiable To Close The Screen

Jul 20, 2005

HaiIs it possiable to close the current connection screen in the queryanalyser , not to close the query analyser.With ThanksRaghu

View 3 Replies View Related

Deploying Reports - Log In Screen

Sep 4, 2007

I have created a report, and want to now deploy it to the Report Server. Each time I try to do that, I get a Reporting Services Log In screen. I have no idea what to input, having tried my windows authentication and sa account without sucess. Is there something else that I need to set up so I can deploy my reports? Thanks in advance!

View 1 Replies View Related

Blue Screen Of Death

Feb 7, 2008

Technical information:

***STOP: 0X0000008E (0XC0000005, 0X8062C26B, 0XA84E5A58, 0X00000000)



Beginning dump of physical memory

Physical memory dump complete.

Contact your system administrator or technical support goup for further assistance.





What can i do to fix this problemHelp please, don't want to reinstall XP because i am running AutoCad on my PC.

This Blue screen of death is the worst!!!





Keron

View 1 Replies View Related

No Server Available On Login Screen

Jan 17, 2007

Hi guys,



I recently installed SQL 2005 SP2 on my Vista x64 system. However, when I launch the SQL Server Management Studio, I don't see any server names available, even though I have one called SQL2005 listed as running in the Configuration Manager.

Any idea what I did wrong?

When I type in the correct SQL Server name "SQL2005" and click connect I get this error:



TITLE: Connect to Server
------------------------------

Cannot connect to SQL2005.

------------------------------
ADDITIONAL INFORMATION:

An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 53)

Thanks in advance guys!!!

View 4 Replies View Related

Data From The Database Does Not Seems To Load On Screen...pls Help

Dec 27, 2006

everything is ok.. the connection is on..the page can be loaded... no error....
BUT the data from the database cannot be retrieved... as in.. it just didnt load on screen...
i dont know whats wrong... i have follow all the steps show on a book.. can anyone pls help me?? thks

View 3 Replies View Related

Data Input Screen Design

Sep 14, 2000

does anyone know of easy to use tools to design input screens to access sql version 7 databases

View 1 Replies View Related

Display Error Message On Screen If No Value

Aug 9, 2006

I have a screen set up in another software package which accepts
2 values on a form -

'Number1' and 'Number2'

I need to check that at least a value is entered in one or both ...
If both values are 0 (set on dispaly of the form )then I need
to throw an error message to that effect on screen ....

(The Sql script is triggered after the form data has been entered)

Can anyone help me with the SQL script please to check the values ???

View 5 Replies View Related

EnterpriseManager--&>Process Info Screen

Oct 21, 2005

SQL 2000 SP3================================================In reviewing this screen, I have SPIDS > 100 that have a status ofsleeping, command = AWAITING COMMAND and login/batch dates that areweeks old ... Shouldn't this list be more recent activity only ?Thanks,Craig

View 1 Replies View Related

XP Blue Screen Error 0X0000008E .....

Jul 18, 2007

Just trying to find out what this error code is, and how to solve this. I have the infamous "blue screen of death" but I cannot get XP to load or even to load in "safe mode". I am hoping to save my files on this laptop.



Here is the error:

A problem has been detected and windows has been shut down to prevent damage to your computer.



If this is the first time you've seen this Stop error screen, restart your computer. If this screen appears again, follow these steps:



Check to be sure you have adequate disk space. If a driver is identified in the Stop message, disable the driver or check with the manufacurer for driver updates. Try changing the video adapters.



Check with your harware vendor for any BIOS updates. Disable BIOS memory options such as caching or shadowing. If you need to use Safe Mode to remove or disable components, restart your computer, press F8 to select Advanced Startup Options, and then select Safe Mode.



Technical information:

***STOP: 0X0000008E (0XC0000005, 0X8062C26B, 0XA84E5A58, 0X00000000)



Beginning dump of physical memory

Physical memory dump complete.

Contact your system administrator or technical support goup for further assistance.



I have tried to change my memory but that didn't seem to help. Any ideas?



Thanks for a reply,

Shan



View 1 Replies View Related

Why Is My Print Preview Screen Black?

Apr 25, 2007

So in order for print preview to work, one has to change the background of all items on the page to white?



Is that a bug that is going to be fixed soon (along with running out of memory when you print a big report)?

View 1 Replies View Related

Set View Report Button So It Does Not Go Off Screen

Feb 27, 2008

The "View Report" button is relatively positioned so when the report content is wider than the screen size, it pushes it to the right such that the users have to scrool right to click on it again. Is there a way of setting the "View Report" button to a fixed position to eliminate this?

View 1 Replies View Related

Has Anyone Seen A Licensing Screen During The Install Process?

Jul 28, 2006

Hi again.

I have been deploying the first few test SQL 2005 machines recently, from what I was told is the full-feature edition DVD received from the https://licensing.microsoft.com website.

We have purchased a mixture of per-processor and per-user licenses to use for this software. However, I am never asked what licensing mode to use during the install.

Can anyone confirm or deny that a setup screen appears asking what licensing version you want to use (per-user or per-processor)?

I cannot confirm what was downloaded from the licensing-website because I don't have access through the company.

I have the same symptoms as seen on this postings:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=360181&SiteID=1

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=510279&SiteID=1

However, I don't see such a Control Panel utility to change the licensing type.

Thanks to anyone who can assist.

View 4 Replies View Related

Can The Data Results Screen Be Hidden?

Jul 20, 2007

Can the results screen on the data tab be permanently hidden?



Thanks

BobP

View 2 Replies View Related

Export Pops Login Screen

May 14, 2008

Just reporting a quirky thing here... not sure if it is a config issue for our site, or a bug or what. Just want to put it on the radar screen.

We're running AD here. Have Report Services up and have been running about 6 months now.

People on the domain log into the report site just fine.

Recently I rec'd what I thought would be a security problem, but now I'm not so sure. Our COO tried to export an inventory turns report to excel. About half way through the process after he selects 'Open' a login pops.

The problem is that even if the user puts in valid login credentials, the login just pops again, as if there is something incorrect in the values being typed in.

I was able to replicate this on my machine, even logging in as Administrator.

But, I was also, as a regular user on the domain, able to export several other reports. Only the Inventory turns report pops the login on export.

Then it dawned on me, the inventory report uses a group by table that is expandable by product line.
The reality that is shielded from us when all the groups are collapsed is that as of this morning, the total rows in the table exceed 183,000 lines, way more than what one worksheet can hold.

I'm assuming this has something to do with it, but why I wouldn't just see the standard excel error about this and get a login pop instead perplexes me.

Can anyone confirm that this is indeed what happens if you try to export to excel more rows than a worksheet can hold?

I'm trying to figure out if we have a problem or if it is a 'bug' type of thing.

View 3 Replies View Related

SQL 2012 :: Does Not Load Smaller Splash Screen

May 29, 2014

However when I start SQL 2012 it loads the Management Studio but does not load the smaller splash screen that usally appears asking me to connect to a server. When I try to click any of the menu items at the top of the screen the system just hangs.

I also have 2012 Service pack 1 installed too.My installations of 2005 and 2008r2 still work fine.I also tried loading SQL2014 and had the same issues as with 2012.

View 0 Replies View Related

Blue Screen Of DEATH With SQL Server 2005

Feb 28, 2008

I am hoping someone can guide me through this error. It appears SQL Server 2005 Management Studio might have a bug. What I am accomplishing deleting several rows from several tables inside SSMS. However, after about 4 or five deletions, I get the BLUE SCREEN of DEATH.

I can repeat this pattern.

Thanks for taking the time to read my post.

View 20 Replies View Related

How To Develop Today Screen Plug In For WM5 Pocket PC

Apr 17, 2007

Hi, anybody help me how to develop Today Screen plug in for WM5 pocket pc.

View 1 Replies View Related

Report Wizard - No 'Next' Button Highlighted On Last Screen

May 21, 2007

Hi,



I am trying to use the report wizard and I get to the last screen where it asks for a name for the report file. The 'Next' button is not unprotected although the 'Finish' button is.



As far as I can tell I have setup the Matrix style report up correctly. If I use the 'Finish' button, Visual Studio just crashes.



The help does not give any clue and I have not found any answers in the forum.



Any ideas what the problem might be?

View 3 Replies View Related

Very Slow And Not Complete Screen Update In SQL2005

Jan 14, 2008

Hi

I have the following problem (on 2 PC's now)

On 1 pc i installed VS2008 besides VS2005 and SQL 2005 (before i installed VS2008 everything was fine)

On the other is a fresh installed XP machine with only VS2008 SQL2550 and Office2007
Latets service packs are installed

On both machines when i open a table in SQL 2005 with the 'open table' command the show of the table is very slow.
Every row is updated file by field, the grid is not showing, the row and column headers are not 'grey' as normal.

Scrollign is impossible as the screen updates start again that slow.

Even a small table with 10 rows and 15 field behaves this slow. Its not workable.

What can be done to resove this???


Peter

View 11 Replies View Related

Reporting Services :: How To Resize A Bitmap To Fit Screen

Jun 2, 2015

How can I resize a bitmap to fit the screen?  I have inserted a bitmap using an external source.

View 4 Replies View Related

How To Eliminate Login Screen When I Try To Access Report Via URL

Sep 13, 2007



I am trying to access a report via url

http://69.23.3.112/reportserver?/rptProject/rptStatus&eStatus=All&eUser=2

it always asks for username and password.

All my users login to my project which is asp.net 1.1(vs2003) based project, now from inside the project, if they try to access any report from (which is on framework 2.0), they have to go through a autentication screen which is related to sql server reporting services.

can you please help, how to override this login screen.

Thank you very much for the information.

View 3 Replies View Related

Print From ReportViewer Control Causes Blue Screen

Nov 30, 2007

Hi,

I have a MS Reporting Services Report which I display in a ASPX page inside a iFrame (i.e. an other ASPX page displayed inside the main ASPX page).
The report is rendered to the screen using the normal ReportViewer control.

Everything works fine, except when I click on the Print Button on the ReportViewer control, I get a Blue Screen of Death (BSOD) and my computer restarts.
This is something that happens every single time I click on that Print button

Has this happenend to anyone else?

Regards,
Thysie

View 4 Replies View Related

Trying To Pull Data From Server But Getting A Blank White Screen

May 3, 2007

Hey guys, i finally connected to the db fine however for some reason i cannot pull the data.  I was hoping somebody here might be able to help me.  The code is below
 
    Function MyQueryMethod() As System.Data.DataSet        Dim connectionString As String = "server='xxxx'; user id='xxxx'; password='xxxxxx'; database='wel"& _            "sh_indiv'"        Dim dbConnection As System.Data.IDbConnection = New System.Data.SqlClient.SqlConnection(connectionString)
        Dim queryString As String = "SELECT [test12].[name], [test12].[grade] FROM [test12]"        Dim dbCommand As System.Data.IDbCommand = New System.Data.SqlClient.SqlCommand        dbCommand.CommandText = queryString        dbCommand.Connection = dbConnection
        Dim dataAdapter As System.Data.IDbDataAdapter = New System.Data.SqlClient.SqlDataAdapter        dataAdapter.SelectCommand = dbCommand        Dim dataSet As System.Data.DataSet = New System.Data.DataSet        dataAdapter.Fill(dataSet)
        Return dataSet    End Function
 im kinda new to programming with vb for asp.net pages so please bare with me.

View 2 Replies View Related

Windows 2000 Blue Screen When Opening DTS Package

Jun 25, 2001

I'm pretty sure this problem started after applying Windows 2000 SP2 on machines running SQL 7 SP3. It may be that I only started manipulating these particular DTS jobs since that upgrade.

Problem: In EM I open a DTS package and it causes the server machine to crash to a blue screen. This has happened from a Windows 98 workstation running against a Windows 2000 Server SP2 running SQL7 SP3 and on a standalone laptop running Windows 2000 SP2 running SQL7 desktop edition SP3

Can anyone point me to more information on why this is happening?

Thanks

Doug

View 2 Replies View Related

Calling Subscription Screen Inside Report Viewer

Sep 3, 2007

Hello

I use SQL Server 2005 Reporting Service to develop all my Reports. i design the report and deploy to the report server. i have created a Web application where i use the above report to be shown inside a ReportViewer page.

when any user view's the report i also want to give them the subscription screen inside the report viewer. BIG QUESTION is how do i call the subscription screen of a specific report inside the report viewer?

any help is appreciated

/Chandresh Soni

View 5 Replies View Related

Forms Authentication Resulting In Blank Screen After A Few Minutes.

Jun 27, 2007

Hi €“ I hope someone can help,


I have developed a custom authentication extension to Reporting Services 2005, using Visual Studio 2005 C#.


In local integration tests the extension behaved as expected, honouring the role based security of our main system. Following the deployment steps laid out from numerous sources all worked perfectly. We were optimistic.


I've since deployed to a 'live' user acceptance staging server, using the same procedures used in Integration and it's behaving incorrectly.


Initially the log in page is displayed as expected, at this point SQL dumps occur in the RS Log directory, the same as is seen here: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1750128&SiteID=1


Hopefully there'll be a resolution to that soon. As described in that topic, the main page of Report Manager appears.


After this it all goes wrong.


Sometimes we can browse to a folder and run a report. But after running the report, trying to run something else, or browse back to the containing folder we are presented with the error page with the message:


The permissions granted to user '' are insufficient for performing this operation.


Clicking on the home link brings up the top title and nothing else and you have no option but to close the site and re-login.


Sometimes you get the above message before you can even run a report. The error logs have the message listed at the end of this post.


Other times you log in to the website and the folders don't even appear, just the top title bar.


I have since added some verbose logging in each of the implemented methods in the extension DLL. The permission checking method return true and all the various data in each method appears as expected.


I have checked, checked again and re-checked all the configuration files, they match the local Integration files, barring the machine specific keys etc, they weren't just overwritten.


The location of the log directory where my internal logs are written is read from the configuration files via the SetConfiguration methods, if that wasn't set correctly then there wouldn't be any logs at all, so the configuration is being read correctly by the extension.


One other think that I've noticed is that the back door user that is configured in the config files works perfectly, but I can't see how this can make any sort of a difference as it returns the same result in the extension DLL as a 'normal' user does at the same point in the code.


Can someone please help me, and my poor scalp, it's losing hair at a rate of knots.


Set up:
Windows Server 2005
SQL Server 2005 Service Pack 2 (Developer)
IIS 6


Error message in the log files:


w3wp!library!1!27/06/2007-10:04:20:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.AccessDeniedException: The permissions granted to user '' are insufficient for performing this operation., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.AccessDeniedException: The permissions granted to user '' are insufficient for performing this operation.
w3wp!ui!1!27/06/2007-10:04:20:: e ERROR: The permissions granted to user '' are insufficient for performing this operation.
w3wp!ui!1!27/06/2007-10:04:20:: e ERROR: HTTP status code --> 500
-------Details--------
Microsoft.ReportingServices.Diagnostics.Utilities.AccessDeniedException: The permissions granted to user '' are insufficient for performing this operation.
w3wp!ui!1!27/06/2007-10:04:20:: e ERROR: Exception in ShowErrorPage: System.Threading.ThreadAbortException: Thread was being aborted.
at System.Threading.Thread.AbortInternal()
at System.Threading.Thread.Abort(Object stateInfo)
at System.Web.HttpResponse.End()
at System.Web.HttpServerUtility.Transfer(String path, Boolean preserveForm)
at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String errMsg) at at System.Threading.Thread.AbortInternal()
at System.Threading.Thread.Abort(Object stateInfo)
at System.Web.HttpResponse.End()
at System.Web.HttpServerUtility.Transfer(String path, Boolean preserveForm)
at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String errMsg)

View 3 Replies View Related

SqlServer Weekend Job Blocked By A User Left Open Screen

Jul 20, 2005

Hello!We have a maintenance job on MSSQL server scheduled for the weekend.some times we arrive at the beginning of a week and see that a user lefthis screen open on a SQL record and the job is still waiting blocked bythat user. Please give me an idea how to overcome this.Thanks in advance*** Sent via Developersdex http://www.developersdex.com ***Don't just participate in USENET...get rewarded for it!

View 4 Replies View Related







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