Thursday, March 8, 2012

.net data provider / Data processing extention

Is there somewhere a real usable sample application for this?
I found some samples, but I'm unable to do anything with it.
There are some source code files in the knowledge base. But I don't know how
to apply the Instruction on compile them.
I need realy step by step instructions for a novice. A hint for a good book
would be ok too.
(I'm wonder about the jumbs between gradients in all the documentation and
articles. Example: Open Visual Studio, select ..., to add a class do..., then
implement correct marshaling, use all the named pipes correct, find and
implement Windows APIs and thats realy all, just doit! References: Blind link
Nr 1; Blind link Nr 2; ...)There is a section in msdn describing process of creating a data extension:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsamples/htm/rss_sampleapps_v1_16g2.asp
There is also a sample that is shipped with RS:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsamples/htm/rss_sampleapps_v1_8spu.asp
I will work with you thru the steps. Let's start with trying to compile and
run the sample.
Let me know where you get the first problem.
--
Alex Mineev
Software Design Engineer. Report expressions; Code Access Security; Xml;
SQE.
This posting is provided "AS IS" with no warranties, and confers no rights
"Dev Main" <DevMain@.discussions.microsoft.com> wrote in message
news:F2E68AC2-DEFE-4593-A3AE-FD6FF3CB93F2@.microsoft.com...
> Is there somewhere a real usable sample application for this?
> I found some samples, but I'm unable to do anything with it.
> There are some source code files in the knowledge base. But I don't know
how
> to apply the Instruction on compile them.
> I need realy step by step instructions for a novice. A hint for a good
book
> would be ok too.
> (I'm wonder about the jumbs between gradients in all the documentation and
> articles. Example: Open Visual Studio, select ..., to add a class do...,
then
> implement correct marshaling, use all the named pipes correct, find and
> implement Windows APIs and thats realy all, just doit! References: Blind
link
> Nr 1; Blind link Nr 2; ...)|||Thank you very much!!!
This seems to be a good tip. I try it on monday and post a feedback.
"Alexandre Mineev [MSFT]" wrote:
> There is a section in msdn describing process of creating a data extension:
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsamples/htm/rss_sampleapps_v1_16g2.asp
> There is also a sample that is shipped with RS:
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsamples/htm/rss_sampleapps_v1_8spu.asp
> I will work with you thru the steps. Let's start with trying to compile and
> run the sample.
> Let me know where you get the first problem.
> --
> Alex Mineev
> Software Design Engineer. Report expressions; Code Access Security; Xml;
> SQE.
> This posting is provided "AS IS" with no warranties, and confers no rights
> "Dev Main" <DevMain@.discussions.microsoft.com> wrote in message
> news:F2E68AC2-DEFE-4593-A3AE-FD6FF3CB93F2@.microsoft.com...
> > Is there somewhere a real usable sample application for this?
> > I found some samples, but I'm unable to do anything with it.
> >
> > There are some source code files in the knowledge base. But I don't know
> how
> > to apply the Instruction on compile them.
> >
> > I need realy step by step instructions for a novice. A hint for a good
> book
> > would be ok too.
> >
> > (I'm wonder about the jumbs between gradients in all the documentation and
> > articles. Example: Open Visual Studio, select ..., to add a class do...,
> then
> > implement correct marshaling, use all the named pipes correct, find and
> > implement Windows APIs and thats realy all, just doit! References: Blind
> link
> > Nr 1; Blind link Nr 2; ...)
>
>|||Now I know the steps required to deploy the assembly. That's an part of the
whole way.
It is still to much for me to get this transfered so I can create a
Dataprovider for a connection to a Oracle database.
I found an article about .net dataprovider with sample files for all classes
(it's called DotNetDataProviderTemplate). I found no way to get this sample
compiled and runing. Although I'm not try to implement the reporting services
interface.
I created a new Project and added all the sample .vb files. But compile this
seems to be imposible, what ever I'm doing. Error are "Type '...' not
defiened and classes are ambiguous. But the Types are defined and the
classenames are unique.
If I would overcome all immediate barriers, I don't know how to set
permission to access a oracle database. I recognized that it is necessary to
set permission. But documented is only SQL Server, not oracle.
I'm using allways VB, a VB Sample would be great. But if the sample is
complete enough C# will be ok too. It seems, that C# is easy to understand.
If no oracle sample is available a complete sample to access a SQL Server
database will be also good.
Thank you for your effort.
"Alexandre Mineev [MSFT]" wrote:
> There is a section in msdn describing process of creating a data extension:
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsamples/htm/rss_sampleapps_v1_16g2.asp
> There is also a sample that is shipped with RS:
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsamples/htm/rss_sampleapps_v1_8spu.asp
> I will work with you thru the steps. Let's start with trying to compile and
> run the sample.
> Let me know where you get the first problem.
> --
> Alex Mineev
> Software Design Engineer. Report expressions; Code Access Security; Xml;
> SQE.
> This posting is provided "AS IS" with no warranties, and confers no rights
> "Dev Main" <DevMain@.discussions.microsoft.com> wrote in message
> news:F2E68AC2-DEFE-4593-A3AE-FD6FF3CB93F2@.microsoft.com...
> > Is there somewhere a real usable sample application for this?
> > I found some samples, but I'm unable to do anything with it.
> >
> > There are some source code files in the knowledge base. But I don't know
> how
> > to apply the Instruction on compile them.
> >
> > I need realy step by step instructions for a novice. A hint for a good
> book
> > would be ok too.
> >
> > (I'm wonder about the jumbs between gradients in all the documentation and
> > articles. Example: Open Visual Studio, select ..., to add a class do...,
> then
> > implement correct marshaling, use all the named pipes correct, find and
> > implement Windows APIs and thats realy all, just doit! References: Blind
> link
> > Nr 1; Blind link Nr 2; ...)
>
>|||Implementing RS IDbConnection, IDbCommand etc interfaces is easier than full
interfaces defined in System.Data.
The "type not found" errors are probably coming for RS interfaces. You need
to copy two dlls from reportserver/bin:
Microsoft.ReportingServices.Interfaces and ...DataExtensions.dll and you
need to add references to both of the dlls to your project
--
Alex Mineev
Software Design Engineer. Report expressions; Code Access Security; Xml;
SQE.
This posting is provided "AS IS" with no warranties, and confers no rights
"Dev Main" <DevMain@.discussions.microsoft.com> wrote in message
news:33E43A47-1654-4879-9590-0FEE8BF911BC@.microsoft.com...
> Now I know the steps required to deploy the assembly. That's an part of
the
> whole way.
> It is still to much for me to get this transfered so I can create a
> Dataprovider for a connection to a Oracle database.
> I found an article about .net dataprovider with sample files for all
classes
> (it's called DotNetDataProviderTemplate). I found no way to get this
sample
> compiled and runing. Although I'm not try to implement the reporting
services
> interface.
> I created a new Project and added all the sample .vb files. But compile
this
> seems to be imposible, what ever I'm doing. Error are "Type '...' not
> defiened and classes are ambiguous. But the Types are defined and the
> classenames are unique.
> If I would overcome all immediate barriers, I don't know how to set
> permission to access a oracle database. I recognized that it is necessary
to
> set permission. But documented is only SQL Server, not oracle.
> I'm using allways VB, a VB Sample would be great. But if the sample is
> complete enough C# will be ok too. It seems, that C# is easy to
understand.
> If no oracle sample is available a complete sample to access a SQL Server
> database will be also good.
> Thank you for your effort.
>
> "Alexandre Mineev [MSFT]" wrote:
> > There is a section in msdn describing process of creating a data
extension:
> >
> >
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsamples/htm/rss_sampleapps_v1_16g2.asp
> >
> > There is also a sample that is shipped with RS:
> >
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsamples/htm/rss_sampleapps_v1_8spu.asp
> >
> > I will work with you thru the steps. Let's start with trying to compile
and
> > run the sample.
> > Let me know where you get the first problem.
> >
> > --
> > Alex Mineev
> > Software Design Engineer. Report expressions; Code Access Security; Xml;
> > SQE.
> >
> > This posting is provided "AS IS" with no warranties, and confers no
rights
> >
> > "Dev Main" <DevMain@.discussions.microsoft.com> wrote in message
> > news:F2E68AC2-DEFE-4593-A3AE-FD6FF3CB93F2@.microsoft.com...
> > > Is there somewhere a real usable sample application for this?
> > > I found some samples, but I'm unable to do anything with it.
> > >
> > > There are some source code files in the knowledge base. But I don't
know
> > how
> > > to apply the Instruction on compile them.
> > >
> > > I need realy step by step instructions for a novice. A hint for a good
> > book
> > > would be ok too.
> > >
> > > (I'm wonder about the jumbs between gradients in all the documentation
and
> > > articles. Example: Open Visual Studio, select ..., to add a class
do...,
> > then
> > > implement correct marshaling, use all the named pipes correct, find
and
> > > implement Windows APIs and thats realy all, just doit! References:
Blind
> > link
> > > Nr 1; Blind link Nr 2; ...)
> >
> >
> >|||Thank you, but somehow it doesn't work, wath ever I try.
What exactly must be written in:
Public Sub Open() Implements IDbConnection.Open
to open the connection to database?
As mentioned in my first post I'm a novice in .net and reporting services
too. Something very simple must be wrong. And I only find help like you must
implement ...Interface. But I can't find how to do this exactly.
"Alexandre Mineev [MSFT]" wrote:
> Implementing RS IDbConnection, IDbCommand etc interfaces is easier than full
> interfaces defined in System.Data.
> The "type not found" errors are probably coming for RS interfaces. You need
> to copy two dlls from reportserver/bin:
> Microsoft.ReportingServices.Interfaces and ...DataExtensions.dll and you
> need to add references to both of the dlls to your project
> --
> Alex Mineev
> Software Design Engineer. Report expressions; Code Access Security; Xml;
> SQE.
> This posting is provided "AS IS" with no warranties, and confers no rights
> "Dev Main" <DevMain@.discussions.microsoft.com> wrote in message
> news:33E43A47-1654-4879-9590-0FEE8BF911BC@.microsoft.com...
> > Now I know the steps required to deploy the assembly. That's an part of
> the
> > whole way.
> >
> > It is still to much for me to get this transfered so I can create a
> > Dataprovider for a connection to a Oracle database.
> >
> > I found an article about .net dataprovider with sample files for all
> classes
> > (it's called DotNetDataProviderTemplate). I found no way to get this
> sample
> > compiled and runing. Although I'm not try to implement the reporting
> services
> > interface.
> > I created a new Project and added all the sample .vb files. But compile
> this
> > seems to be imposible, what ever I'm doing. Error are "Type '...' not
> > defiened and classes are ambiguous. But the Types are defined and the
> > classenames are unique.
> >
> > If I would overcome all immediate barriers, I don't know how to set
> > permission to access a oracle database. I recognized that it is necessary
> to
> > set permission. But documented is only SQL Server, not oracle.
> >
> > I'm using allways VB, a VB Sample would be great. But if the sample is
> > complete enough C# will be ok too. It seems, that C# is easy to
> understand.
> > If no oracle sample is available a complete sample to access a SQL Server
> > database will be also good.
> >
> > Thank you for your effort.
> >
> >
> > "Alexandre Mineev [MSFT]" wrote:
> >
> > > There is a section in msdn describing process of creating a data
> extension:
> > >
> > >
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsamples/htm/rss_sampleapps_v1_16g2.asp
> > >
> > > There is also a sample that is shipped with RS:
> > >
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsamples/htm/rss_sampleapps_v1_8spu.asp
> > >
> > > I will work with you thru the steps. Let's start with trying to compile
> and
> > > run the sample.
> > > Let me know where you get the first problem.
> > >
> > > --
> > > Alex Mineev
> > > Software Design Engineer. Report expressions; Code Access Security; Xml;
> > > SQE.
> > >
> > > This posting is provided "AS IS" with no warranties, and confers no
> rights
> > >
> > > "Dev Main" <DevMain@.discussions.microsoft.com> wrote in message
> > > news:F2E68AC2-DEFE-4593-A3AE-FD6FF3CB93F2@.microsoft.com...
> > > > Is there somewhere a real usable sample application for this?
> > > > I found some samples, but I'm unable to do anything with it.
> > > >
> > > > There are some source code files in the knowledge base. But I don't
> know
> > > how
> > > > to apply the Instruction on compile them.
> > > >
> > > > I need realy step by step instructions for a novice. A hint for a good
> > > book
> > > > would be ok too.
> > > >
> > > > (I'm wonder about the jumbs between gradients in all the documentation
> and
> > > > articles. Example: Open Visual Studio, select ..., to add a class
> do...,
> > > then
> > > > implement correct marshaling, use all the named pipes correct, find
> and
> > > > implement Windows APIs and thats realy all, just doit! References:
> Blind
> > > link
> > > > Nr 1; Blind link Nr 2; ...)
> > >
> > >
> > >
>
>

No comments:

Post a Comment