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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
Jul 20, 2007
Can the results screen on the data tab be permanently hidden?
Thanks
BobP
View 2 Replies
View Related
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
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
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
Apr 17, 2007
Hi, anybody help me how to develop Today Screen plug in for WM5 pocket pc.
View 1 Replies
View Related
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
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
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
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
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
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
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
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
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
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
