How NOT To Expire The ReportSession And ControlID In The Request

Feb 22, 2007

This question is related to VSTS and above parameters in the request. Question is:

A script created with VSTS for testers has hard coded values for ReportSession and ControlID in the requests, These IDs are expired after some time and scripts fails to run after few hours. Can some one tell me how to set the session expiration time on these ID's in the Report server so I can increase the value to 60*24*365 (1 year) this would solve my problem with hard coded values in the scripts for above mentioned IDs.

View 9 Replies


ADVERTISEMENT

The Request Failed With HTTP Status 400: Bad Request. (Microsoft.SqlServer.Management.UI.RSClient)

Feb 23, 2008

I get this error message when I try to connect to Reporting Services via the Management Studio.

I can see my machine listed in the Server Name > Browse For More > Local Servers dialogue. But no luck,

Ive tried:

Servername: localhost
Servername: DED1774 (the machine name)
Servername: localhost/reportserver
Servername: DED1774/reportserver
Servername: http://ded1774/reportserver (from the rsreportserver.config file

<UrlRoot>http://ded1774/reportserver</UrlRoot>)



I've Googled the error message and found postings for solutions, but none of these helped. Can anyone suggest some simple steps I can take to try to find the issue and get the connection working?

Thanks

View 3 Replies View Related

User Expire

Jun 18, 2008

The following error keeps occurring every 30 minutes in error logs. "The specified user account has expired".

Has anyone ever come across this error message?

View 6 Replies View Related

Make Password Expire

Apr 29, 2008

 Hi all,Suppose I have a SQL database table called Customer Info which contains six fields namely Customer ID, Address, First , Last Name , Password, and Time Remaining.  The Time Remaining field contains the amount of time that a customer has before his or her password expires. I would like info in this field to be in hours and minutes and when it reaches zero, I would like the password to be deleted from the database. So I have two questions and please take into consideration that I am using dot net 2.0.1) Can this be done without having to write a custom function?2) If this can only be done by creating a custom function, how would I get the function to communicate with the database, in other words how would I let the function know that a customer's time is up? Any suggestions will be greatly appreciated, thank you in advance for your help. 

View 2 Replies View Related

Backup Sets To Expire

Feb 25, 2008

I have a maintenance plan setup to expire backup sets after 4 days, but its keep backup copies for an infinite amount of time. I might be misunderstanding whats suppose to happen, but I would expect the files to be removed after 4 days.

View 3 Replies View Related

Set Default Value For Expire Date In Sql Table

Nov 6, 2003

I would like to set the default value of a field to GetDate() + two months.
Is it Possible?
Thanks

View 3 Replies View Related

How To Configure Timeout/expire Session?

May 27, 2008

How can I configure SQL Server 2000 to close the connections that has been inactive/sleeping for more than "X" minutes?

View 6 Replies View Related

How Can You Force A Password, From A Sql Login, To Expire

Aug 31, 2006

How can you force a password, from a sql login, to expire?

I would like to use the password expiration feature for sql logins in SqlServer 2005. The msdn document provides example code for SqlClient SqlConnection.ChangePassword like in Bob Beauchemin's book. http://msdn2.microsoft.com/en-us/library/system.data.sqlclient.sqlconnection.changepassword.aspx

There is a modify_date in the system view sys.sql_logins but that is read-only.



Thanks,

Karl



View 5 Replies View Related

Timeout Expire Error Message

Aug 8, 2006

Hi all,

My application is developed using VB6.0 and SQL Server 2000. Frequently the application displays error message, which says 'Timeout Expired - occurred while getting records" when no. of users grows more than 20. We are using processor based licence SQL Server.
Under what are all the scenario, this error may come? Anybody explain me.
Thanks in advance.
K.Manoharan

View 4 Replies View Related

Design Question About Status And Expire Date

Jul 23, 2007

I have a design question that I was hoping you all can help with.

When I normally design a table I always make sure to include a status field. This way I can "delete" a record without actually having to delete it, just update the record to a status which signifies deleted. This ensures my users have an undelete capability as well as safesguarding against the "mad clickers" which click right through the "You are deleting this record..." alerts.

I have been recently adding tables which have temporary records and are meant to expire at a certain date. I have designed these tables to have an expiration date field AND a status field.

My question is this: What is the normal convention relating to these types of records/tables? Should queries using these types of tables query them using the status AND the expiration date? Should you create a job that updates the records status based on the expiration date being passed. Should you use a view that only displays current records based on expiration date?

I just want to make sure Im following standard practice as I design these types of tables.

Thanks for your help!

View 4 Replies View Related

SQL 2005 Evaluation Edition + Date Of Expire

May 29, 2007

Hi,



where can i see how many days are left until the SQL 2005 Evaluation Edition expires after 180 days?

View 4 Replies View Related

Notification When SQL Server Login Password Is Set To Expire

Jan 17, 2008

Is there a way to set up automated email notification beginning 14 days prior to when a SQL Server Login password (that has "Enforce password expiration" enabled) will expire?

Thanks,

-Dave

View 7 Replies View Related

Need Assistance In Determining Expiring (and Soon To Expire) Sql Accounts

Jul 31, 2007

I have a question regarding notification of password expirations.

Background: My workplace will soon be enforcing the password policy and password expiration facilities in SQL Server 2005. My understanding (and correct me if I am wrong) is that the period of validity for a password before expiration occurs comes from either active directory, or where there is no AD, the local machine security policy.

Because we are on a Novell network our SQL2K5 servers are all mixed authentication. For development purposes we are each given a separate account. Our applications, too, use sql accounts (not windows accounts) for database access. Having a development account expire unexpectedly is no problem; we'll change those passwords as they need to be. What I am concerned with is the accounts our applications use to access the database server; like most IT shops, our applications need to be available with interruptions in service as minimal as possible.

I would like to create and schedule a report to run every morning listing those accounts that are about to expire, or have expired, so that those passwords can be changed with little to no interruption in service.

Question: Where do I pull this data from? I couldn't find anything in the BOL, or online (so far), giving the details of how to determine when a particular account is nearing expiration, or has expired.

I would appreciate any advice anyone has to offer.

Best,
B.

View 3 Replies View Related

Checking User &&amp; Expire Of Update Possibility (by Trigger), How To?

Apr 16, 2007

Hi,



I have Table (RatesTable) every user can insert records to this table, and all users can see this records, this table contain the following columns:



RateID, Service, Rate, DateTime, User



Want I want is a code (trigger) in the database can do the following:



If user perform an Update request the code will check:



- if this recored inserted by the same user update command will be execute.



- if this recored inserted by other user: update command will not execute and return message.



- if more than 5 minutes passed the update command will not be execute and return message.

View 6 Replies View Related

Request For Help

Feb 1, 2000

Okay, I'm a novice! I installed Back Office with NT opperating system on my home computer. I want to learn SQL 7.0. This is incredible, but I can't launch the program. I've tried everything under Start, Programs, SQL, but nothing listed seems to get me into SQL 7.0. What am I missing? Help is most appreciated!!

View 2 Replies View Related

SP ID Request

Sep 26, 2007

So i have the following stored procedure that inserts data into a table then returns the table ID...

ALTER PROCEDURE [dbo].[spA_FSH_InsertVslLic1]
@RegistrationDateDATETIME,
@MartimeRegNumINT,
@FishingVesselNameVARCHAR(40),
@FishingVesselTypeINT,
@OperationalStatusVARCHAR(50),
@FishingVesselBasePortINT,
@FishingVesselRemarksVARCHAR(100),
@PreviousAuthorisationVARCHAR(50),
@FishingVesselLenghtNUMERIC(18,2),
@FishingVesselWidthNUMERIC(18,2),
@FishingVesselHeightNUMERIC(18,2),
@ConstructionPlaceVARCHAR(50),
@ConstructionCountryVARCHAR(25),
@ConstructionYearDATETIME,
@ConstructionShipyardVARCHAR(50),
@ConstructionHullMaterialVARCHAR(50),
@ConstructionRemarksVARCHAR(100)

AS
BEGIN
BEGIN TRY
--insert values into tb_vessellic_vsl_fsh
INSERT INTO tb_vessellic_vsl_fsh
(
vsl_RegistrationDate,
vsl_MartimeRegNumber,
vsl_FishingVesselName,
vsl_vst_VesselTypeID_fk,
vsl_OperationalStatus,
vsl_prt_BasePortID_fk,
vsl_VesselRemarks,
vsl_PreviousAuthorisation,
vsl_OverallLenght,
vsl_Width,
vsl_Height,
vsl_ConstructionPlace,
vsl_ConstructionCountry,
vsl_ConstructionYear,
vsl_ConstructionShipyard,
vsl_ConstructionHullMaterial,
vsl_ConstructionRemarks
)
VALUES
(
@RegistrationDate,
@MartimeRegNum,
@FishingVesselName,
@FishingVesselType,
@OperationalStatus,
@FishingVesselBasePort,
@FishingVesselRemarks,
@PreviousAuthorisation,
@FishingVesselLenght,
@FishingVesselWidth,
@FishingVesselHeight,
@ConstructionPlace,
@ConstructionCountry,
@ConstructionYear,
@ConstructionShipyard,
@ConstructionHullMaterial,
@ConstructionRemarks
)


DECLARE @ID AS INT
SELECT @ID = @@IDENTITY
PRINT @ID
RETURN @ID
END TRY
BEGIN CATCH
EXECUTE spA_GEN_LogError
END CATCH

END

now in the c# code i am calling the stored procedure through this:

public void InsertVslLic1(DateTime regDate, int martimeRegNo, string vesselName, int vesselCategory, string operativeStatus, int basePort, string vesselRemarks,
string previousAuthorisation, double lenght, double width, double height, string constructionPlace, string country, int constructionYear, string shipyard, string hullMaterial,
string structuralRemarks)
{
try
{
//Open Connection
DBConnection db = new DBConnection();
db.OpenConnection();

//Create SQL string
string _sqlString = ("EXECUTE spA_FSH_InsertVslLic1 @RegistrationDate = '" + regDate
+ "', @MartimeRegNum ='" + martimeRegNo
+ "', @FishingVesselName ='" + vesselName
+ "', @FishingVesselType ='" + vesselCategory
+ "', @OperationalStatus ='" + operativeStatus
+ "', @FishingVesselBasePort ='" + basePort
+ "', @FishingVesselRemarks ='" + vesselRemarks
+ "', @PreviousAuthorisation ='" + previousAuthorisation
+ "', @FishingVesselLenght ='" + lenght
+ "', @FishingVesselWidth ='" + width
+ "', @FishingVesselHeight ='" + height
+ "', @ConstructionPlace ='" + constructionPlace
+ "', @ConstructionCountry ='" + country
+ "', @ConstructionYear ='" + constructionYear
+ "', @ConstructionShipyard ='" + shipyard
+ "', @ConstructionHullMaterial ='" + hullMaterial
+ "', @ConstructionRemarks ='" + structuralRemarks + "'");
//Execute SQL String
db.RunSQLQuery(_sqlString);
}
catch (Exception ex)
{
throw ex;
}
}


RunSQLQuery being:

public int RunSQLQuery(string sqlStatement)
{
if (_sqlConnection.State != ConnectionState.Open)
_sqlConnection.Open();

_sqlCommand = new SqlCommand(sqlStatement,_sqlConnection);
return _sqlCommand.ExecuteNonQuery();
}


Now i am stuck on how i will get the ID from the sp (that is @ID) and return it to my C# code as i need it to update the same row further on :)all i am getting till now is the number of rows 'changed' i.e. 1! any thoughts? thanks

View 6 Replies View Related

Help On A Sql Request

Jul 23, 2005

Hi,I have quite a complicated request to do in sql.I've got on table with 3 fields (id, field1, field2) and I have toprocess a request on each of the records, one by one, and thendetermine if the status is OK for each recordsFor example, I would check if the sum of field1 and field2 is greaterthan 10.What is the best way to do this ? It has to be done in a storedprocedure. I can't return the status for each one of the records, soshould I store it in a temporary table and do a select on it from mytier application (vb.net) ?ThxSam

View 7 Replies View Related

Can't Do That Request

Jul 23, 2005

Hi,I'm going to explain as clearly as possible:I have two tables:Relationships(relation_id, table1, table2)Relationfields(relation_id, field1, field2)In Relationships, relation_id is the primary keyIn Relationfields, relation_id is the foreign keyI have a front-end interface that allows the user to add records toRelationships and Relationfields as followed:The user selects a table1 and table2 values from listboxes. These arereal table names from sys.objects, so then the user can select fieldsof these tables on which he wants to create a JOIN.Anyway, I can easily insert the table1 and table2 into Relationships(relation_id is an auto-increment). Then I need to get the relation_idof this new Relationship (easy since I know which values I've insertedand table1-table2 associations are unique.Now the PROBLEM :I need to insert into Relationfields all the fields selectioned by theuser for each of the two tables . But the user might have selectedseveral fields from table1 and table2, so I need to pass A LISTPARAMETER to my Stored Procedure as I don't know how many values offield1 and field2 there is going to be.I hope this is clear enough. Is it possible to achieve what I want ?Should I pass an entire concatenated string with values separated bycomma or whatever and then decrypt it in the stored procedure ?Thx

View 7 Replies View Related

How Can I Request Row #3 In A Dataset?

Sep 29, 2007

I've got a table that houses the data for several routes, (routeID, pointID, Longitude, Latitude and Elevation).  a set of Points make up a route.  I'd like to programmatically access specific points and I'm trying to figure out how to request...say the third point in my dataset.  I'm new to SQL, but I was able to figure out that I can find the row number by using the SQL syntax:SELECT ROW_NUMBER() OVER(ORDER by PointID) as 'Num', Latitude, Longitude, Elevation
FROM [PointTable]
WHERE (RouteID = 5)
 But I cannot (or do not know how to) add a clause that saysAND (Num = 3) So can someone show me how to request a specific row?
 

View 2 Replies View Related

SQL Request Problem

Jan 19, 2008

I have two tables:-------- Bids-------PKBidsFKAuctionsFKUsersBidAmount-------------------FollowedLots-------------------PKFollowedLotsFKAuctionsFKUsers Fields beginning with PK are Primary keys and those beginning with FK are Foreign Keys. For each FollowedLot of a specific User, I would like the MAX BidAmount of the FKAuctions and also the MAX BidAmount of the FKAuctions of that specific User. I hope you can understand my question.Thank you!   

View 7 Replies View Related

Request.ServerVariables In SQL

Jul 13, 2004

I've got a question:

Here's my SQL statement:

SELECT username, vacation, sick, profit_sharing FROM tblUsername WHERE (username = '" & request.servervariables("LOGON_USER") & "')

This code doesn't return any values. What have I done wrong?

Thanks

View 15 Replies View Related

Parametric Sql Request

Oct 4, 2005

due to SQL Injection Attack I use parametric sql request like this   SqlConnection cnx = new SqlConnection(strCnx))        SqlParameter prm;        cnx.Open();        string strQry =             "SELECT Count(*) FROM Users WHERE UserName=@username ";        int intRecs;        SqlCommand cmd = new SqlCommand(strQry, cnx);        cmd.CommandType= CommandType.Text;        prm = new SqlParameter("@username",SqlDbType.VarChar,50);        prm.Direction=ParameterDirection.Input;        prm.Value = txtUser.Text;        cmd.Parameters.Add(prm);but how do I retrieve values ndlr, I have several rowsnormally its like SqlDataAdapter ...                        DataSet...                        DataTable...                        foreach (Datarow datarow in DataTable.Rows)                        {                           ......                        }so how do I retrieve values in parametric request ?????

View 1 Replies View Related

SQL REQUEST WITH 24 TABLES

Sep 3, 1998

Hie,
I have a big request involving 24 tables working with Oracle. I`m porting my application onto SQL Server 6.5. The problem is the maximum number of tables: 16.
I did create a view with 9 tables and recontruct my query with the 15 remaining tables and the view. I tried and I got an error message:
"Msg 4408, Level 19, State 1
The query and the views in it exceed the limit of 16 tables."

Here is the query:
SELECT ENT.ENT_DOM
FROM CTI,
ENT,
IEX,
V_VAL,
V_DEV DEV_A,
VTM VTM1,
VTM VTM2,
VTM VTM3,
VTM VTM4,
VTM VTM5,
V_DEV DEV_B,
NIE,
POS,
TIE,
TLP,
TPL

There is only 16 tables...
Can anyone explain me why it does not work.
Thanks a lot.

Stephane.

View 2 Replies View Related

Error With My Request Maybe OWC...

Jun 4, 2007

Hi, (sorry for my english...)I have a probelm to build my Pivot table.Indeed, The goal is just to see an example of Table Pivot with our Database...For that, I use this link : http://www.csharphelp.com/archives4/archive623.htmlI try to adapt the code but some problems...I use visual developper, and i have installed OWC11 & .NET framework 2.0.using System;using System.Data;using System.Configuration;using System.Web;using System.Web.Security;using System.Web.UI;using System.Web.UI.WebControls;using System.Web.UI.WebControls.WebParts;using System.Web.UI.HtmlControls;using Microsoft.Office.Interop.Owc11;public partial class _Default : System.Web.UI.Page{private void Page_Load(object sender, System.EventArgs e){//determine whether or not the browser supports OWCif(Request.Browser.ActiveXControls){Response.Write("<OBJECT id='pTable' style='Z-INDEX: 109; LEFT: 8px; WIDTH:502px; POSITION: absolute; TOP: 8px; HEIGHT: 217px' height='217' width='502'classid='clsid:0002E55A-0000-0000-C000-000000000046'VIEWASTEXT></OBJECT>");//cause the object to load data on the clientResponse.Write(@"<script>document.all.pTable.ConnectionString ='" + ConfigurationManager.ConnectionStrings["TimeTrackingDB"] + "'</script>");Response.Write("<script>document.all.pTable.ResourceID = 'RESOURCE'</script>");PivotTableClass PTClass = new PivotTableClass();PTClass.ConnectionString = ConfigurationManager.ConnectionStrings["TimeTrackingDB"].ToString();PTClass.DataMember = "";PivotView pview = PTClass.ActiveView;Response.Write(pview.FieldSets.Count);}}}When i'm lauching there is an error : HRESULT E_FAIL http://fists148.free.fr/Error.JPGIf i put the last lines in commentary, public partial class _Default : System.Web.UI.Page{private void Page_Load(object sender, System.EventArgs e){//determine whether or not the browser supports OWCif(Request.Browser.ActiveXControls){Response.Write("<OBJECT id='pTable' style='Z-INDEX: 109; LEFT: 8px; WIDTH:502px; POSITION: absolute; TOP: 8px; HEIGHT: 217px' height='217' width='502'classid='clsid:0002E55A-0000-0000-C000-000000000046'VIEWASTEXT></OBJECT>");//cause the object to load data on the clientResponse.Write(@"<script>document.all.pTable.ConnectionString ='" + ConfigurationManager.ConnectionStrings["TimeTrackingDB"] + "'</script>");Response.Write("<script>document.all.pTable.ResourceID = 'RESOURCE'</script>");}}}The component is loading but it seems to be an issue with the connection database...In my web.config, I Have this : <connectionStrings><add name="TimeTrackingDB" connectionString="Data Source=PORT06139DEV_2000;Initial Catalog=TimeTracking;Persist Security Info=True;User ID=user_TTT;Password=user_TTT;pooling=false"/></connectionStrings>Error connection (http://fists148.free.fr/OWCscreen.JPG)If you have any idea, i take it...I'm deseperate :eek: Thanks By advance

View 6 Replies View Related

Datadesign - Help Request

Aug 25, 2007

HI There,

Im now working on a assignment where i have hierarchial tree structure arrangement for representing an health care. This is supported by SQL DB 2005.One of the node in the tree is dissolved and all it functionality have to ported to the other tree node which share the similar structure.
Problem in porting is complex due to the following things

1. There are capabilities and permission associated with the each node.

2.each node has a unique identifier across the three (note: though this seems to be of no problem it might become issue when search occurs for eg. a->b->c search now becomes a->b->x->n ->?).

3.Already there are messages left in the DB. Please can anyone help me how can i initiate this migration. Im very new to the design and im just started "ABCD" of it.

Thanks in advance.

Cheers,
Vidhya Rao

View 11 Replies View Related

Request For Information

Aug 22, 2007

I am not sure if this belongs under this forum or 'New to SQL' so please feel free to move it if necessary.

Following on from an issue i have had with sysdepends and syscomments tables filling up, I have been trying to research what these tables are and how they get filled up (i.e. what is the trigger to insert a row into these tables).

Unfortunately on all my web searches and book searches i have not found anything much more than 'They are system tables'. From what i have gleaned, it looks like every time a stored procedure or database object is changed, then this will create a new entry into the sysdepends table which highlights what the new object is linked to.

Is this understanding correct? And does anyone have any other sources of information which might give me a better idea of what and how these tables are about.

Many thanks in advance.

Mark

View 2 Replies View Related

Request Issue

Jul 23, 2005

Hi,I've got two primary keys in a table:Constraint(QueryId, ConstraintName)In a stored procedure I select {QueryId, ConstraintName} couples thatmatch some criteria, and what I want to do is specifying in my a SELECTstatement that I want all of the {QueryId, ConstraintName} that are notin my stored procedure result. With only one field, it would be easy :Select * from Constraint where QueryId not in (Select QueryId fromOtherTable)My explanations are not great but I think it's enough to understandwhat I want.Select * from Constraint where QueryId and ConstraintName not in(select QueryId ,ConstraintName from OtherTable)--> of course not correct, but then how can I do that ?Thx

View 7 Replies View Related

DB Shrinks Without Request

Feb 20, 2006

Hi,I have a DB where I would like to maintain a fixed size and control itby myslef.I do not have the options: "Auto-Grow" and "Auto-Shrink" enabled.[color=blue]>From time to time, without a notice, or any logging, the database files[/color]gets shrinker and this causes a database full error.As I wrote, I would like to maintain the size of the database by myselfand not automatioc by the DB server.Please help me find out what can cause this problem and how to solvethis issue.Thnaks,- Ze'ev

View 6 Replies View Related

A Stipulations And A Request

Dec 13, 2007

I Stipulate that I am the most ignorant creature in the universe, incapable of following exactly written directions available all over the internet to install Microsoft Visual Web Developer 2008 Express Edition and SQL Server Express, in a way that will enable me to make a connection to SQL Server Express.

Having Stipulated the above, is there someone out there that can explain to me, in a dumb-proof way, how to do it in a way that is understandable to the most ignorant creature in the universe?


I am running Windows XP SP2 with all the lattest updates, frameworks, etc., and using IIS.

Thanks in advance for any guidance!

View 5 Replies View Related

Request Help For Debugging A SQL Error

Jun 24, 2007

The dynamic SQL at the buttom causes a error: 
Msg 402, Level 16, State 1, Line 9
The data types ntext and nvarchar are incompatible in the equal to operator.
 
I think it is due to the one of the where conditions [URL] = @old_URL ,both are set to NULL(@URL=NULL, @old_URL=NULL).
How do I make changes to the SQL statement to compare the conditions where NULL comparsion is inevitable.
 exec sp_executesql N'UPDATE [Announcement] SET [Atype] = @Atype, [Title] = @Title, [Content] = @Content,  [URL] = @URL WHERE [AnnouncementID] = @old_AnnouncementID AND [Atype] = @old_Atype AND [Title] = @old_Title AND [Content] = @old_Content  AND [URL] = @old_URL',N'@Atype nvarchar(3),@Title nvarchar(3),@Content nvarchar(41),@URL nvarchar(4000),@old_AnnouncementID decimal(1,0),@old_Atype nvarchar(3),@old_Title nvarchar(3),@old_Content nvarchar(41),@old_URL nvarchar(4000)',@Atype=N'CMC',@Title=N'aaa',@Content=N'asdfg',@URL=NULL,@old_AnnouncementID=6,@old_Atype=N'CMC',@old_Title=N'aaa',@old_Content=N'asdfg',@old_URL=NULL 
Any help would be apprecaied,
Ricky.

View 4 Replies View Related

Request Timeout Problem

Jul 10, 2007

Hi everybody.
 Got a nice little problem here. I have a accessdatabase containing 100 000 rows. Im fetching these rows to a dataset and then inserting them, row by row, to a MSSQL dB. The dB and IIS is running on the same server. I also have full control over this webserver, so I pushed the Server.ScriptTimeout value up to 3600 sec (both in IIS and in the c# code) but when executing this query (witch aprox. take me 8 minutes) I recieve a Error Code: 408. The operation timed out. The remote server did not respond within the set time allowed error.
 Someone got a clue for me? :)
 -Thomas

View 2 Replies View Related

SQLServer2K Http Request?

Mar 29, 2004

Is it possible for SQLServer to make a http web request in a stored procedure? I know that you can configure it to send email, but I'd rather do that on the webserver side, and that needs to be triggered by a request of some sort. I have a sp that runs nightly, and I'd like it to send out a http request when its done so that I can do further processing/send email/what have you. I haven't been able to find anything on this subject in any of the books I have, and my google-fu isn't strong enough. Thanks for any hints.

Rob

View 3 Replies View Related

SQL Reporting Services Example Request - ASP.Net

Sep 30, 2004

Hello! I am learning the RS from SQL 2000 and am having an issue. Does anyone have a "Working" example of how to render a report and render images embedded/external/database to the web? I have the report generated, but the pictures just don't want to render (through the web). I have contacted my hosting service (who are all supposedly Microsoft Certified Technicians) and they have no clue why it won't work. I have gone through every online resource that I have been able to find (including the Microsoft thing about the RenderStream) and it still doesn't work. If any of you have a working example of this, it would be very helpful!! As of right now, I am using a database image, and this is the ASP.Net code that I have been using:


Dim rs As New newafp.RSService.ReportingService
rs.Credentials = New System.Net.NetworkCredential("domainusername", "password", "")
Dim items As newafp.RSService.CatalogItem() = rs.ListChildren("/", True)
Dim results As [Byte](), image As Byte()
Dim streamids As String(), streamid As String
results = rs.Render("/NewUserLetter" & Location, "HTML4.0", Nothing, "<DeviceInfo><HTMLFragment>True</HTMLFragment><StreamRoot>/newafp/</StreamRoot></DeviceInfo>", Nothing, Nothing, Nothing, Nothing, Nothing, Nothing, Nothing, streamids)
For Each streamid In streamids
image = rs.RenderStream("folder/NewUserLetter", "HTML4.0", streamid, _
Nothing, Nothing, Nothing, Nothing, Nothing)

Dim stream As System.IO.FileStream = _
System.IO.File.OpenWrite(Server.MapPath("") & "" & streamid & ".jpg")

stream.Write(image, 0, CInt(image.Length))
stream.Close()
Next

Response.BinaryWrite(results)

View 1 Replies View Related







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