NullReferenceException: Object Reference not set

Hello,
I have a strange error. When I try to add a table to the reporting
services I sometimes get errors depending on the table. I have one table
that I can view fine, but the other one is giving me a ton of problems. The
problem occurs when I go to add the table. When I select the table that I
want, and I get the error NullReferenceException:Object reference not set.
They are both as/400 files and I can't see any big differences in them. Any
ideas?
Thanks,
BrianWould you like to provide more details?
What exactly are you doing and when this message being shown?
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Brian" <javelin@.amc.com> wrote in message
news:5FC5A491-D69E-47CF-ACD7-47518BDB560F@.microsoft.com...
> Hello,
> I have a strange error. When I try to add a table to the reporting
> services I sometimes get errors depending on the table. I have one table
> that I can view fine, but the other one is giving me a ton of problems.
> The
> problem occurs when I go to add the table. When I select the table that I
> want, and I get the error NullReferenceException:Object reference not set.
> They are both as/400 files and I can't see any big differences in them.
> Any
> ideas?
> Thanks,
> Brian|||I right click and say add table. As soon as add the table I get the error.
"Lev Semenets [MSFT]" wrote:
> Would you like to provide more details?
> What exactly are you doing and when this message being shown?
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Brian" <javelin@.amc.com> wrote in message
> news:5FC5A491-D69E-47CF-ACD7-47518BDB560F@.microsoft.com...
> > Hello,
> > I have a strange error. When I try to add a table to the reporting
> > services I sometimes get errors depending on the table. I have one table
> > that I can view fine, but the other one is giving me a ton of problems.
> > The
> > problem occurs when I go to add the table. When I select the table that I
> > want, and I get the error NullReferenceException:Object reference not set.
> > They are both as/400 files and I can't see any big differences in them.
> > Any
> > ideas?
> >
> > Thanks,
> > Brian
>
>|||AS/400 is not supported by Visual Studio query designer (see
http://support.microsoft.com/default.aspx?scid=kb;en-us;811241 )
Please try using our Generic Query Designer rather than the VS query
designer.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Brian" <javelin@.amc.com> wrote in message
news:AEDBA0E9-9231-453E-9342-1D844A917B22@.microsoft.com...
>I right click and say add table. As soon as add the table I get the error.
> "Lev Semenets [MSFT]" wrote:
>> Would you like to provide more details?
>> What exactly are you doing and when this message being shown?
>> --
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "Brian" <javelin@.amc.com> wrote in message
>> news:5FC5A491-D69E-47CF-ACD7-47518BDB560F@.microsoft.com...
>> > Hello,
>> > I have a strange error. When I try to add a table to the reporting
>> > services I sometimes get errors depending on the table. I have one
>> > table
>> > that I can view fine, but the other one is giving me a ton of problems.
>> > The
>> > problem occurs when I go to add the table. When I select the table
>> > that I
>> > want, and I get the error NullReferenceException:Object reference not
>> > set.
>> > They are both as/400 files and I can't see any big differences in them.
>> > Any
>> > ideas?
>> >
>> > Thanks,
>> > Brian
>>|||What that means is that while the Visual Studio tool does not explicitly deny you from connecting to
and possibly even using other OLE-DB providers, they have done very little (if any) testing with
those providers and would generally not be willing to take bug fixes for any problems found therein.
In other words, if there are situations where it works, its luck rather than by design.
The GQD was written to help in these scenarios.
--
Thanks.
Donovan R. Smith
Software Test Lead
This posting is provided "AS IS" with no warranties, and confers no rights.
"Brian" <javelin@.amc.com> wrote in message
news:502BF2D9-8401-4C97-A5A0-9F9AE3A97D54@.microsoft.com...
> If you can not use the as/400 how come I can connect to the other as/400
> file?
> "Lev Semenets [MSFT]" wrote:
> > AS/400 is not supported by Visual Studio query designer (see
> > http://support.microsoft.com/default.aspx?scid=kb;en-us;811241 )
> > Please try using our Generic Query Designer rather than the VS query
> > designer.
> >
> > --
> > This posting is provided "AS IS" with no warranties, and confers no rights.
> >
> >
> > "Brian" <javelin@.amc.com> wrote in message
> > news:AEDBA0E9-9231-453E-9342-1D844A917B22@.microsoft.com...
> > >I right click and say add table. As soon as add the table I get the error.
> > >
> > > "Lev Semenets [MSFT]" wrote:
> > >
> > >> Would you like to provide more details?
> > >> What exactly are you doing and when this message being shown?
> > >>
> > >> --
> > >> This posting is provided "AS IS" with no warranties, and confers no
> > >> rights.
> > >>
> > >>
> > >> "Brian" <javelin@.amc.com> wrote in message
> > >> news:5FC5A491-D69E-47CF-ACD7-47518BDB560F@.microsoft.com...
> > >> > Hello,
> > >> > I have a strange error. When I try to add a table to the reporting
> > >> > services I sometimes get errors depending on the table. I have one
> > >> > table
> > >> > that I can view fine, but the other one is giving me a ton of problems.
> > >> > The
> > >> > problem occurs when I go to add the table. When I select the table
> > >> > that I
> > >> > want, and I get the error NullReferenceException:Object reference not
> > >> > set.
> > >> > They are both as/400 files and I can't see any big differences in them.
> > >> > Any
> > >> > ideas?
> > >> >
> > >> > Thanks,
> > >> > Brian
> > >>
> > >>
> > >>
> >
> >
> >|||I went to a msdn event and I was told by the microsoft guy that the reporting
services was made to work on any database, not just sql. It was supposed to
be MS's Crystal Reports. Am I understanding you correctly, are you saying
that this is not true?
Brian
"Donovan R. Smith [MSFT]" wrote:
> What that means is that while the Visual Studio tool does not explicitly deny you from connecting to
> and possibly even using other OLE-DB providers, they have done very little (if any) testing with
> those providers and would generally not be willing to take bug fixes for any problems found therein.
> In other words, if there are situations where it works, its luck rather than by design.
> The GQD was written to help in these scenarios.
> --
> Thanks.
> Donovan R. Smith
> Software Test Lead
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "Brian" <javelin@.amc.com> wrote in message
> news:502BF2D9-8401-4C97-A5A0-9F9AE3A97D54@.microsoft.com...
> > If you can not use the as/400 how come I can connect to the other as/400
> > file?
> >
> > "Lev Semenets [MSFT]" wrote:
> >
> > > AS/400 is not supported by Visual Studio query designer (see
> > > http://support.microsoft.com/default.aspx?scid=kb;en-us;811241 )
> > > Please try using our Generic Query Designer rather than the VS query
> > > designer.
> > >
> > > --
> > > This posting is provided "AS IS" with no warranties, and confers no rights.
> > >
> > >
> > > "Brian" <javelin@.amc.com> wrote in message
> > > news:AEDBA0E9-9231-453E-9342-1D844A917B22@.microsoft.com...
> > > >I right click and say add table. As soon as add the table I get the error.
> > > >
> > > > "Lev Semenets [MSFT]" wrote:
> > > >
> > > >> Would you like to provide more details?
> > > >> What exactly are you doing and when this message being shown?
> > > >>
> > > >> --
> > > >> This posting is provided "AS IS" with no warranties, and confers no
> > > >> rights.
> > > >>
> > > >>
> > > >> "Brian" <javelin@.amc.com> wrote in message
> > > >> news:5FC5A491-D69E-47CF-ACD7-47518BDB560F@.microsoft.com...
> > > >> > Hello,
> > > >> > I have a strange error. When I try to add a table to the reporting
> > > >> > services I sometimes get errors depending on the table. I have one
> > > >> > table
> > > >> > that I can view fine, but the other one is giving me a ton of problems.
> > > >> > The
> > > >> > problem occurs when I go to add the table. When I select the table
> > > >> > that I
> > > >> > want, and I get the error NullReferenceException:Object reference not
> > > >> > set.
> > > >> > They are both as/400 files and I can't see any big differences in them.
> > > >> > Any
> > > >> > ideas?
> > > >> >
> > > >> > Thanks,
> > > >> > Brian
> > > >>
> > > >>
> > > >>
> > >
> > >
> > >
>
>|||Reporting Services certainly does work against AS/400 databases (and Terradata, Oracle, Informix,
MySql, etc...). In this particular case, the Visual Studio Visual Database Tool does not support
visually creating queries against an AS/400. We included this visual query designer since it made
some tasks easier but we also made sure that - in cases where it would not work - we provided an
alternative. That alternative is our Generic Query Designer. It does not provide some of the same
visuals but it does allow you to overcome the other designer's limitations.
Also, keep in mind that this only affects the way in which you design queries. It does not affect
how you design reports based on the results of your queries. Also, the server side of Reporting
Services is extremely flexible is not impacted by this Visual Studio limitations at all.
So what they told you is correct - it will work against any database, not just SQL Server.
--
Thanks.
Donovan R. Smith
Software Test Lead
This posting is provided "AS IS" with no warranties, and confers no rights.
"Brian" <javelin@.amc.com> wrote in message
news:50DCDF13-0C11-4CC2-9026-F42E7FBBDF45@.microsoft.com...
> I went to a msdn event and I was told by the microsoft guy that the reporting
> services was made to work on any database, not just sql. It was supposed to
> be MS's Crystal Reports. Am I understanding you correctly, are you saying
> that this is not true?
> Brian
> "Donovan R. Smith [MSFT]" wrote:
> > What that means is that while the Visual Studio tool does not explicitly deny you from
connecting to
> > and possibly even using other OLE-DB providers, they have done very little (if any) testing with
> > those providers and would generally not be willing to take bug fixes for any problems found
therein.
> > In other words, if there are situations where it works, its luck rather than by design.
> >
> > The GQD was written to help in these scenarios.
> >
> > --
> > Thanks.
> >
> > Donovan R. Smith
> > Software Test Lead
> >
> > This posting is provided "AS IS" with no warranties, and confers no rights.
> >
> > "Brian" <javelin@.amc.com> wrote in message
> > news:502BF2D9-8401-4C97-A5A0-9F9AE3A97D54@.microsoft.com...
> > > If you can not use the as/400 how come I can connect to the other as/400
> > > file?
> > >
> > > "Lev Semenets [MSFT]" wrote:
> > >
> > > > AS/400 is not supported by Visual Studio query designer (see
> > > > http://support.microsoft.com/default.aspx?scid=kb;en-us;811241 )
> > > > Please try using our Generic Query Designer rather than the VS query
> > > > designer.
> > > >
> > > > --
> > > > This posting is provided "AS IS" with no warranties, and confers no rights.
> > > >
> > > >
> > > > "Brian" <javelin@.amc.com> wrote in message
> > > > news:AEDBA0E9-9231-453E-9342-1D844A917B22@.microsoft.com...
> > > > >I right click and say add table. As soon as add the table I get the error.
> > > > >
> > > > > "Lev Semenets [MSFT]" wrote:
> > > > >
> > > > >> Would you like to provide more details?
> > > > >> What exactly are you doing and when this message being shown?
> > > > >>
> > > > >> --
> > > > >> This posting is provided "AS IS" with no warranties, and confers no
> > > > >> rights.
> > > > >>
> > > > >>
> > > > >> "Brian" <javelin@.amc.com> wrote in message
> > > > >> news:5FC5A491-D69E-47CF-ACD7-47518BDB560F@.microsoft.com...
> > > > >> > Hello,
> > > > >> > I have a strange error. When I try to add a table to the reporting
> > > > >> > services I sometimes get errors depending on the table. I have one
> > > > >> > table
> > > > >> > that I can view fine, but the other one is giving me a ton of problems.
> > > > >> > The
> > > > >> > problem occurs when I go to add the table. When I select the table
> > > > >> > that I
> > > > >> > want, and I get the error NullReferenceException:Object reference not
> > > > >> > set.
> > > > >> > They are both as/400 files and I can't see any big differences in them.
> > > > >> > Any
> > > > >> > ideas?
> > > > >> >
> > > > >> > Thanks,
> > > > >> > Brian
> > > > >>
> > > > >>
> > > > >>
> > > >
> > > >
> > > >
> >
> >
> >