Integrated Security: visual

Showing posts with label visual. Show all posts

Wednesday, March 28, 2012

Intermittent data source problem - trying to access a deleted data source

Hello
I am using Reporting Services within Visual Studio .Net 2003, connecting to
a SQL Server 2000 database.
I am having an intermittent problem with a report misbehaving. The report
has 5 subreports, all of which work fine on their own (for the most part).
The problem is that, sometimes, when I run the main report I get the
following error:-
"An error occurred while executing the subreport ¡OppsHotProspects¢: An
error has occurred during report processing.
Cannot create a connection to data source 'GuessDB'."
This error sometimes only appears for one report, sometimes for all. The
issue is that the 'GuessDB' data source is no longer used; in its place the
'GuessDBLive' data source is now used. I have removed the 'GuessDB' data
source.
When I run each subreport by itself they run fine, and the data source used
in both the Data tab and the Preview tab is the correct one. One
subreport, however, intermittently misbehaves and gives the same error on
its own.
I am very confused as to why this is happening. Presumably something in
each subreport is referencing the deleted data source, but I can't figure
it out. The deleted one should not be getting used at all.
I'd appreciate any help!
Thanks
DeniseFor anyone else having the same problem, I think I've found the answer.
Out of sheer frustration, I examined the code on each report, and on one
there was a chunk of code which referenced the obsolete data source. I've
no idea why this code remained on one report and not the others, but it
did. I removed the offending code, and the problem (touch wood!) has been
resolved.
On Thu, 3 Nov 2005 12:03:38 +0000, Denise wrote:
> Hello
> I am using Reporting Services within Visual Studio .Net 2003, connecting to
> a SQL Server 2000 database.
> I am having an intermittent problem with a report misbehaving. The report
> has 5 subreports, all of which work fine on their own (for the most part).
> The problem is that, sometimes, when I run the main report I get the
> following error:-
> "An error occurred while executing the subreport ¡OppsHotProspects¢: An
> error has occurred during report processing.
> Cannot create a connection to data source 'GuessDB'."
> This error sometimes only appears for one report, sometimes for all. The
> issue is that the 'GuessDB' data source is no longer used; in its place the
> 'GuessDBLive' data source is now used. I have removed the 'GuessDB' data
> source.
> When I run each subreport by itself they run fine, and the data source used
> in both the Data tab and the Preview tab is the correct one. One
> subreport, however, intermittently misbehaves and gives the same error on
> its own.
> I am very confused as to why this is happening. Presumably something in
> each subreport is referencing the deleted data source, but I can't figure
> it out. The deleted one should not be getting used at all.
> I'd appreciate any help!
> Thanks
> Denise

Friday, March 23, 2012

Intergation Services Templates for Visual Studio 2005

We are setting up developer machines with Visual Studio 2005 and SQL SERVER 2005 Client tools. My question is how do I get the templates for Integration Services into Visual Studio 2005 without installing BIDS?

You cannot do this. The Visual Studio IDE hosts packages, one of which is the SSIS designer for example. The only way to install that package is to install the Workstation components for SSIS from SQL Server Setup.

If you do not already have the VS IDE it is included as part of this setup. If you installed SQL first, then would you expect to be able to install the C# or VB package without running the full Visual Studio setup? The packages are slightly different, but the logic is the same.

There are also package templates, but I don't think that is what you mean (http://wiki.sqlis.com/default.aspx/SQLISWiki/PackageTemplates.html)

Interface for Visual C++ in VS 2005?

I've been tasked to understand and develop an easy interface to query (insert, select, update, etc) a sql server compact database on an x86 win ce 5 machine. I'm using VS 2005 and have all the necessary SDK's installed. The problem is I can't find any good tutorials or documentation on sql server compact coding in C++ (only in C# and VB). Do y'all have any suggestions on where I can get started to learn the basic c++ sql interface coding?

Thanks!
Jeff

Edit: I'd like to note that I can run the sample northwind project on a win ce 5 x86 emulator, so it's not the setup that I need help with, but the actual coding.

Here are a couple of good places where you can start:

http://www.codeproject.com/ce/#Database

http://www.pocketpcdn.com/articles/articles.php?&atb.set(c_id)=74&atb.perform(list_folder)=&

|||Thanks for the articles. I like what I see with the ATL OLE DB Consumer Templates articles you wrote, but are they still valid for Visual Studio 2005 or just with eVC++ 3 and 4? I tried converting the sample projects, but I got a ton of compile errors as if the atl library was now very different than the one used in the sample project.

Thanks for any light you can shed!

Jeff
|||

Hi ,

I'am also looking for the same thing.If you get the information, please post it.My requirement is Windows Ce 5 as the mobile device and sql ce 3 and above as the backend.I have tried with the articles posted in the codeproject.com resulting with no luck. I have also tried with ADO and ATL OLE DB but resulting in tons of errors.Please help me in this regard.

|||

I am still using the same headers in VS2005. It's a bit of a kludge, but the Windows Mobile 5 SDK do not ship with the newer versions of the consumer templates (you can see these headers in the Win32 SDK). So far these have worked without issues.

|||Hi,

Thank you very much for quickly reacting to my problem.I have tried to convert a pocket pc 2003 Database application which is shipped with Sql ce 2.0 named Northwindoledb.

I have taken a win32 smart device application and copied all the files from Northwindoledb application and made the following changes .

I have removed the following files from "stdafx.h" header file

"oledb.h"
"oledberr.h"

I have included the following header file to my application.

"ssceoledb.h"

After this I have added the code right after

// Microsoft SQL Server for Windows CE 2.0 Provider (Microsoft.SQLSERVER.OLEDB.CE.2.0)
//
extern const OLEDBDECLSPEC GUID CLSID_SQLSERVERCE_2_0 = {0x76A85B2E,0x9DE0,0x4ded,{0x8E,0x69,0x4D,0xEF,0xDB,0x9C,0x09,0x17}};

in the ssceoledb.h header file.

// Microsoft SQL Server Lite for Windows 3.0 Provider (Microsoft.SQLSERVER.OLEDB.CE.3.0)
//
// {32CE2952-2585-49a6-AEFF-1732076C2945}
//
extern const OLEDBDECLSPEC GUID CLSID_SQLSERVERCE_3_0 = {0x32ce2952, 0x2585, 0x49a6, {0xae, 0xff, 0x17, 0x32, 0x7, 0x6c, 0x29, 0x45}};

and after this add the following line to the "ssceoledb.h" header file

typedef DWORD DBROWSTATUS;

And installed the sqlce 3.0 on windows CE 5.0 mobile.

The application has started running.

But question to you is how can I convert the Same project to MFC Dialog Based application.

Please help me in this regard.

Bye..

J.V.Sivaram

Wednesday, March 21, 2012

Interesting Challenge..

I am making a report in Visual Studio..Now my question is,is there anyway that i can add a tab control for my rdl?Hope to here from anyone out there with a know how..Thanks guys!!

Are you saying that you want your report that is rendered in HTML to have a tab control on it? Or are you asking if you can design the report page just like an HTML page, and drop all sorts of components on to it?

|||

uhm..my reports were being exported in HTML,Excel and PDF..But i dont really know if it is possible to add a tab control to an rdl.I am trying to add a tab control in the COM Components,but i cannot see a tab control for it.

|||do you mean you want to see the RDL (i.e. the xml rather than the GUI)?

just right click on the report in solution explorer and 'view code' - it should open up a new tab with just the raw xml as text|||

thanks for the reply,but what im trying to say here,is that,if it is possible to add a "Tab Control" (like what we see in excel) into the rdl..

|||The RDL is being rendered by the ReportView control and thus can't contain any WinForm or WebForm components. You may be able to simulate what you are wanting to do by using the hidden properties of items such as rectangles. For a wild example of what can be accomplished, take a look at the Etch A Sketch built by Brian Welcher http://blogs.msdn.com/bwelcker/archive/2005/10/29/486534.aspx

(note: the report doesn't appear to be online anymore; download the source, it is well worth it)

If you post or send mock ups of what you are trying to do, I will try and help you build it.

Larry

|||

I just cant download the source.And as for what you are saying,i had tried some tricks like that,but it seems that it is not very effective.One reason is that,if one sheet in any case is too long,then it will push my custom tab(compose of textboxes with navigation to subreports) to go beneaththe page which not supposed to be.But there is no way that you can make it fixed location right.But as what u said that i cannot add a winform,i may agree to that,thanks.But if you still had any other idea,i would be very greatful to hear that.Thank you so much..And by the way for you too see what i had done,i will send one of my form.If you just want to take a look..

<?xml version="1.0" encoding="utf-8"?>

<Body>

</Drillthrough>

</Action>

<Style>

<TextAlign>Center</TextAlign>

<BackgroundColor>LightGrey</BackgroundColor>

</Style>

<Value>Sheet 3</Value>

</Textbox>

</Drillthrough>

</Action>

<Style>

<TextAlign>Center</TextAlign>

<BackgroundColor>LightGrey</BackgroundColor>

</Style>

</Textbox>

<Style>

<BackgroundColor>LightGrey</BackgroundColor>

</Style>

</Rectangle>

</Drillthrough>

</Action>

<Style>

<TextAlign>Center</TextAlign>

</Style>

<Value>Sheet 2</Value>

</Textbox>

<rdefaultName>textbox1</rdefaultName>

</Drillthrough>

</Action>

<Style>

<TextAlign>Center</TextAlign>

<BackgroundColor>LightGrey</BackgroundColor>

</Style>

<Value>Sheet 1</Value>

</Textbox>

<Source>Embedded</Source>

<Value>exgraph</Value>

</Image>

</ReportItems>

<Style>

<Default>Solid</Default>

</BorderStyle>

</Style>

</Body>

<rd:ReportID>fd68b021-3677-4bda-94a8-cee7c9065a99</rd:ReportID>

<ImageData>I had removed the encrypted data for my picture..Maybe you can sub<ImageData>

<MIMEType>image/jpeg</MIMEType>

</EmbeddedImage>

</EmbeddedImages>

</Report>

Again,Thanks.... o_O

By the way,i hadn't notice,the one that i had sent to you was the one that i had placed my custom tab(as if it was,hehe) above the page.

|||

Why do you need to do it this way? You could make 2 seperate reports, embed them in a HTML page and use some javascript to select different divs which changes between the reports... You also don't have to worry about printing issues/exporting with overlaid items...etc. You could even get fancy with some AJAX if you wanted! I dunno, if you can present a clear reason behind why you want to do it that way... But I kind of see it as:

Create tabs on a report...user might not view other tabs = all data must be loaded on report execution = longer load time = unhappy user Sad

Anyways, I'd still be interested if you get it working if you do decide to pursue that path!

|||

Thanks Salvo0194, but honestly speaking,i am not familiar in User Interface because we are in a three - tier framework.And that is what they want me do to.But based on my research,there really is no way that i can try to put a tab control in a rdl.And based as what you had said,i think also that it could only be the best way to do the trick.Thank you so much.But still i am waiting for some other comments that will benefit all of us for certain issues..hehe.. By the way,thanks for reminding,no programmer wants a user to be ..hehe.. o_O

|||

I found a good example at http://blogs.msdn.com/lukaszp/archive/2005/10/11/479791.aspx

but I built one just for you with 'tabs' that work the way I believe you want them. The tab body is a rectangle and the tab tops are text boxes. The tab tops link back to the same report with a parameter set that handles the visibility.

Here is the code:

Code Snippet

<?xml version="1.0" encoding="utf-8"?>
<Report xmlns="http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinitionhttp://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition">http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition</A< A>>" xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">
'>http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">
; <BottomMargin>1in</BottomMargin>
<RightMargin>1in</RightMargin>
<ReportParameters>
<ReportParameter Name="ToggleItem">
<DataType>Integer</DataType>
<DefaultValue>
<Values>
<Value>1</Value>
</Values>
</DefaultValue>
<AllowBlank>true</AllowBlank>
<Prompt>Report_Parameter_0</Prompt>
<Hidden>true</Hidden>
</ReportParameter>
</ReportParameters>
<rd:DrawGrid>true</rd:DrawGrid>
<InteractiveWidth>8.5in</InteractiveWidth>
<rd:SnapToGrid>true</rd:SnapToGrid>
<Body>
<ReportItems>
<Textbox Name="textbox6">
<Left>0.375in</Left>
<ZIndex>8</ZIndex>
<Width>1in</Width>
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Height>0.25in</Height>
<Value>=Code.IsHidden(1)</Value>
</Textbox>
<Textbox Name="textbox5">
<Left>1.375in</Left>
<ZIndex>7</ZIndex>
<Width>1in</Width>
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Height>0.25in</Height>
<Value>=Code.IsHidden(2)</Value>
</Textbox>
<Textbox Name="textbox4">
<Left>2.375in</Left>
<rd:DefaultName>textbox4</rd:DefaultName>
<ZIndex>6</ZIndex>
<Width>1in</Width>
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Height>0.25in</Height>
<Value>=Code.IsHidden(3)</Value>
</Textbox>
<Textbox Name="TabTop1">
<Left>0.375in</Left>
<Top>0.25in</Top>
<ZIndex>5</ZIndex>
<Action>
<Drillthrough>
<ReportName>Report1</ReportName>
<Parameters>
<Parameter Name="ToggleItem">
<Value>1</Value>
</Parameter>
</Parameters>
</Drillthrough>
</Action>
<Width>1in</Width>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<BackgroundColor>LemonChiffon</BackgroundColor>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Height>0.25in</Height>
<Value>TabTop1</Value>
</Textbox>
<Textbox Name="TabTop2">
<Left>1.375in</Left>
<Top>0.25in</Top>
<ZIndex>4</ZIndex>
<Action>
<Drillthrough>
<ReportName>Report1</ReportName>
<Parameters>
<Parameter Name="ToggleItem">
<Value>2</Value>
</Parameter>
</Parameters>
</Drillthrough>
</Action>
<Width>1in</Width>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<BackgroundColor>LemonChiffon</BackgroundColor>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Height>0.25in</Height>
<Value>TabTop2</Value>
</Textbox>
<Textbox Name="TabTop3">
<Left>2.375in</Left>
<Top>0.25in</Top>
<ZIndex>3</ZIndex>
<Action>
<Drillthrough>
<ReportName>Report1</ReportName>
<Parameters>
<Parameter Name="ToggleItem">
<Value>3</Value>
</Parameter>
</Parameters>
</Drillthrough>
</Action>
<Width>1in</Width>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<BackgroundColor>LemonChiffon</BackgroundColor>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Height>0.25in</Height>
<Value>TabTop3</Value>
</Textbox>
<Rectangle Name="Tab1">
<Left>0.125in</Left>
<ReportItems>
<Textbox Name="textbox2">
<Left>0.375in</Left>
<Top>0.625in</Top>
<rd:DefaultName>textbox2</rd:DefaultName>
<Width>1in</Width>
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Height>0.25in</Height>
<Value>TabGuts1</Value>
</Textbox>
</ReportItems>
<Top>0.5in</Top>
<ZIndex>2</ZIndex>
<Visibility>
<Hidden>=Code.IsHidden(1)</Hidden>
</Visibility>
<Width>6.25in</Width>
<Style>
<BackgroundColor>LemonChiffon</BackgroundColor>
</Style>
<Height>1.375in</Height>
</Rectangle>
<Rectangle Name="Tab2">
<Left>0.125in</Left>
<ReportItems>
<Textbox Name="textbox3">
<Left>0.875in</Left>
<Top>0.75in</Top>
<Width>1in</Width>
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Height>0.25in</Height>
<Value>TabGuts2</Value>
</Textbox>
</ReportItems>
<Top>0.5in</Top>
<ZIndex>1</ZIndex>
<Visibility>
<Hidden>=Code.IsHidden(2)</Hidden>
</Visibility>
<Width>6.25in</Width>
<Style>
<BackgroundColor>LemonChiffon</BackgroundColor>
</Style>
<Height>1.375in</Height>
</Rectangle>
<Rectangle Name="Tab3">
<Left>0.125in</Left>
<ReportItems>
<Textbox Name="textbox1">
<Left>0.875in</Left>
<Top>0.5in</Top>
<Width>1in</Width>
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Height>0.25in</Height>
<Value>TabGuts3</Value>
</Textbox>
</ReportItems>
<Top>0.5in</Top>
<Visibility>
<Hidden>=Code.IsHidden(3)</Hidden>
</Visibility>
<Width>6.25in</Width>
<Style>
<BackgroundColor>LemonChiffon</BackgroundColor>
</Style>
<Height>1.375in</Height>
</Rectangle>
</ReportItems>
<Height>3.625in</Height>
</Body>
<rd:ReportID>c853717f-f8cb-4fff-8177-c8c9c3f5548b</rd:ReportID>
<LeftMargin>1in</LeftMargin>
<Code>Function IsHidden(ByVal currentTab As Integer) As Boolean
If Not currentTab = Report.Parameters!ToggleItem.Value Then
Return True
Else
Return False
End If
End Function</Code>
<Width>9.75in</Width>
<InteractiveHeight>11in</InteractiveHeight>
<Language>en-US</Language>
<TopMargin>1in</TopMargin>
</Report>

|||

Larry thanx for the code.Funny we almost had the similar trick,but yours is nicer..hehe..uhm that finished it up..Maybe thats the only thing that we can do.But there only is one issue,uhm i dont know if you had just forgotten it,or what,but by th way,the rectangles are overlapping and it will give the user a warning,which is not good,uhm..but still thanks for that reply.It clears up thing now.But if still,you have a solution about overlapping,it is still greatly accepted(hehe..too much of me)..but maybe it would also be useful to others.Thank You o_O

|||Sorry about that, simply stack them vertically and the rendering engine should reclaim the space if they are not visible. I didn't see the warning on mine.

|||

Ok..thanks so much for the great help..

Interesting Challenge..

I am making a report in Visual Studio..Now my question is,is there anyway that i can add a tab control for my rdl?Hope to here from anyone out there with a know how..Thanks guys!!

|||

|||do you mean you want to see the RDL (i.e. the xml rather than the GUI)?

just right click on the report in solution explorer and 'view code' - it should open up a new tab with just the raw xml as text|||

thanks for the reply,but what im trying to say here,is that,if it is possible to add a "Tab Control" (like what we see in excel) into the rdl..

(note: the report doesn't appear to be online anymore; download the source, it is well worth it)

If you post or send mock ups of what you are trying to do, I will try and help you build it.

Larry

|||

<?xml version="1.0" encoding="utf-8"?>

<Body>

</Drillthrough>

</Action>

<Style>

<TextAlign>Center</TextAlign>

<BackgroundColor>LightGrey</BackgroundColor>

</Style>

<Value>Sheet 3</Value>

</Textbox>

</Drillthrough>

</Action>

<Style>

<TextAlign>Center</TextAlign>

<BackgroundColor>LightGrey</BackgroundColor>

</Style>

</Textbox>

<Style>

<BackgroundColor>LightGrey</BackgroundColor>

</Style>

</Rectangle>

</Drillthrough>

</Action>

<Style>

<TextAlign>Center</TextAlign>

</Style>

<Value>Sheet 2</Value>

</Textbox>

<rdefaultName>textbox1</rdefaultName>

</Drillthrough>

</Action>

<Style>

<TextAlign>Center</TextAlign>

<BackgroundColor>LightGrey</BackgroundColor>

</Style>

<Value>Sheet 1</Value>

</Textbox>

<Source>Embedded</Source>

<Value>exgraph</Value>

</Image>

</ReportItems>

<Style>

<Default>Solid</Default>

</BorderStyle>

</Style>

</Body>

<rd:ReportID>fd68b021-3677-4bda-94a8-cee7c9065a99</rd:ReportID>

<ImageData>I had removed the encrypted data for my picture..Maybe you can sub<ImageData>

<MIMEType>image/jpeg</MIMEType>

</EmbeddedImage>

</EmbeddedImages>

</Report>

Again,Thanks.... o_O

By the way,i hadn't notice,the one that i had sent to you was the one that i had placed my custom tab(as if it was,hehe) above the page.

|||

Create tabs on a report...user might not view other tabs = all data must be loaded on report execution = longer load time = unhappy user Sad

Anyways, I'd still be interested if you get it working if you do decide to pursue that path!

|||

I found a good example at http://blogs.msdn.com/lukaszp/archive/2005/10/11/479791.aspx

Here is the code:

Code Snippet

|||

|||Sorry about that, simply stack them vertically and the rendering engine should reclaim the space if they are not visible. I didn't see the warning on mine.|||Ok..thanks so much for the great help..

Interesting Challenge..

I am making a report in Visual Studio..Now my question is,is there anyway that i can add a tab control for my rdl?Hope to here from anyone out there with a know how..Thanks guys!!

|||

|||do you mean you want to see the RDL (i.e. the xml rather than the GUI)?

just right click on the report in solution explorer and 'view code' - it should open up a new tab with just the raw xml as text|||

thanks for the reply,but what im trying to say here,is that,if it is possible to add a "Tab Control" (like what we see in excel) into the rdl..

(note: the report doesn't appear to be online anymore; download the source, it is well worth it)

If you post or send mock ups of what you are trying to do, I will try and help you build it.

Larry

|||

<?xml version="1.0" encoding="utf-8"?>

<Body>

</Drillthrough>

</Action>

<Style>

<TextAlign>Center</TextAlign>

<BackgroundColor>LightGrey</BackgroundColor>

</Style>

<Value>Sheet 3</Value>

</Textbox>

</Drillthrough>

</Action>

<Style>

<TextAlign>Center</TextAlign>

<BackgroundColor>LightGrey</BackgroundColor>

</Style>

</Textbox>

<Style>

<BackgroundColor>LightGrey</BackgroundColor>

</Style>

</Rectangle>

</Drillthrough>

</Action>

<Style>

<TextAlign>Center</TextAlign>

</Style>

<Value>Sheet 2</Value>

</Textbox>

<rdefaultName>textbox1</rdefaultName>

</Drillthrough>

</Action>

<Style>

<TextAlign>Center</TextAlign>

<BackgroundColor>LightGrey</BackgroundColor>

</Style>

<Value>Sheet 1</Value>

</Textbox>

<Source>Embedded</Source>

<Value>exgraph</Value>

</Image>

</ReportItems>

<Style>

<Default>Solid</Default>

</BorderStyle>

</Style>

</Body>

<rd:ReportID>fd68b021-3677-4bda-94a8-cee7c9065a99</rd:ReportID>

<ImageData>I had removed the encrypted data for my picture..Maybe you can sub<ImageData>

<MIMEType>image/jpeg</MIMEType>

</EmbeddedImage>

</EmbeddedImages>

</Report>

Again,Thanks.... o_O

By the way,i hadn't notice,the one that i had sent to you was the one that i had placed my custom tab(as if it was,hehe) above the page.

|||

Create tabs on a report...user might not view other tabs = all data must be loaded on report execution = longer load time = unhappy user Sad

Anyways, I'd still be interested if you get it working if you do decide to pursue that path!

|||

I found a good example at http://blogs.msdn.com/lukaszp/archive/2005/10/11/479791.aspx

Here is the code:

Code Snippet

|||

sql

Monday, March 19, 2012

Interdev, SQL Server 2000 vs. SQL Server 7; open/design problems

I run Visual Interdev 6... I have 2 web servers and 2 database
servers... (1 of each located in my home - A; and 1 of each co-located
at an ISP - B with our own firewall at each location).
Location A:
Firewall, port 1433 opened (for specific IP#'s)
Web Server: IIS5
SQL Server: 7
Location B:
Firewall, port 1433 opened (for specific IP#'s)
Web Server: IIS6
SQL Server: 2000
For both locations, I can edit files and open databases. For location
A, I can also DESIGN databases (create new ones, edit existing ones)
through InterDev. I can NOT do this at Location B and its driving me
nuts. While I can open databases and view the contents, I can not
create new databases through Interdev nor add fields to existing ones.
I've made sure that BUILTIN/Administrators has the same access (and I'm
an administrator on all 4 servers) on both SQL servers.
Any ideas what I am missing here? Its driving me nuts having to
terminal service into Location B's database server everytime I want to
create a new database or even a new field!
I should mention that while I'm away from home, I can still design
databases from my home servers so it isn't being "inside" a firewall
vs. "outside". I have the exact same problem no matter WHERE I am
connected from (I tend to travel alot).

Interdev, SQL Server 2000 vs. SQL Server 7; open/design problems

I run Visual Interdev 6... I have 2 web servers and 2 database
servers... (1 of each located in my home - A; and 1 of each co-located
at an ISP - B with our own firewall at each location).
Location A:
Firewall, port 1433 opened (for specific IP#'s)
Web Server: IIS5
SQL Server: 7
Location B:
Firewall, port 1433 opened (for specific IP#'s)
Web Server: IIS6
SQL Server: 2000
For both locations, I can edit files and open databases. For location
A, I can also DESIGN databases (create new ones, edit existing ones)
through InterDev. I can NOT do this at Location B and its driving me
nuts. While I can open databases and view the contents, I can not
create new databases through Interdev nor add fields to existing ones.
I've made sure that BUILTIN/Administrators has the same access (and I'm
an administrator on all 4 servers) on both SQL servers.
Any ideas what I am missing here? Its driving me nuts having to
terminal service into Location B's database server everytime I want to
create a new database or even a new field!I should mention that while I'm away from home, I can still design
databases from my home servers so it isn't being "inside" a firewall
vs. "outside". I have the exact same problem no matter WHERE I am
connected from (I tend to travel alot).

Friday, February 24, 2012

Integration Services won't install

I am installing Visual Studio 2005 Professional on Windows XP.

I have finished installing Visual Studio 2005 Professional along with Service Pack 1. Now I am installing the Developer version of SQL 2005 that comes with Visual Studio 2005 Professional .

During the installation of SQL Server 2005, I got the following error during
the integration services installation portion:

Failed to install and configure assemblies: c:\program files\microsoft sql
server\90\dts\tasks\microsoft.sqlserver.msmqtask.d ll in the COM+ catalog.
Error -2146233087

Error message: unknown error 0x80131501
Error description: You must have administrative credentials to perform this
task.

I'm logged into Windows as Administrator.

This machine did previously have VS 2005 Standard and SQL 2005 Standard loaded. The software was RTM software as provided by Microsoft at their launch event. I did uninstall both products before attempting the upgrade.

Any help would be much appreciated.

Hi,

Refer below links for workaround

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

http://geekswithblogs.net/waterbaby/archive/2006/08/03/87048.aspx

HTH

Hemantgiri S. Goswami

|||

This is an issue when Microsoft.SqlServer.MSMQTask is left behind in COM+ catalog. You can workaround it by:

1. Open Administrative Tools\Component Services

2. Go to Component Services\Computers\My Computer\COM+ Applications

3. Delete Microsoft.SqlServer.MSMQTask

Integration Services Designer (Visual Studio) very very slow

Hi all

I have some performance issues when developing Integration Service Package ...

It is very very slow for example when I try to add new connection in
Connection Manages, it takes about 2 minutes just to open the property window.

On another pc in the same environment it works ok.
In the past I have doing a lot of SSIS Packages ... Is there any cache to empty ?

Thanks for any comments

Best regards
Frank Uray

Have you tried the 'work offline' option in SSIS menu. That option will prevent SSIS to validate connections in the package at design time. I am not sure if that is the source of your problem; bt you can try it.|||

Thank you for your answer,
but this does not help, it is still very slow ... :-(

Best regards
Frank Uray

|||Um, well... What are your machine specifications? CPU? RAM? etc...

What's the version number of SSIS?|||

Hi Phil

Here are the specifications:
- Dual Core AMD Opteron 2.20 GHz.
- 3.50 GB RAM
- 160 GB Disk
- HP xw9300 Workstation
- Windows XP SP2
- Visual Studio 8.0.50727.42 (RTM.050727-4200)

Hope you can find out something ...

Thanks and best regards
Frank Uray

|||

That's weird. I have half of that hardware and same VS version and run with no problem. Do you get the same behavior even when you create a new project/package? Check the task manager activity as well.

|||

Hi Rafael

Yes, I can create a new project and when I try to
add a new connection it takes 2 minutes to open
the first dialogbox ...
TaskManager is very quiet ...

Also when I run a package on my pc, it takes about
this 2 minutes to begin running the package.
When I run it on the server, the package finishes in 30 seconds.

Thanks and best regards
Frank Uray

|||This could also just be caused by network configurations when trying to do the connection discovery.|||

1.For integration service designer You should also install SQL 2005 SP1 and

the SQL2005 hotfix 2153.

2.another tip I found in the newsgroups was :

In internet explorer go to Tools-> options-> advanced

Uncheck the tickbox "check for publisher's certificate revocation"

(tnx to Nico Verheire)

3.When the designer is extremely slow in complex data flows, you have to break up the package in severaldataflows and use raw files to transfer data from one data flow to the other. See article <http://www.sqljunkies.com/WebLog/reckless/archive/2006/05/01/ssis_largedataflows.aspx>

I hope this can help.

Met vriendelijke groeten - Best Regards - Cordialement - Mit Freundlichen

Gruessen

Jan D'Hondt

Jade bvba

www.jadesoft.be

Integration Services Designer (Visual Studio) is very very slow

Hi all

I have some performance issues when developing Integration Service Package ...

It is very very slow for example when I try to add new connection in
Connection Manages, it takes about 2 minutes just to open the property window.

On another pc in the same environment (Domain etc.) it works ok.
In the past I have doing a lot of SSIS Packages ... Is there any cache to empty ?

Thanks for any comments

Best regards
Frank Uray

Do you have the SSIS service running? That can sometimes speed things up because it caches information about tasks and components.

Other than that - its more likely this can be attributed to hardware or network issues. I suppose it could be a million and one things.

-Jamie

Sunday, February 19, 2012

Integration Help

I have a Visual Studio 2005 professional and Sql Server 2005 Express.

I download the 'Books on line for Sql Server' but when call help in VB interface or in

Management Sql Express the message appear:

Integrated help is not available ....

This is a bug?

Thanks,

Marsenne

Hi Marsenne,

It would be helpful to know the following information:

1. What version of Books Online did you download? The December 2005 or April 2006 version?

2. In what order did you install the components (VS, Express, Books Online).

3. Did you install Express from the VS installation or did you download SQL Express separately?

Regards,

Gail

|||

Hi Gail,

1. The version is December 2005 (SqlServer2K5_BOL_Dec2005.msi)

2. I install in order: VS, Express, Books Online.

3. Begin, I install Sql Express include in VS, but do not language brazilian portuguese. I remove this and install Sql Express spk1 (download).

Thanks and Regards,

Marsenne Negreiros

|||

Hi Marsenne,

It may be some issue between the December BOL and SQL Express SP1. WIll you please download the April version of BOL from here: (http://www.microsoft.com/downloads/details.aspx?FamilyID=be6a2c5d-00df-4220-b133-29c1e0b6585f&DisplayLang=en and see if you have the same problem?

Thanks,

Gail

|||

Hi Gail,

I unistall the Dez/2005 and Install the Abri/2006.

The help is now integrated. Very good.

Thanks,

Marsenne

|||

Hi Marsenne,

Glad to hear that solution worked for you.

Regards,

Gail

Wednesday, March 28, 2012

Intermittent data source problem - trying to access a deleted data source

Friday, March 23, 2012

Intergation Services Templates for Visual Studio 2005

Interface for Visual C++ in VS 2005?

Wednesday, March 21, 2012

Interesting Challenge..

Interesting Challenge..

Interesting Challenge..

Monday, March 19, 2012

Interdev, SQL Server 2000 vs. SQL Server 7; open/design problems

Interdev, SQL Server 2000 vs. SQL Server 7; open/design problems

Friday, February 24, 2012

Integration Services won't install

Integration Services Designer (Visual Studio) very very slow

Integration Services Designer (Visual Studio) is very very slow

Sunday, February 19, 2012

Integration Help

Integrated Security

Blog Archive

About Me