Authoring Custom Report Controls

Hi,

I'm using VS2005 Beta 2 (April) and SQL Server 2005 (CTP April 2005) and I'm very interested in creating my own custom control for SQL Server 2005 ReportingServices.

I understand that in order to do this I have to inherit from some classes (CustomReportItem?) and other interfaces which are declared in the following namespaces:

using Microsoft.ReportingServices.Interfaces;
using Microsoft.ReportingServices.ReportRendering;
using Microsoft.ReportingServices.ReportProcessing;

Does anybody have a simple example I can use similar to the SimpleControl Sample for Windows Forms control? Or any other pointers?

Many thanks,

The documentation and sample for Custom Report Item is planned to be available around the time SQL 2005 releases. They are not available at this time.

|||Hi Christopher,
i've got exact the same problem and searching for answers too. did u have n e prosperties in the meantime ? i've got an MS-live-meeting today to solve this problem, hopefully. if u need help ...|||Does anybody know anything more about this yet?

Many thanks!|||

Hi,
What's the status on this topic?
- Does it work in the current release at all or is the sample just not produced?
- If you have anything like an embryo to a sample I'd be grateful for input...we're starting a development project now so, an answer would much appreciated

Thanks in advance

Michael G

|||

Does anybody know anything more about this yet?

Best Regards, and thanks for your answers...

Authoring Custom Report Controls

Hi,

I'm using VS2005 Beta 2 (April) and SQL Server 2005 (CTP April 2005) and I'm very interested in creating my own custom control for SQL Server 2005 ReportingServices.

I understand that in order to do this I have to inherit from some classes (CustomReportItem?) and other interfaces which are declared in the following namespaces:

using Microsoft.ReportingServices.Interfaces;
using Microsoft.ReportingServices.ReportRendering;
using Microsoft.ReportingServices.ReportProcessing;

Does anybody have a simple example I can use similar to the SimpleControl Sample for Windows Forms control? Or any other pointers?

Many thanks,

The documentation and sample for Custom Report Item is planned to be available around the time SQL 2005 releases. They are not available at this time.

|||Hi Christopher,
i've got exact the same problem and searching for answers too. did u have n e prosperties in the meantime ? i've got an MS-live-meeting today to solve this problem, hopefully. if u need help ...
|||Does anybody know anything more about this yet?

Many thanks!|||

Hi,
What's the status on this topic?
- Does it work in the current release at all or is the sample just not produced?
- If you have anything like an embryo to a sample I'd be grateful for input...we're starting a development project now so, an answer would much appreciated

Thanks in advance

Michael G

|||Does anybody know anything more about this yet?

Best Regards, and thanks for your answers...

Authoring Custom Report Controls

Hi,

I'm using VS2005 Beta 2 (April) and SQL Server 2005 (CTP April 2005) and I'm very interested in creating my own custom control for SQL Server 2005 ReportingServices.

I understand that in order to do this I have to inherit from some classes (CustomReportItem?) and other interfaces which are declared in the following namespaces:

using Microsoft.ReportingServices.Interfaces;
using Microsoft.ReportingServices.ReportRendering;
using Microsoft.ReportingServices.ReportProcessing;

Does anybody have a simple example I can use similar to the SimpleControl Sample for Windows Forms control? Or any other pointers?

Many thanks,

The documentation and sample for Custom Report Item is planned to be available around the time SQL 2005 releases. They are not available at this time.

|||Hi Christopher,
i've got exact the same problem and searching for answers too. did u have n e prosperties in the meantime ? i've got an MS-live-meeting today to solve this problem, hopefully. if u need help ...|||Does anybody know anything more about this yet?

Many thanks!|||

Hi,
What's the status on this topic?
- Does it work in the current release at all or is the sample just not produced?
- If you have anything like an embryo to a sample I'd be grateful for input...we're starting a development project now so, an answer would much appreciated

Thanks in advance

Michael G

|||

Does anybody know anything more about this yet?

Best Regards, and thanks for your answers...

sql

Authoring Custom Report Controls

Hi,

I'm using VS2005 Beta 2 (April) and SQL Server 2005 (CTP April 2005) and I'm very interested in creating my own custom control for SQL Server 2005 ReportingServices.

I understand that in order to do this I have to inherit from some classes (CustomReportItem?) and other interfaces which are declared in the following namespaces:

using Microsoft.ReportingServices.Interfaces;
using Microsoft.ReportingServices.ReportRendering;
using Microsoft.ReportingServices.ReportProcessing;

Does anybody have a simple example I can use similar to the SimpleControl Sample for Windows Forms control? Or any other pointers?

Many thanks,

The documentation and sample for Custom Report Item is planned to be available around the time SQL 2005 releases. They are not available at this time.

|||Hi Christopher,
i've got exact the same problem and searching for answers too. did u have n e prosperties in the meantime ? i've got an MS-live-meeting today to solve this problem, hopefully. if u need help ...
|||Does anybody know anything more about this yet?

Many thanks!|||

Hi,
What's the status on this topic?
- Does it work in the current release at all or is the sample just not produced?
- If you have anything like an embryo to a sample I'd be grateful for input...we're starting a development project now so, an answer would much appreciated

Thanks in advance

Michael G

|||Does anybody know anything more about this yet?

Best Regards, and thanks for your answers...

Authentication in SQL Server

Hi folks,

Got a massive problem.
I'm starting to develop a new website using ASP.NET v3.5 (the CTP of Microsoft's new Visual Web Developer "Orcas"). I saved the project onto a network drive (called X: for the purposes of this discussion) - X:\Orcas_WS\VVProject.
Set up a new database and table to upload files from an ASP.NET AJAX form to a database table, fields as follows:
[ImgID] - type int, Identity field, auto-increment of 1;
[GallID] - type int;
[GallPos] - type int;
[ImgContentType] - type nchar(10);
[ImgContent] - type image (binary data);

Worked a dream when running the development server on my laptop and using my own username and password to upload stuff to (in connection string, using Integrated Security = SSPI).
Have now uploaded this to a live server, installed .NET Framework v3.5 on my server, (attempted to) enable IUSR_MACHINE account to have read/write access to my DB and now it's all gone to pot. None of my accounts can authenticate against this DB using .NET - whether it's NETWORK SERVICE, or IUSR_CM-SUMM, even my own username and password, with Integrated Security both set to SSPI and False.
I am now getting intermittent errors where login will either succeed but .NET will try and use named pipes and says "there is nothing on the other end of the pipe" with an event 3005 in my event log, or I get an "login failed for user (username)" message and a failure audit in my event log.

I read up somewhere about having to deregister the Service Principal Name to avoid auth errors (which is what seems to be happening), but having trawled Microsoft's website for hours, there seems to be no documentation or instruction on how to deregister an SPN.

Please help folks, this project is financially lucrative and I want to make a fantastic impression on the client with a low development time overhead!

Many thanks in advance,

medicineworkerAdmin, please close thread, problem sorted - my MS SQL Server was being stoopid, my schema permissions had (rather strangely) been entirely wiped out... lol, have fixed.

Cheers!

Attaching Database 'AdventureWorks'

Hi,
I have installed SQL Server 2005 CTP/Trial Version.
When I try to attach the database 'AdventureWorks', I get the following error.
Could not find row sysindexes for database ID 11, Object ID 1, index ID 1.
Run DBCC
CHECKTABLE on sysindexes
Could not open new database 'AdventureWorks'. CREATE DATABASE is aborted.
I also tried suggestions in BooksOnline but it didn't help.
Please advise how to attach the database.
Thanks a lot
Steve
IT Developer
You have asked this question in four different places that I have seen and
have already gotten a response. Please do not multipost.
Thanks!
HTH
Kalen Delaney, SQL Server MVP
www.solidqualitylearning.com
"Steve" <Steve@.discussions.microsoft.com> wrote in message
news:290AD911-24FA-419B-8A26-636CC009B189@.microsoft.com...
> Hi,
> I have installed SQL Server 2005 CTP/Trial Version.
> When I try to attach the database 'AdventureWorks', I get the following
> error.
> Could not find row sysindexes for database ID 11, Object ID 1, index ID 1.
> Run DBCC
> CHECKTABLE on sysindexes
> Could not open new database 'AdventureWorks'. CREATE DATABASE is aborted.
> I also tried suggestions in BooksOnline but it didn't help.
> Please advise how to attach the database.
> Thanks a lot
> --
> Steve
> IT Developer
>

Attaching Database 'AdventureWorks'

Hi,
I have installed SQL Server 2005 CTP/Trial Version.
When I try to attach the database 'AdventureWorks', I get the following error.
Could not find row sysindexes for database ID 11, Object ID 1, index ID 1.
Run DBCC
CHECKTABLE on sysindexes
Could not open new database 'AdventureWorks'. CREATE DATABASE is aborted.
I also tried suggestions in BooksOnline but it didn't help.
Please advise how to attach the database.
Thanks a lot
Steve
IT Developer
You have asked this question in four different places that I have seen and
have already gotten a response. Please do not multipost.
Thanks!
HTH
Kalen Delaney, SQL Server MVP
www.solidqualitylearning.com
"Steve" <Steve@.discussions.microsoft.com> wrote in message
news:F507C579-89CA-40F4-BC9A-F0233C2B7F08@.microsoft.com...
> Hi,
> I have installed SQL Server 2005 CTP/Trial Version.
> When I try to attach the database 'AdventureWorks', I get the following
> error.
> Could not find row sysindexes for database ID 11, Object ID 1, index ID 1.
> Run DBCC
> CHECKTABLE on sysindexes
> Could not open new database 'AdventureWorks'. CREATE DATABASE is aborted.
> I also tried suggestions in BooksOnline but it didn't help.
> Please advise how to attach the database.
> Thanks a lot
> --
> Steve
> IT Developer
>

Attaching Database 'AdventureWorks'

Hi,
I have installed SQL Server 2005 CTP/Trial Version.
When I try to attach the database 'AdventureWorks', I get the following error.
Could not find row sysindexes for database ID 11, Object ID 1, index ID 1.
Run DBCC
CHECKTABLE on sysindexes
Could not open new database 'AdventureWorks'. CREATE DATABASE is aborted.
I also tried suggestions in BooksOnline but it didn't help.
Please advise how to attach the database.
Thanks a lot
--
Steve
IT DeveloperYou have asked this question in four different places that I have seen and
have already gotten a response. Please do not multipost.
Thanks!
--
HTH
Kalen Delaney, SQL Server MVP
www.solidqualitylearning.com
"Steve" <Steve@.discussions.microsoft.com> wrote in message
news:F507C579-89CA-40F4-BC9A-F0233C2B7F08@.microsoft.com...
> Hi,
> I have installed SQL Server 2005 CTP/Trial Version.
> When I try to attach the database 'AdventureWorks', I get the following
> error.
> Could not find row sysindexes for database ID 11, Object ID 1, index ID 1.
> Run DBCC
> CHECKTABLE on sysindexes
> Could not open new database 'AdventureWorks'. CREATE DATABASE is aborted.
> I also tried suggestions in BooksOnline but it didn't help.
> Please advise how to attach the database.
> Thanks a lot
> --
> Steve
> IT Developer
>

Attaching Database 'AdventureWorks'

Hi,
I have installed SQL Server 2005 CTP/Trial Version.
When I try to attach the database 'AdventureWorks', I get the following erro
r.
Could not find row sysindexes for database ID 11, Object ID 1, index ID 1.
Run DBCC
CHECKTABLE on sysindexes
Could not open new database 'AdventureWorks'. CREATE DATABASE is aborted.
I also tried suggestions in BooksOnline but it didn't help.
Please advise how to attach the database.
Thanks a lot
--
Steve
IT DeveloperYou have asked this question in four different places that I have seen and
have already gotten a response. Please do not multipost.
Thanks!
HTH
Kalen Delaney, SQL Server MVP
www.solidqualitylearning.com
"Steve" <Steve@.discussions.microsoft.com> wrote in message
news:F507C579-89CA-40F4-BC9A-F0233C2B7F08@.microsoft.com...
> Hi,
> I have installed SQL Server 2005 CTP/Trial Version.
> When I try to attach the database 'AdventureWorks', I get the following
> error.
> Could not find row sysindexes for database ID 11, Object ID 1, index ID 1.
> Run DBCC
> CHECKTABLE on sysindexes
> Could not open new database 'AdventureWorks'. CREATE DATABASE is aborted.
> I also tried suggestions in BooksOnline but it didn't help.
> Please advise how to attach the database.
> Thanks a lot
> --
> Steve
> IT Developer
>

AttachDbFilename, |DataDirectory| and SQL Server 2005 June CTP Relative Paths

Hello,

I am using "AttachDbFilename" to connect to a June CTP SQLExpress database. I have a windows forms application that has the following connection string (which works fine at the moment):

"Data Source=.\SQLEXPRESS;AttachDbFilename='|DataDirectory|test.mdf';Integrated Security=True;User Instance=True"

However, I would like to make my connection string:

"Data Source=.\SQLEXPRESS;AttachDbFilename='|DataDirectory|..\..\Database\test.mdf';Integrated Security=True;User Instance=True"

But no matter what combination I try (including not using DataDirectory at all), I cannot seem to open the database using the relative path.

Can someone please assist/clarify?

Thanks,
Sean H.

Hi,

DataDirectory is specifically restricted to only allow access to files in the directory pointed to by the DataDirectory value or any of its subdirectories, but not directories up in the chain.

This is to prevent security issues such as those common in older web servers where you could navigate the server file-system by doing something like http://www.mywebsite.com/..\..\..\etc\passwords

-pablo|||When you say "the directory pointed to by the DataDirectory value " what exactly is that? In other words, what is this value and where can I set/change it?

Thanks - Daniel|||

you can change:

AppDomain.CurrentDomain.setData(“DataDirectory”,”C:\newPath\”);

AttachDbFilename, |DataDirectory| and SQL Server 2005 June CTP Relative Paths

Hello,

I am using "AttachDbFilename" to connect to a June CTP SQLExpress database. I have a windows forms application that has the following connection string (which works fine at the moment):

"Data Source=.\SQLEXPRESS;AttachDbFilename='|DataDirectory|test.mdf';Integrated Security=True;User Instance=True"

However, I would like to make my connection string:

"Data Source=.\SQLEXPRESS;AttachDbFilename='|DataDirectory|..\..\Database\test.mdf';Integrated Security=True;User Instance=True"

But no matter what combination I try (including not using DataDirectory at all), I cannot seem to open the database using the relative path.

Can someone please assist/clarify?

Thanks,
Sean H.

Hi,

DataDirectory is specifically restricted to only allow access to files in the directory pointed to by the DataDirectory value or any of its subdirectories, but not directories up in the chain.

This is to prevent security issues such as those common in older web servers where you could navigate the server file-system by doing something like http://www.mywebsite.com/..\..\..\etc\passwords

-pablo|||When you say "the directory pointed to by the DataDirectory value " what exactly is that? In other words, what is this value and where can I set/change it?

Thanks - Daniel|||

you can change:

AppDomain.CurrentDomain.setData(“DataDirectory”,”C:\newPath\”);

AttachDbFilename, |DataDirectory| and SQL Server 2005 June CTP Relative Paths

Hello,

I am using "AttachDbFilename" to connect to a June CTP SQLExpress database. I have a windows forms application that has the following connection string (which works fine at the moment):

"Data Source=.\SQLEXPRESS;AttachDbFilename='|DataDirectory|test.mdf';Integrated Security=True;User Instance=True"

However, I would like to make my connection string:

"Data Source=.\SQLEXPRESS;AttachDbFilename='|DataDirectory|..\..\Database\test.mdf';Integrated Security=True;User Instance=True"

But no matter what combination I try (including not using DataDirectory at all), I cannot seem to open the database using the relative path.

Can someone please assist/clarify?

Thanks,
Sean H.

Hi,

DataDirectory is specifically restricted to only allow access to files in the directory pointed to by the DataDirectory value or any of its subdirectories, but not directories up in the chain.

This is to prevent security issues such as those common in older web servers where you could navigate the server file-system by doing something like http://www.mywebsite.com/..\..\..\etc\passwords

-pablo|||When you say "the directory pointed to by the DataDirectory value " what exactly is that? In other words, what is this value and where can I set/change it?

Thanks - Daniel|||

you can change:

AppDomain.CurrentDomain.setData(“DataDirectory”,”C:\newPath\”);