IBM DB2 UDB for iSeries .NET data provider

Hello:
Is it possible to import "IBM DB2 UDB for iSeries .NET data provider" into
Reporting Services 2005? I tried to do it but was unsuccessful. I'm
attempting to access data on our IBM i-Series(AS/400) and I need to pass
parameters in my datasets. I appreciate any assistance you can give me.
Best regardsYou can use the OleDB provider instead of the .NET for DB2 and/or DB/400.
The OleDB driver should come with your iSeries Access installer. The IBM
DB2 UDB provider is not specific to DB/400 though whereas the one provided
with iSeries Access is. I've encounter a few oddities when using the
regular DB2 driver pointing to DB/400. You can also try the Microsoft DB2
OleDB provider which can be found here:
http://download.microsoft.com/download/2/7/c/27c60d49-6dbe-423e-9a9e-1c873f2
69484/DB2OLEDB.exe
If you don't use OleDB or ODBC as your connection provider you will have to
create a Reporting Services Data Extension to have the .NET DB2 Provider
show up in the list.
Here are some links to example OleDB connection strings for DB2 / DB/400
you can try:
http://www.connectionstrings.com/?carrier=ibmdb2
http://www.connectionstrings.com/?carrier=as400
The connection string for the Microsoft DB2 provider should be included in
the download.
--
Chris Alton, Microsoft Corp.
SQL Server Developer Support Engineer
This posting is provided "AS IS" with no warranties, and confers no rights.
--
> Thread-Topic: IBM DB2 UDB for iSeries .NET data provider
> From: =?Utf-8?B?U3Rldmll?= <Stevie@.discussions.microsoft.com>
> Subject: IBM DB2 UDB for iSeries .NET data provider
> Date: Tue, 2 Oct 2007 10:50:02 -0700
> Hello:
> Is it possible to import "IBM DB2 UDB for iSeries .NET data provider"
into
> Reporting Services 2005? I tried to do it but was unsuccessful. I'm
> attempting to access data on our IBM i-Series(AS/400) and I need to pass
> parameters in my datasets. I appreciate any assistance you can give me.
> Best regards
>|||Thanks Chris, I'll give it a whirl.
"Chris Alton [MSFT]" wrote:
> You can use the OleDB provider instead of the .NET for DB2 and/or DB/400.
> The OleDB driver should come with your iSeries Access installer. The IBM
> DB2 UDB provider is not specific to DB/400 though whereas the one provided
> with iSeries Access is. I've encounter a few oddities when using the
> regular DB2 driver pointing to DB/400. You can also try the Microsoft DB2
> OleDB provider which can be found here:
> http://download.microsoft.com/download/2/7/c/27c60d49-6dbe-423e-9a9e-1c873f2
> 69484/DB2OLEDB.exe
> If you don't use OleDB or ODBC as your connection provider you will have to
> create a Reporting Services Data Extension to have the .NET DB2 Provider
> show up in the list.
> Here are some links to example OleDB connection strings for DB2 / DB/400
> you can try:
> http://www.connectionstrings.com/?carrier=ibmdb2
> http://www.connectionstrings.com/?carrier=as400
> The connection string for the Microsoft DB2 provider should be included in
> the download.
> --
> Chris Alton, Microsoft Corp.
> SQL Server Developer Support Engineer
> This posting is provided "AS IS" with no warranties, and confers no rights.
> --
> > Thread-Topic: IBM DB2 UDB for iSeries .NET data provider
> > From: =?Utf-8?B?U3Rldmll?= <Stevie@.discussions.microsoft.com>
> > Subject: IBM DB2 UDB for iSeries .NET data provider
> > Date: Tue, 2 Oct 2007 10:50:02 -0700
> >
> > Hello:
> >
> > Is it possible to import "IBM DB2 UDB for iSeries .NET data provider"
> into
> > Reporting Services 2005? I tried to do it but was unsuccessful. I'm
> > attempting to access data on our IBM i-Series(AS/400) and I need to pass
> > parameters in my datasets. I appreciate any assistance you can give me.
> >
> > Best regards
> >
> >
>|||Chris, I am having the same issue. I cannot get the IBM DB2 UDB OLE DB
Provider to work with Reporting Services. I downloaded the DB2OLEDB provider
from Microsoft but it looks like it is only for the Enterprise edition which
we do not have. I wrote a C# program and I used the IBM DB2 UDB provider and
it worked fine. I keep getting an error "Object reference not set to an
instance of an object.
"Chris Alton [MSFT]" wrote:
> You can use the OleDB provider instead of the .NET for DB2 and/or DB/400.
> The OleDB driver should come with your iSeries Access installer. The IBM
> DB2 UDB provider is not specific to DB/400 though whereas the one provided
> with iSeries Access is. I've encounter a few oddities when using the
> regular DB2 driver pointing to DB/400. You can also try the Microsoft DB2
> OleDB provider which can be found here:
> http://download.microsoft.com/download/2/7/c/27c60d49-6dbe-423e-9a9e-1c873f2
> 69484/DB2OLEDB.exe
> If you don't use OleDB or ODBC as your connection provider you will have to
> create a Reporting Services Data Extension to have the .NET DB2 Provider
> show up in the list.
> Here are some links to example OleDB connection strings for DB2 / DB/400
> you can try:
> http://www.connectionstrings.com/?carrier=ibmdb2
> http://www.connectionstrings.com/?carrier=as400
> The connection string for the Microsoft DB2 provider should be included in
> the download.
> --
> Chris Alton, Microsoft Corp.
> SQL Server Developer Support Engineer
> This posting is provided "AS IS" with no warranties, and confers no rights.
> --
> > Thread-Topic: IBM DB2 UDB for iSeries .NET data provider
> > From: =?Utf-8?B?U3Rldmll?= <Stevie@.discussions.microsoft.com>
> > Subject: IBM DB2 UDB for iSeries .NET data provider
> > Date: Tue, 2 Oct 2007 10:50:02 -0700
> >
> > Hello:
> >
> > Is it possible to import "IBM DB2 UDB for iSeries .NET data provider"
> into
> > Reporting Services 2005? I tried to do it but was unsuccessful. I'm
> > attempting to access data on our IBM i-Series(AS/400) and I need to pass
> > parameters in my datasets. I appreciate any assistance you can give me.
> >
> > Best regards
> >
> >
>|||Have you tried the AS/400 specific OleDB driver? Also, have you tried
creating an ODBC DSN and using that for your connection?
--
Chris Alton, Microsoft Corp.
SQL Server Developer Support Engineer
This posting is provided "AS IS" with no warranties, and confers no rights.
--
> Thread-Topic: IBM DB2 UDB for iSeries .NET data provider
> thread-index: AcgKrtWvPTYjJjAlScKsEj3MWa53hw==> X-WBNR-Posting-Host: 207.46.19.197
> From: =?Utf-8?B?c3RldmU=?= <steve@.discussions.microsoft.com>
> References: <8DC06CC6-C70E-40E9-A3D3-302FEC6E5F6E@.microsoft.com>
<kmqs4WSBIHA.5204@.TK2MSFTNGHUB02.phx.gbl>
> Subject: RE: IBM DB2 UDB for iSeries .NET data provider
> Date: Tue, 9 Oct 2007 12:59:00 -0700
> Chris, I am having the same issue. I cannot get the IBM DB2 UDB OLE DB
> Provider to work with Reporting Services. I downloaded the DB2OLEDB
provider
> from Microsoft but it looks like it is only for the Enterprise edition
which
> we do not have. I wrote a C# program and I used the IBM DB2 UDB provider
and
> it worked fine. I keep getting an error "Object reference not set to an
> instance of an object.
>
> "Chris Alton [MSFT]" wrote:
> > You can use the OleDB provider instead of the .NET for DB2 and/or
DB/400.
> > The OleDB driver should come with your iSeries Access installer. The
IBM
> > DB2 UDB provider is not specific to DB/400 though whereas the one
provided
> > with iSeries Access is. I've encounter a few oddities when using the
> > regular DB2 driver pointing to DB/400. You can also try the Microsoft
DB2
> > OleDB provider which can be found here:
> >
http://download.microsoft.com/download/2/7/c/27c60d49-6dbe-423e-9a9e-1c873f2
> > 69484/DB2OLEDB.exe
> >
> > If you don't use OleDB or ODBC as your connection provider you will
have to
> > create a Reporting Services Data Extension to have the .NET DB2
Provider
> > show up in the list.
> >
> > Here are some links to example OleDB connection strings for DB2 /
DB/400
> > you can try:
> > http://www.connectionstrings.com/?carrier=ibmdb2
> >
> > http://www.connectionstrings.com/?carrier=as400
> >
> > The connection string for the Microsoft DB2 provider should be included
in
> > the download.
> >
> > --
> > Chris Alton, Microsoft Corp.
> > SQL Server Developer Support Engineer
> > This posting is provided "AS IS" with no warranties, and confers no
rights.
> > --
> > > Thread-Topic: IBM DB2 UDB for iSeries .NET data provider
> > > From: =?Utf-8?B?U3Rldmll?= <Stevie@.discussions.microsoft.com>
> > > Subject: IBM DB2 UDB for iSeries .NET data provider
> > > Date: Tue, 2 Oct 2007 10:50:02 -0700
> > >
> > > Hello:
> > >
> > > Is it possible to import "IBM DB2 UDB for iSeries .NET data provider"
> > into
> > > Reporting Services 2005? I tried to do it but was unsuccessful. I'm
> > > attempting to access data on our IBM i-Series(AS/400) and I need to
pass
> > > parameters in my datasets. I appreciate any assistance you can give
me.
> > >
> > > Best regards
> > >
> > >
> >
> >
>|||Chris, I have a better question. Why can't Microsoft make 2005 SQL Reporting
Services Work with the DB2 UDB Driver if Visual Studio 2005 works fine with
the Driver? The Drivers are a part of IBM Client Access and I have the
latest version V5R4 and this driver is the specific AS400 OLEDB Driver. I did
make the connection work with ODBC but as you know it is slower than OLEDB.
Can I get the Microsoft OLEDB Driver for the Standard Edition of SQL Server
2005? If you have the name or a link to the AS/400 specific OleDB driver you
are talking about that would be great.
Steve!
"Chris Alton [MSFT]" wrote:
> Have you tried the AS/400 specific OleDB driver? Also, have you tried
> creating an ODBC DSN and using that for your connection?
> --
> Chris Alton, Microsoft Corp.
> SQL Server Developer Support Engineer
> This posting is provided "AS IS" with no warranties, and confers no rights.
> --
> > Thread-Topic: IBM DB2 UDB for iSeries .NET data provider
> > thread-index: AcgKrtWvPTYjJjAlScKsEj3MWa53hw==> > X-WBNR-Posting-Host: 207.46.19.197
> > From: =?Utf-8?B?c3RldmU=?= <steve@.discussions.microsoft.com>
> > References: <8DC06CC6-C70E-40E9-A3D3-302FEC6E5F6E@.microsoft.com>
> <kmqs4WSBIHA.5204@.TK2MSFTNGHUB02.phx.gbl>
> > Subject: RE: IBM DB2 UDB for iSeries .NET data provider
> > Date: Tue, 9 Oct 2007 12:59:00 -0700
> > Chris, I am having the same issue. I cannot get the IBM DB2 UDB OLE DB
> > Provider to work with Reporting Services. I downloaded the DB2OLEDB
> provider
> > from Microsoft but it looks like it is only for the Enterprise edition
> which
> > we do not have. I wrote a C# program and I used the IBM DB2 UDB provider
> and
> > it worked fine. I keep getting an error "Object reference not set to an
> > instance of an object.
> >
> >
> > "Chris Alton [MSFT]" wrote:
> >
> > > You can use the OleDB provider instead of the .NET for DB2 and/or
> DB/400.
> > > The OleDB driver should come with your iSeries Access installer. The
> IBM
> > > DB2 UDB provider is not specific to DB/400 though whereas the one
> provided
> > > with iSeries Access is. I've encounter a few oddities when using the
> > > regular DB2 driver pointing to DB/400. You can also try the Microsoft
> DB2
> > > OleDB provider which can be found here:
> > >
> http://download.microsoft.com/download/2/7/c/27c60d49-6dbe-423e-9a9e-1c873f2
> > > 69484/DB2OLEDB.exe
> > >
> > > If you don't use OleDB or ODBC as your connection provider you will
> have to
> > > create a Reporting Services Data Extension to have the .NET DB2
> Provider
> > > show up in the list.
> > >
> > > Here are some links to example OleDB connection strings for DB2 /
> DB/400
> > > you can try:
> > > http://www.connectionstrings.com/?carrier=ibmdb2
> > >
> > > http://www.connectionstrings.com/?carrier=as400
> > >
> > > The connection string for the Microsoft DB2 provider should be included
> in
> > > the download.
> > >
> > > --
> > > Chris Alton, Microsoft Corp.
> > > SQL Server Developer Support Engineer
> > > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> > > --
> > > > Thread-Topic: IBM DB2 UDB for iSeries .NET data provider
> > > > From: =?Utf-8?B?U3Rldmll?= <Stevie@.discussions.microsoft.com>
> > > > Subject: IBM DB2 UDB for iSeries .NET data provider
> > > > Date: Tue, 2 Oct 2007 10:50:02 -0700
> > > >
> > > > Hello:
> > > >
> > > > Is it possible to import "IBM DB2 UDB for iSeries .NET data provider"
> > > into
> > > > Reporting Services 2005? I tried to do it but was unsuccessful. I'm
> > > > attempting to access data on our IBM i-Series(AS/400) and I need to
> pass
> > > > parameters in my datasets. I appreciate any assistance you can give
> me.
> > > >
> > > > Best regards
> > > >
> > > >
> > >
> > >
> >
>|||There could be a lot of reasons why the DB2 UDB driver does not work with
Reporting Services. The driver could deviate from the OleDB spec or
countless other things. Without delving further into your problem (memory
dumps etc) I won't be able to give you much more information on it though.
You can find connection strings for the AS/400 specific OleDB provider here:
http://www.connectionstrings.com/?carrier=as400
Since you got the ODBC connection working why not at least use that in the
mean time while you try to get the OleDB working?
I'd contact IBM and see if they can give you a hand or if you need this
done quicker you can always open up a support case with us and that will
get your issue resolved much faster.
--
Chris Alton, Microsoft Corp.
SQL Server Developer Support Engineer
This posting is provided "AS IS" with no warranties, and confers no rights.
--
> Thread-Topic: IBM DB2 UDB for iSeries .NET data provider
> thread-index: AcgLUZfus8IJ/YLMRH2FGIETc13TfQ==> X-WBNR-Posting-Host: 207.46.19.168
> From: =?Utf-8?B?c3RldmU=?= <steve@.discussions.microsoft.com>
> Chris, I have a better question. Why can't Microsoft make 2005 SQL
Reporting
> Services Work with the DB2 UDB Driver if Visual Studio 2005 works fine
with
> the Driver? The Drivers are a part of IBM Client Access and I have the
> latest version V5R4 and this driver is the specific AS400 OLEDB Driver. I
did
> make the connection work with ODBC but as you know it is slower than
OLEDB.
> Can I get the Microsoft OLEDB Driver for the Standard Edition of SQL
Server
> 2005? If you have the name or a link to the AS/400 specific OleDB driver
you
> are talking about that would be great.
> Steve!
> "Chris Alton [MSFT]" wrote:
> > Have you tried the AS/400 specific OleDB driver? Also, have you tried
> > creating an ODBC DSN and using that for your connection?
> > --
> > Chris Alton, Microsoft Corp.
> > SQL Server Developer Support Engineer
> > This posting is provided "AS IS" with no warranties, and confers no
rights.
> > --
> > > Thread-Topic: IBM DB2 UDB for iSeries .NET data provider
> > > thread-index: AcgKrtWvPTYjJjAlScKsEj3MWa53hw==> > > X-WBNR-Posting-Host: 207.46.19.197
> > > From: =?Utf-8?B?c3RldmU=?= <steve@.discussions.microsoft.com>
> > > References: <8DC06CC6-C70E-40E9-A3D3-302FEC6E5F6E@.microsoft.com>
> > <kmqs4WSBIHA.5204@.TK2MSFTNGHUB02.phx.gbl>
> > > Subject: RE: IBM DB2 UDB for iSeries .NET data provider
> > > Date: Tue, 9 Oct 2007 12:59:00 -0700
> > > Chris, I am having the same issue. I cannot get the IBM DB2 UDB OLE
DB
> > > Provider to work with Reporting Services. I downloaded the DB2OLEDB
> > provider
> > > from Microsoft but it looks like it is only for the Enterprise
edition
> > which
> > > we do not have. I wrote a C# program and I used the IBM DB2 UDB
provider
> > and
> > > it worked fine. I keep getting an error "Object reference not set to
an
> > > instance of an object.
> > >
> > >
> > > "Chris Alton [MSFT]" wrote:
> > >
> > > > You can use the OleDB provider instead of the .NET for DB2 and/or
> > DB/400.
> > > > The OleDB driver should come with your iSeries Access installer.
The
> > IBM
> > > > DB2 UDB provider is not specific to DB/400 though whereas the one
> > provided
> > > > with iSeries Access is. I've encounter a few oddities when using
the
> > > > regular DB2 driver pointing to DB/400. You can also try the
Microsoft
> > DB2
> > > > OleDB provider which can be found here:
> > > >
> >
http://download.microsoft.com/download/2/7/c/27c60d49-6dbe-423e-9a9e-1c873f2
> > > > 69484/DB2OLEDB.exe
> > > >
> > > > If you don't use OleDB or ODBC as your connection provider you will
> > have to
> > > > create a Reporting Services Data Extension to have the .NET DB2
> > Provider
> > > > show up in the list.
> > > >
> > > > Here are some links to example OleDB connection strings for DB2 /
> > DB/400
> > > > you can try:
> > > > http://www.connectionstrings.com/?carrier=ibmdb2
> > > >
> > > > http://www.connectionstrings.com/?carrier=as400
> > > >
> > > > The connection string for the Microsoft DB2 provider should be
included
> > in
> > > > the download.
> > > >
> > > > --
> > > > Chris Alton, Microsoft Corp.
> > > > SQL Server Developer Support Engineer
> > > > This posting is provided "AS IS" with no warranties, and confers no
> > rights.
> > > > --
> > > > > Thread-Topic: IBM DB2 UDB for iSeries .NET data provider
> > > > > From: =?Utf-8?B?U3Rldmll?= <Stevie@.discussions.microsoft.com>
> > > > > Subject: IBM DB2 UDB for iSeries .NET data provider
> > > > > Date: Tue, 2 Oct 2007 10:50:02 -0700
> > > > >
> > > > > Hello:
> > > > >
> > > > > Is it possible to import "IBM DB2 UDB for iSeries .NET data
provider"
> > > > into
> > > > > Reporting Services 2005? I tried to do it but was unsuccessful.
I'm
> > > > > attempting to access data on our IBM i-Series(AS/400) and I need
to
> > pass
> > > > > parameters in my datasets. I appreciate any assistance you can
give
> > me.
> > > > >
> > > > > Best regards
> > > > >
> > > > >
> > > >
> > > >
> > >
> >
> >
>|||Chris,
I am currently using the ODBC connection but I would like to get
this issue resolved because I know there are many DB2 shops that would like
to use Reporting Services but they are having the same issue. Can I get the
Microsoft OLE DB Driver for DB2 for the Standard Edition of SQL
Server 2005?
Thanks!
"Chris Alton [MSFT]" wrote:
> There could be a lot of reasons why the DB2 UDB driver does not work with
> Reporting Services. The driver could deviate from the OleDB spec or
> countless other things. Without delving further into your problem (memory
> dumps etc) I won't be able to give you much more information on it though.
> You can find connection strings for the AS/400 specific OleDB provider here:
> http://www.connectionstrings.com/?carrier=as400
> Since you got the ODBC connection working why not at least use that in the
> mean time while you try to get the OleDB working?
> I'd contact IBM and see if they can give you a hand or if you need this
> done quicker you can always open up a support case with us and that will
> get your issue resolved much faster.
> --
> Chris Alton, Microsoft Corp.
> SQL Server Developer Support Engineer
> This posting is provided "AS IS" with no warranties, and confers no rights.
> --
> > Thread-Topic: IBM DB2 UDB for iSeries .NET data provider
> > thread-index: AcgLUZfus8IJ/YLMRH2FGIETc13TfQ==> > X-WBNR-Posting-Host: 207.46.19.168
> > From: =?Utf-8?B?c3RldmU=?= <steve@.discussions.microsoft.com>
> >
> > Chris, I have a better question. Why can't Microsoft make 2005 SQL
> Reporting
> > Services Work with the DB2 UDB Driver if Visual Studio 2005 works fine
> with
> > the Driver? The Drivers are a part of IBM Client Access and I have the
> > latest version V5R4 and this driver is the specific AS400 OLEDB Driver. I
> did
> > make the connection work with ODBC but as you know it is slower than
> OLEDB.
> > Can I get the Microsoft OLEDB Driver for the Standard Edition of SQL
> Server
> > 2005? If you have the name or a link to the AS/400 specific OleDB driver
> you
> > are talking about that would be great.
> > Steve!
> >
> > "Chris Alton [MSFT]" wrote:
> >
> > > Have you tried the AS/400 specific OleDB driver? Also, have you tried
> > > creating an ODBC DSN and using that for your connection?
> > > --
> > > Chris Alton, Microsoft Corp.
> > > SQL Server Developer Support Engineer
> > > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> > > --
> > > > Thread-Topic: IBM DB2 UDB for iSeries .NET data provider
> > > > thread-index: AcgKrtWvPTYjJjAlScKsEj3MWa53hw==> > > > X-WBNR-Posting-Host: 207.46.19.197
> > > > From: =?Utf-8?B?c3RldmU=?= <steve@.discussions.microsoft.com>
> > > > References: <8DC06CC6-C70E-40E9-A3D3-302FEC6E5F6E@.microsoft.com>
> > > <kmqs4WSBIHA.5204@.TK2MSFTNGHUB02.phx.gbl>
> > > > Subject: RE: IBM DB2 UDB for iSeries .NET data provider
> > > > Date: Tue, 9 Oct 2007 12:59:00 -0700
> > > > Chris, I am having the same issue. I cannot get the IBM DB2 UDB OLE
> DB
> > > > Provider to work with Reporting Services. I downloaded the DB2OLEDB
> > > provider
> > > > from Microsoft but it looks like it is only for the Enterprise
> edition
> > > which
> > > > we do not have. I wrote a C# program and I used the IBM DB2 UDB
> provider
> > > and
> > > > it worked fine. I keep getting an error "Object reference not set to
> an
> > > > instance of an object.
> > > >
> > > >
> > > > "Chris Alton [MSFT]" wrote:
> > > >
> > > > > You can use the OleDB provider instead of the .NET for DB2 and/or
> > > DB/400.
> > > > > The OleDB driver should come with your iSeries Access installer.
> The
> > > IBM
> > > > > DB2 UDB provider is not specific to DB/400 though whereas the one
> > > provided
> > > > > with iSeries Access is. I've encounter a few oddities when using
> the
> > > > > regular DB2 driver pointing to DB/400. You can also try the
> Microsoft
> > > DB2
> > > > > OleDB provider which can be found here:
> > > > >
> > >
> http://download.microsoft.com/download/2/7/c/27c60d49-6dbe-423e-9a9e-1c873f2
> > > > > 69484/DB2OLEDB.exe
> > > > >
> > > > > If you don't use OleDB or ODBC as your connection provider you will
> > > have to
> > > > > create a Reporting Services Data Extension to have the .NET DB2
> > > Provider
> > > > > show up in the list.
> > > > >
> > > > > Here are some links to example OleDB connection strings for DB2 /
> > > DB/400
> > > > > you can try:
> > > > > http://www.connectionstrings.com/?carrier=ibmdb2
> > > > >
> > > > > http://www.connectionstrings.com/?carrier=as400
> > > > >
> > > > > The connection string for the Microsoft DB2 provider should be
> included
> > > in
> > > > > the download.
> > > > >
> > > > > --
> > > > > Chris Alton, Microsoft Corp.
> > > > > SQL Server Developer Support Engineer
> > > > > This posting is provided "AS IS" with no warranties, and confers no
> > > rights.
> > > > > --
> > > > > > Thread-Topic: IBM DB2 UDB for iSeries .NET data provider
> > > > > > From: =?Utf-8?B?U3Rldmll?= <Stevie@.discussions.microsoft.com>
> > > > > > Subject: IBM DB2 UDB for iSeries .NET data provider
> > > > > > Date: Tue, 2 Oct 2007 10:50:02 -0700
> > > > > >
> > > > > > Hello:
> > > > > >
> > > > > > Is it possible to import "IBM DB2 UDB for iSeries .NET data
> provider"
> > > > > into
> > > > > > Reporting Services 2005? I tried to do it but was unsuccessful.
> I'm
> > > > > > attempting to access data on our IBM i-Series(AS/400) and I need
> to
> > > pass
> > > > > > parameters in my datasets. I appreciate any assistance you can
> give
> > > me.
> > > > > >
> > > > > > Best regards
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > >
> > >
> >
>|||Unfortunately there isn't one to my knowledge. The DB2 provider is only for
Enterprise. Not sure why this is though.
I found an article that gives you an example of how to add the .NET data
provider though.
http://msdn2.microsoft.com/en-us/library/bb326409.aspx
and
This article that talks about data providers more in depth.
http://msdn2.microsoft.com/en-us/library/ms159219.aspx
--
Chris Alton, Microsoft Corp.
SQL Server Developer Support Engineer
This posting is provided "AS IS" with no warranties, and confers no rights.
--
> Thread-Topic: IBM DB2 UDB for iSeries .NET data provider
> thread-index: AcgME3y8WWy6aoDyQxmv6iFkPWLKRQ==> X-WBNR-Posting-Host: 207.46.193.207
> From: =?Utf-8?B?c3RldmU=?= <steve@.discussions.microsoft.com>
> References: <8DC06CC6-C70E-40E9-A3D3-302FEC6E5F6E@.microsoft.com>
<kmqs4WSBIHA.5204@.TK2MSFTNGHUB02.phx.gbl>
<27152120-17C7-4C3C-8514-B778DF8C0267@.microsoft.com>
<8NOZs50CIHA.5204@.TK2MSFTNGHUB02.phx.gbl>
<8A2566B0-4DBA-414F-A9A6-95D5B882A72A@.microsoft.com>
<$dmrTkADIHA.4200@.TK2MSFTNGHUB02.phx.gbl>
> Subject: RE: IBM DB2 UDB for iSeries .NET data provider
> Date: Thu, 11 Oct 2007 07:32:01 -0700
> Lines: 157
> Chris,
> I am currently using the ODBC connection but I would like to get
> this issue resolved because I know there are many DB2 shops that would
like
> to use Reporting Services but they are having the same issue. Can I get
the
> Microsoft OLE DB Driver for DB2 for the Standard Edition of SQL
> Server 2005?
> Thanks!
>
> "Chris Alton [MSFT]" wrote:
> > There could be a lot of reasons why the DB2 UDB driver does not work
with
> > Reporting Services. The driver could deviate from the OleDB spec or
> > countless other things. Without delving further into your problem
(memory
> > dumps etc) I won't be able to give you much more information on it
though.
> > You can find connection strings for the AS/400 specific OleDB provider
here:
> > http://www.connectionstrings.com/?carrier=as400
> >
> > Since you got the ODBC connection working why not at least use that in
the
> > mean time while you try to get the OleDB working?
> >
> > I'd contact IBM and see if they can give you a hand or if you need this
> > done quicker you can always open up a support case with us and that
will
> > get your issue resolved much faster.
> > --
> > Chris Alton, Microsoft Corp.
> > SQL Server Developer Support Engineer
> > This posting is provided "AS IS" with no warranties, and confers no
rights.
> > --
> > > Thread-Topic: IBM DB2 UDB for iSeries .NET data provider
> > > thread-index: AcgLUZfus8IJ/YLMRH2FGIETc13TfQ==> > > X-WBNR-Posting-Host: 207.46.19.168
> > > From: =?Utf-8?B?c3RldmU=?= <steve@.discussions.microsoft.com>
> > >
> > > Chris, I have a better question. Why can't Microsoft make 2005 SQL
> > Reporting
> > > Services Work with the DB2 UDB Driver if Visual Studio 2005 works
fine
> > with
> > > the Driver? The Drivers are a part of IBM Client Access and I have
the
> > > latest version V5R4 and this driver is the specific AS400 OLEDB
Driver. I
> > did
> > > make the connection work with ODBC but as you know it is slower than
> > OLEDB.
> > > Can I get the Microsoft OLEDB Driver for the Standard Edition of SQL
> > Server
> > > 2005? If you have the name or a link to the AS/400 specific OleDB
driver
> > you
> > > are talking about that would be great.
> > > Steve!
> > >
> > > "Chris Alton [MSFT]" wrote:
> > >
> > > > Have you tried the AS/400 specific OleDB driver? Also, have you
tried
> > > > creating an ODBC DSN and using that for your connection?
> > > > --
> > > > Chris Alton, Microsoft Corp.
> > > > SQL Server Developer Support Engineer
> > > > This posting is provided "AS IS" with no warranties, and confers no
> > rights.
> > > > --
> > > > > Thread-Topic: IBM DB2 UDB for iSeries .NET data provider
> > > > > thread-index: AcgKrtWvPTYjJjAlScKsEj3MWa53hw==> > > > > X-WBNR-Posting-Host: 207.46.19.197
> > > > > From: =?Utf-8?B?c3RldmU=?= <steve@.discussions.microsoft.com>
> > > > > References: <8DC06CC6-C70E-40E9-A3D3-302FEC6E5F6E@.microsoft.com>
> > > > <kmqs4WSBIHA.5204@.TK2MSFTNGHUB02.phx.gbl>
> > > > > Subject: RE: IBM DB2 UDB for iSeries .NET data provider
> > > > > Date: Tue, 9 Oct 2007 12:59:00 -0700
> > > > > Chris, I am having the same issue. I cannot get the IBM DB2 UDB
OLE
> > DB
> > > > > Provider to work with Reporting Services. I downloaded the
DB2OLEDB
> > > > provider
> > > > > from Microsoft but it looks like it is only for the Enterprise
> > edition
> > > > which
> > > > > we do not have. I wrote a C# program and I used the IBM DB2 UDB
> > provider
> > > > and
> > > > > it worked fine. I keep getting an error "Object reference not set
to
> > an
> > > > > instance of an object.
> > > > >
> > > > >
> > > > > "Chris Alton [MSFT]" wrote:
> > > > >
> > > > > > You can use the OleDB provider instead of the .NET for DB2
and/or
> > > > DB/400.
> > > > > > The OleDB driver should come with your iSeries Access
installer.
> > The
> > > > IBM
> > > > > > DB2 UDB provider is not specific to DB/400 though whereas the
one
> > > > provided
> > > > > > with iSeries Access is. I've encounter a few oddities when
using
> > the
> > > > > > regular DB2 driver pointing to DB/400. You can also try the
> > Microsoft
> > > > DB2
> > > > > > OleDB provider which can be found here:
> > > > > >
> > > >
> >
http://download.microsoft.com/download/2/7/c/27c60d49-6dbe-423e-9a9e-1c873f2
> > > > > > 69484/DB2OLEDB.exe
> > > > > >
> > > > > > If you don't use OleDB or ODBC as your connection provider you
will
> > > > have to
> > > > > > create a Reporting Services Data Extension to have the .NET DB2
> > > > Provider
> > > > > > show up in the list.
> > > > > >
> > > > > > Here are some links to example OleDB connection strings for DB2
/
> > > > DB/400
> > > > > > you can try:
> > > > > > http://www.connectionstrings.com/?carrier=ibmdb2
> > > > > >
> > > > > > http://www.connectionstrings.com/?carrier=as400
> > > > > >
> > > > > > The connection string for the Microsoft DB2 provider should be
> > included
> > > > in
> > > > > > the download.
> > > > > >
> > > > > > --
> > > > > > Chris Alton, Microsoft Corp.
> > > > > > SQL Server Developer Support Engineer
> > > > > > This posting is provided "AS IS" with no warranties, and
confers no
> > > > rights.
> > > > > > --
> > > > > > > Thread-Topic: IBM DB2 UDB for iSeries .NET data provider
> > > > > > > From: =?Utf-8?B?U3Rldmll?= <Stevie@.discussions.microsoft.com>
> > > > > > > Subject: IBM DB2 UDB for iSeries .NET data provider
> > > > > > > Date: Tue, 2 Oct 2007 10:50:02 -0700
> > > > > > >
> > > > > > > Hello:
> > > > > > >
> > > > > > > Is it possible to import "IBM DB2 UDB for iSeries .NET data
> > provider"
> > > > > > into
> > > > > > > Reporting Services 2005? I tried to do it but was
unsuccessful.
> > I'm
> > > > > > > attempting to access data on our IBM i-Series(AS/400) and I
need
> > to
> > > > pass
> > > > > > > parameters in my datasets. I appreciate any assistance you
can
> > give
> > > > me.
> > > > > > >
> > > > > > > Best regards
> > > > > > >
> > > > > > >
> > > > > >
> > > > > >
> > > > >
> > > >
> > > >
> > >
> >
> >
>

IAuthorizationExtension and RoleProvider

We have developed a custom asp.net 2.0 RoleProvider to Authorize access to
different areas of our web app so that administrators of our application
could control access rather than IT staff. The custom RoleProvider reads
user and role information from a SQLServer 2005 Database. We are not using a
custom MembershipProvider. We are now trying to integrate Reporting Services
2005 with the Web App. I want the Roles used to authorize access to reports
be the same roles that are used to authorize access to the pages in my web
app. I would like to have reporting services use my custom RoleProvider. It
is my understanding that I need to create a class that implements
IAuthorizationExtension to do this.
I have the example from the Teo Lachev book. Not exacly what i needed, but
of figre if I could get that one running, I could modify it to call my custom
RoleProvider. When I implemented the sample from the book, I get an
exceiption when it calls the BinaryFormatter Deserialize method to
deserialize SecDesc item that was passed to GetAccess. The error message i
get is 'The input stream is not in a valid binary format. The starting
contents (in bytes) are :06-05-00-9c...'
Can anyone how a custom Authorization Extension is supposed to use the
Security descriptors it gets from RS?
Has anyone managed to use asp.net 2.0 RoleProviders with RS2005? Is there
any good documentation on how to implement and deploy an
IAuthorizationExtension? Should I be taking another approach?
It Seems to me that there ought to be [supplied by microsoft] an
implementation of the IAuthorizationExtension that calls a RoleProvider to
determine what groups a user is in, but I have not been able to find it.
Without this ability, the RoleProvider functionality is useless, because IT
staff would need to maintain AD Groups to control access to reports while an
Application Administrator would need to maintain RoleProvider Groups that
control access to my pages. It sounds like if someone wants to use
Reporting services, the should not be using a custom RoleProvider.Just in case anyone else experiences this problem in the future , I thought
I'd document what I've figured out so far. This is probably all buried in
some documentation somewhere, but I've been unable to find it.
When writing my pervious post, I had installed RS2005 and then installed a
custom Authorization Extension and was getting an error saying 'The
input stream is not in a valid binary format...'. when trying to access the
root folder of the report server. I had copied much of the code from the
Lachev book.
The root folder of the report server was created at the time I installed
RS2005. My custom Authorization Extension was not in place at the time the
root folder was created , so the ACL for the folder was created serialized
using the CreateSecurityDescriptor method of the default Authorization
Extension that comes with RS2005 (i.e. the one that works with AD groups).
I could browse to the root folder of the report server at this time with no
problem.
After I installed my custom Authorization Extension and browsed to the root
folder, RS Passed the ACL created and serialized by the default
Authorization Extension to my custom Authorization Extension. This caused
the issue. The CreateSecurityDescriptor and the CheckAccess methods work
hand-in-hand. The ACL create by CreateSecurityDescriptor of the default
Authorization Extension could not be deserialized by the GetAccess method of
my Custom Authorization Extension.
Afterwards, I created a new folder. Because this new folder was created
with my extension in place, the ACL was serialized by my own
CreateSecurityDescriptor method, and thus could be deserialized by my own
GetAccess method with no problem.
I just can't access the root folder after having installedmy extension,
because the security extension was not created by my code!.
"gover" <gover@.discussions.microsoft.com> wrote in message
news:03E811C4-6811-45EB-A071-0CAF14771C28@.microsoft.com...
> We have developed a custom asp.net 2.0 RoleProvider to Authorize access
> to
> different areas of our web app so that administrators of our application
> could control access rather than IT staff. The custom RoleProvider reads
> user and role information from a SQLServer 2005 Database. We are not using
> a
> custom MembershipProvider. We are now trying to integrate Reporting
> Services
> 2005 with the Web App. I want the Roles used to authorize access to
> reports
> be the same roles that are used to authorize access to the pages in my web
> app. I would like to have reporting services use my custom RoleProvider.
> It
> is my understanding that I need to create a class that implements
> IAuthorizationExtension to do this.
> I have the example from the Teo Lachev book. Not exacly what i needed, but
> of figre if I could get that one running, I could modify it to call my
> custom
> RoleProvider. When I implemented the sample from the book, I get an
> exceiption when it calls the BinaryFormatter Deserialize method to
> deserialize SecDesc item that was passed to GetAccess. The error message
> i
> get is 'The input stream is not in a valid binary format. The starting
> contents (in bytes) are :06-05-00-9c...'
> Can anyone how a custom Authorization Extension is supposed to use the
> Security descriptors it gets from RS?
> Has anyone managed to use asp.net 2.0 RoleProviders with RS2005? Is
> there
> any good documentation on how to implement and deploy an
> IAuthorizationExtension? Should I be taking another approach?
>
> It Seems to me that there ought to be [supplied by microsoft] an
> implementation of the IAuthorizationExtension that calls a RoleProvider
> to
> determine what groups a user is in, but I have not been able to find it.
> Without this ability, the RoleProvider functionality is useless, because
> IT
> staff would need to maintain AD Groups to control access to reports while
> an
> Application Administrator would need to maintain RoleProvider Groups that
> control access to my pages. It sounds like if someone wants to use
> Reporting services, the should not be using a custom RoleProvider.
>
>|||Did you ever figure out how to cleare the old security descriptor ?
"gover" wrote:
> Just in case anyone else experiences this problem in the future , I thought
> I'd document what I've figured out so far. This is probably all buried in
> some documentation somewhere, but I've been unable to find it.
> When writing my pervious post, I had installed RS2005 and then installed a
> custom Authorization Extension and was getting an error saying 'The
> input stream is not in a valid binary format...'. when trying to access the
> root folder of the report server. I had copied much of the code from the
> Lachev book.
> The root folder of the report server was created at the time I installed
> RS2005. My custom Authorization Extension was not in place at the time the
> root folder was created , so the ACL for the folder was created serialized
> using the CreateSecurityDescriptor method of the default Authorization
> Extension that comes with RS2005 (i.e. the one that works with AD groups).
> I could browse to the root folder of the report server at this time with no
> problem.
> After I installed my custom Authorization Extension and browsed to the root
> folder, RS Passed the ACL created and serialized by the default
> Authorization Extension to my custom Authorization Extension. This caused
> the issue. The CreateSecurityDescriptor and the CheckAccess methods work
> hand-in-hand. The ACL create by CreateSecurityDescriptor of the default
> Authorization Extension could not be deserialized by the GetAccess method of
> my Custom Authorization Extension.
> Afterwards, I created a new folder. Because this new folder was created
> with my extension in place, the ACL was serialized by my own
> CreateSecurityDescriptor method, and thus could be deserialized by my own
> GetAccess method with no problem.
> I just can't access the root folder after having installedmy extension,
> because the security extension was not created by my code!.
>
> "gover" <gover@.discussions.microsoft.com> wrote in message
> news:03E811C4-6811-45EB-A071-0CAF14771C28@.microsoft.com...
> > We have developed a custom asp.net 2.0 RoleProvider to Authorize access
> > to
> > different areas of our web app so that administrators of our application
> > could control access rather than IT staff. The custom RoleProvider reads
> > user and role information from a SQLServer 2005 Database. We are not using
> > a
> > custom MembershipProvider. We are now trying to integrate Reporting
> > Services
> > 2005 with the Web App. I want the Roles used to authorize access to
> > reports
> > be the same roles that are used to authorize access to the pages in my web
> > app. I would like to have reporting services use my custom RoleProvider.
> > It
> > is my understanding that I need to create a class that implements
> > IAuthorizationExtension to do this.
> >
> > I have the example from the Teo Lachev book. Not exacly what i needed, but
> > of figre if I could get that one running, I could modify it to call my
> > custom
> > RoleProvider. When I implemented the sample from the book, I get an
> > exceiption when it calls the BinaryFormatter Deserialize method to
> > deserialize SecDesc item that was passed to GetAccess. The error message
> > i
> > get is 'The input stream is not in a valid binary format. The starting
> > contents (in bytes) are :06-05-00-9c...'
> >
> > Can anyone how a custom Authorization Extension is supposed to use the
> > Security descriptors it gets from RS?
> >
> > Has anyone managed to use asp.net 2.0 RoleProviders with RS2005? Is
> > there
> > any good documentation on how to implement and deploy an
> > IAuthorizationExtension? Should I be taking another approach?
> >
> >
> > It Seems to me that there ought to be [supplied by microsoft] an
> > implementation of the IAuthorizationExtension that calls a RoleProvider
> > to
> > determine what groups a user is in, but I have not been able to find it.
> > Without this ability, the RoleProvider functionality is useless, because
> > IT
> > staff would need to maintain AD Groups to control access to reports while
> > an
> > Application Administrator would need to maintain RoleProvider Groups that
> > control access to my pages. It sounds like if someone wants to use
> > Reporting services, the should not be using a custom RoleProvider.
> >
> >
> >
> >
>
>

I wasnt to learn all the possible ways of accessing Data in ASP .net 2.0

Hello.

I would like to learn all the possible ways that we can access and modify data in ASP .net 2.0 programmatically.

for example one way would be like this:

StringBuilder sql = new StringBuilder();
sql.Append(" SELECT *"); //count the total number of records
sql.Append(" FROM dbo.tblJobTitle ");

//get the connection string from web services
string strConnection = new sqlconnection.SQLConnection().GetSQLConnectString(sqlconnection.SQLDSN.SCIC);

//Use the Microsoft.practices SqlDatabase object to execute our sql.
SqlDatabase SqlHelper = new SqlDatabase(strConnection);
SqlDataReader reader = (SqlDataReader)SqlHelper.ExecuteReader(CommandType.Text, sql.ToString());

the i can loop through reader and get the data OR I can create a DataSet like this:

SqlDatabase db = new SqlDatabase(strConnection);
DbCommand dbCommand = db.GetSqlStringCommand(sql.ToString());
DataSet dst = db.ExecuteDataSet(dbCommand);

I want to know if there is a comprehensive book explainaning all these possible ways to access and modify data using C# under ASP .net 2.0

I really really apreciate this.

Thank you very much.

I think you suit almost all books about ADO.NET because ADO is a part of .NET framework platform as ASP.NET. Also you can read almost all book about C# 2.0 because 100% chances that inside is chapters about ADO.|||

Common, who can read all the books in the world ?

Is there any more practical way or learning them ? Like reading a specific book or a website or MSDN or ....

Honestly I am eager to learn them and I want to learn it in a good way, start from easy stuff to more difficult and pro ways of doing it.

Thanks

|||

Hmm, if what you want is a more practical way to learn ado.net, i would suggest you : 1. Install MSDN 2.Open your browser and google "ado.net c# source code" .You will find pretty a lot of results.

Read those codes line by line and if you find anything you cannot understand, look it up in msdn. That's the way how i learn ado.net.

Hope it helps

I want urgent help

Hi,
I have created cube in sql server 2005. I want to use that cube from the front end that is using asp.net application I know that for this u require OWC(Office Web Component). I have installed that also. So can anybody help me to integrate all these stubs together.

Thanks In advance

Sach

Try this You will not need OWC. Remember OWC is not going to be supported in future.

The CellSetGrid is open source ASP.NET based OLAP browser: http://www.sqlserveranalysisservices.com/cellsetgrid/CellSetGridIntro.htm

I doesn't mean to sell you different solutions to you but If you need Web interface for Cube also try Sharepoint Services and Pivot Table web part. I found best solution, quick and free if you have Windows 2003 Server OS. But yes you will be using OWC in this case.

- Ashok

i want to make project

i want to make a database for pharmacy using sql server and VB.NET
so any body can give me illuminations
thanks in advance
george albertHire a DBA?

Specific questions, please...|||No, but I have plenty of penumbras. $2 college word of the day for Blindman's sake.|||Without looking it up, isn't the penumbra the area of partial shadow during a solar eclipse?
Not sure how you wound up with many of them...|||not quite.

http://www.m-w.com/dictionary/penumbra

it came to my mind because he used illumination. these 2 words i believe are both used in a certain court case to establish the constitutional right to privacy. that is where I got my word association from.sql

I want to know how to use ADO.net connect remote datebase

Im the new in ASP.net.
I find no way to connect remote datebase(sql server 2000).
Everybody who have ways help me.
Thank you!Sorry!!It's database not datebase!!HA~~|||::I find no way to connect remote datebase(sql server 2000).
::Everybody who have ways help me.

Would be a ton of help.

Read up on ADO.NET in the documentation.|||thank you!!
but could you give me some samples!!
i want use ASP.net to connect remote database to display data!!

I want source control for SQL Server 2000...

Hi guys'n'girls...

I currently work for a company where we develop several large ASP.NET applications which are VERY data centric. But lately we have run into a problem on our developer DB...

On the project I am working on we currenctly have approx. 10 developers working concurrently on the database. That means that we often run into errors caused by two developers working on the same stored procedure, function or trigger so the developer who adds his changes last, overwrites the modifications done by the other developer. The obvious answer is source control for the db, but as far as I can tell this is only available for stored procedures and not for functions or triggers... And even the stored procedure solution isn't very safe because it only works if every developer is editing the procedures through VS.

So what do we do? There must be some solution to this problem... And I'm pretty convinced that we are not the first company to face this problem. Are we doing it the wrong way or do you know another solution?

Thanks in advance!

Try these two urls for options but the manual way to do it is to leave the DDL coding to one or two developers working together and run a stored proc to eliminate duplicates. Hope this helps.

http://www.allisonfamily.org/bill/library/articles/vss-sql-howto/

http://www.sqlservercentral.com/products/bwunder/archiveutility/

i want help

hi

i want to check that only string in textbox. the textbox shoould enterd the strings so is there IsString() function in vb.net

plz help me....

Hi,
first of all your subject does say nothing about your problem, so many people won't read it..
secondly try to use the forum search, your problem has been discusses many times..
for example:
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=432801&SiteID=1

i want a good preview about sql dmo >> please answer ?

i want a good preview about sql dmo

what is it and how to use with vb.net applications ?

thanks

SQL DMO is an API that exposes properties of SQL server enabling you to create an application that can manipulate objects within the server. I believe that the SQL Server Management Studio was built using SQL-DMO. There is also a web-based SQL Server Manager (similar to the one for MSSQL 2000) that is being developed.

You can also use the DMO tools to develop applications that automate tasks like backing up databases on a schedule and the like.

|||Note that if you want to program for SQL Server 2005 then you need SMO, which is the .NET replacement for DMO. DMO works with SQL Server 2005 as well, but you cannot manage any of the new SQL Server 2005 features with it.

I too, cannot connect to SQL EXPRESS via different sub-nets

I have been having a problem, each of our departments is on a separate sub net e. 165.10.xx.xx where my server exists on 165.10.10.10 other worksatations upon the same sub net can access the database, where as those on a separate sub-net e.g. 165.10.12.25 cannot.

The particular data base is a an sqlexpress database, which is accessed through an access-front end utilizing ODBC for the connectivity. The user does have access rights via windows security to both the database directory, as well as the front access specific directory. When trying to set up the ODBC driver I cannot browse to the server, I can however type it in e.g. host\sqlexpress i do get through the authentication screen utilizing windows authentication. When I try to change the database from master to the application database I get an error stating database does not exist.

I have confirmed that the sql server is listening (which seemed obvious that same sub-net could get in) I have also assured the problem sub-net workstation is not running any fire wqall blocks or port filters.

--Today I logged on to the work station as myself (system administrator) and I can set up the ODBC driver under my rights, once i typed in the server name, I could see the database I needed. This gave me the idea of adding the user in the problem sub-net to the server administrators group -- which does allow the user access.

I had thought that the secure by design paradigm shift allowed access with minimal rights.

My question is this :

How do I configure the server so that the user is not required to be an administrator on it, so that access to the data can be granted, while keeping a modicum of security on the server?

Any help would be most welcome -- Thanks ;-)

Are you successfully able to connect to the server on subnet 165.10.10.10 from different subnets after making the connecting users admins on the server machine?

It seems very odd that your network connectivity problem would be solved by adding the member to the administrators group. This is not expected and is not required. Are you using IP security in your environment? What is the precise error message that you're receiving when your connection attemp fails?

To get started on how to provision login access for non-administrator users, here's a good page: http://msdn2.microsoft.com/en-us/library/ms189751.aspx. If you look around this part of the documentation you'll find more details on the minimum set of permissions needed for users to successfully login.

Hope this helps,

Vaughn

|||

Once I add the user to the Administrators group on the host machine she can connect to the database and function.

What strikes me as odd though, is that i still have to actually type in the host/sqlexpress refrence as it will not show up in the

Which server do you want to connect to?

Server -- combo box

The authentication step works

then I can see the compulsionasset database in the

Change default database to checkbox -- drop down combo

When the user is not an administrator

I still have to type the server name, authentication still works, but the database table does not show up for selection, and typing it in I get an error that it doesn't exist so that the ODBC administrator wizard will not complete.

There are no other errors.

Adding her to the administrators group did get her in though.

|||

Oh...

I have given her a login for he domain account within SQLExpress on the appropriate table...

|||

Once I add them as administrator they can connect. It does seem crippled though, usually page ione of the ODBC setup wizard lets you choose from a drop down combo box - the server, I must type the full name in as it doesn't see it. then Page 3 usually lets you change the default database -- as an administrator they can see the database -- if not they can only see the default databases master, tempdb and model. Both means appear to connect -- without error messages on page 2 of the wizard.

|||

I'm not sure if the drop down combo box and the login problem have the same root cause but here's what I'd suggest for fixing the drop down:

1) Ensure the SQL Server instance has TCP/IP enabled (it almost certainly does since remote admin connections work)

2) Ensure the SQL Browser service is running on the server machine

3) Make sure there are no firewalls (e.g. windows firewall) blocking connectivity to the sql server instance or sqlbrowser. For SQL Browser you can either add the executable or open UDP port 1433. For the name SQLExpress instance you'll need to add the process since the TCP port is dynamic unless you've manually configured it otherwise.

4) Double check that in SQL Server Configuration Manager there's not a "HideInstance" flag set to true for the SQLExpress instance

Checking all of these *should* make the instance show up in the drop down box.

|||

All of those have been checked. I can see the server from machines within the same subnet, I cannot from machines on a different subnet. Though those users can browse the host via windows networking., there are other instances that do not show up within the drop down as well, though, again they do when on the same subnet.

All firewalls are external to the network none between subnets.

Again, thanks for any and all help.

I too, cannot connect to SQL EXPRESS via different sub-nets

I have been having a problem, each of our departments is on a separate sub net e. 165.10.xx.xx where my server exists on 165.10.10.10 other worksatations upon the same sub net can access the database, where as those on a separate sub-net e.g. 165.10.12.25 cannot.

The particular data base is a an sqlexpress database, which is accessed through an access-front end utilizing ODBC for the connectivity. The user does have access rights via windows security to both the database directory, as well as the front access specific directory. When trying to set up the ODBC driver I cannot browse to the server, I can however type it in e.g. host\sqlexpress i do get through the authentication screen utilizing windows authentication. When I try to change the database from master to the application database I get an error stating database does not exist.

I have confirmed that the sql server is listening (which seemed obvious that same sub-net could get in) I have also assured the problem sub-net workstation is not running any fire wqall blocks or port filters.

--Today I logged on to the work station as myself (system administrator) and I can set up the ODBC driver under my rights, once i typed in the server name, I could see the database I needed. This gave me the idea of adding the user in the problem sub-net to the server administrators group -- which does allow the user access.

I had thought that the secure by design paradigm shift allowed access with minimal rights.

My question is this :

How do I configure the server so that the user is not required to be an administrator on it, so that access to the data can be granted, while keeping a modicum of security on the server?

Any help would be most welcome -- Thanks ;-)

Are you successfully able to connect to the server on subnet 165.10.10.10 from different subnets after making the connecting users admins on the server machine?

It seems very odd that your network connectivity problem would be solved by adding the member to the administrators group. This is not expected and is not required. Are you using IP security in your environment? What is the precise error message that you're receiving when your connection attemp fails?

To get started on how to provision login access for non-administrator users, here's a good page: http://msdn2.microsoft.com/en-us/library/ms189751.aspx. If you look around this part of the documentation you'll find more details on the minimum set of permissions needed for users to successfully login.

Hope this helps,

Vaughn

|||

Once I add the user to the Administrators group on the host machine she can connect to the database and function.

What strikes me as odd though, is that i still have to actually type in the host/sqlexpress refrence as it will not show up in the

Which server do you want to connect to?

Server -- combo box

The authentication step works

then I can see the compulsionasset database in the

Change default database to checkbox -- drop down combo

When the user is not an administrator

I still have to type the server name, authentication still works, but the database table does not show up for selection, and typing it in I get an error that it doesn't exist so that the ODBC administrator wizard will not complete.

There are no other errors.

Adding her to the administrators group did get her in though.

|||

Oh...

I have given her a login for he domain account within SQLExpress on the appropriate table...

|||

Once I add them as administrator they can connect. It does seem crippled though, usually page ione of the ODBC setup wizard lets you choose from a drop down combo box - the server, I must type the full name in as it doesn't see it. then Page 3 usually lets you change the default database -- as an administrator they can see the database -- if not they can only see the default databases master, tempdb and model. Both means appear to connect -- without error messages on page 2 of the wizard.

|||

I'm not sure if the drop down combo box and the login problem have the same root cause but here's what I'd suggest for fixing the drop down:

1) Ensure the SQL Server instance has TCP/IP enabled (it almost certainly does since remote admin connections work)

2) Ensure the SQL Browser service is running on the server machine

3) Make sure there are no firewalls (e.g. windows firewall) blocking connectivity to the sql server instance or sqlbrowser. For SQL Browser you can either add the executable or open UDP port 1433. For the name SQLExpress instance you'll need to add the process since the TCP port is dynamic unless you've manually configured it otherwise.

4) Double check that in SQL Server Configuration Manager there's not a "HideInstance" flag set to true for the SQLExpress instance

Checking all of these *should* make the instance show up in the drop down box.

|||

All of those have been checked. I can see the server from machines within the same subnet, I cannot from machines on a different subnet. Though those users can browse the host via windows networking., there are other instances that do not show up within the drop down as well, though, again they do when on the same subnet.

All firewalls are external to the network none between subnets.

Again, thanks for any and all help.

I need to install only the database

I want to download the Sql 2000 Database.
I need it only to do programing things from the .net
environment so i want to connect to the sql 2000 database.
Thanks...If you only want to work with SQL Server from dot net, consider getting the
free MSDE or SQL Server 2005 Express (the next version of MSDE).
Or you can purchase the developer edition of SQL Server 2000 for $50.
hth
Eric
"houssam hamdan" <hamdan_houssam@.hotmail.com> wrote in message
news:39ab01c4725d$cb3db380$a401280a@.phx.gbl...
> I want to download the Sql 2000 Database.
> I need it only to do programing things from the .net
> environment so i want to connect to the sql 2000 database.
> Thanks...

I need some advice before starting VB/SQL Project

I am just in the process of learning VB.NET so that I can upsize an access database that I developed for my company.

I need advise on two subjects:
First, I am going to be starting a new VB.NET / SQL project using MSDE installed on my development computer. What do I need to do to allow me to easily deploy the program on several workstations and a dedicated server once development is finished?

Second, I would like to have a transitional period where both the VBA in the current MDB and the new VB.NET project access the same data. The one solution that I came up with was creating queries on the SQL server that pointed to the MDB, then once I am comfortable with the VB.NET end of things I would transfer the data it's self to the SQL server and change the queries to point to the new data location... However I have no idea weather or not this will work or if it is even close to being a good idea.

Any advice would be greatly appreciated.I wouldn't waste my time on developing in Access and then moving to SQL Server. Just start with the latter!|||Michael Kaiser

Brett Smith

Geez I thought I was unique...

Anyway, take rdjabarov's advice...

You can easily set up an Access mdb and link the sql server tables to it...

Don't bother with Jet...or don't you have sql server installed yet?

Or is it an existing application already?

How big is the database (or how big will it be?)

Also, you don't mention anything about stored procedures...

Do you plan on using them...it would be a big plus, especially for you're design implementation...|||Absolutely. Creating queries in SQL Server that point to data in a transitional Access database is going to cause you more trouble than just building the tables in SQL Server to begin with.

Hey, I like Access a lot, but there is really no point in using it in your development if it is not going to be part of your final solution.

If your data is already in Access, then it is worth trying the Upsizing wizard. I've used it once or twice and I seem to recall that it did a decent job. If you need a transitional application, then move your existing forms and code into a Microsoft Access Data Project that is tied directly to your SQL server database.|||Unfortunately I am already up to my eyeballs in Access
This is at the moment the primary issue tracking system for the small consulting firm that I work for. Hundreds of contacts, thousands of related records... and it has only been in use for about 6 months.

What I need to do is develop the project in vb and slowly transfer functionality over as modules get debugged.

To answer the other question about stored procedures, I am definitely going to be using them.|||I'm a little confused (and that's on a good day)...

Is the data centraly located, or does each client have their own copy of the data?|||Then again, I think you would be best off if you transfered the data to Microsoft SQL server and converted your Access database into an Access Data Project while you transition to your final solution.|||The data is centrally located in a mdb that only contains tables and each client has their own MDB file which has all the forms reports and VBA and links to the tables on the main database

I won't even begin to try to explain how this configuration came about, just keep in mind that decisions like that came about via committee and I (the actual developer) was not invited.|||Well, that's not a bad configuration for a distributed Microsoft Acces solution, but it does make your upsizing more difficult.

You could still develop an Access Data Project file and distribute it to your users. If you import your forms and modules it should look identical to them. Somewhere, you are going to have to bite the administrative bullet and come up with the transition strategy that best suits your business.|||I guess at this point I am going to look into an ADP, what I was hoping to avoid was spending any more time in access when it's not in the final plan. I know that the upsize wizard will not work for most of my forms and two of my tables, but I may just have to do it and get it over with|||Just another thought, would it make senct to just migrate the data to SQL and then change the links in the client MDB files to point to the SQL tables via an ODBC connection rather than actually transfer everything over to an ADP?|||I would...

a data source is a data source...

Only downside depends on the complexity of the forms/reports...

could be a lot slower depending on the # of connections opened by a form or report..|||Sure. Just make sure your security is good. Also, chances are good that you performance will be significantly slower than if you used an ADP interface.|||This is looking like my best option.

The last question on that front would be does anyone know if I like an Access MDB to SQL via ODBC can I use a SQL View for the source and meke it appear to Access to be a linked table?

I would only want to do this for two of the tables, because I would like to make some changes to the table field names.|||Yeah...check it out...they'll appear just like tables...

Just make sure that the view is updatable...otherwise it'll be a problem...|||I would get away from linked objects all together and replace them with pass-through queries to guarantee a more-or-less reasonable performance (I still don't understand why you would want to stick to Access to be your middle man.)

And to answer your question, - yes you can set a view as a source for a linked object.|||I think I am on my way!

I am sure that I will be back soon with other questions, but this should at least allow me to get my data onto SQL wile making very minor changes to the current Access database.

I need help with what appears to be a botched install.

Okay, i'm learning VB.NET (and having quite a bit of fun with it). Well, I had the old beta version. Anyway, went away for a week and found I could no longer use it. Why?

"Beta period is over.".

Yeah, it sucks.

Well, I uninstalled it via the uninstaller. I upgraded my .NET framework, etc, and redownloaded VB.NET. Everything installed okay, save for the SQL server. It repeatedly fails.

I have hunted down and shot each component quite ruthlessly, but I don't know what beta component remains. I can't get it to install because it says I have beta components left.

And VB.NET works. Barely. I had to disable the hosting process, otherwise it gives me a message about an invalid binding handle. Not often that a Beta product works better than the production one.

The uninstall tool won't work for some reason. I'm this close to just reformatting.

Please help, I'd like to code again.

Thanks.

bump|||Hi,

if you also had SQL Server beta installed you should also deinstall SQL Server as in the Beta period the SQL Server framework version and the version of the framework VS uses had to be in line.So installing VS / SQL Server / Framework version, reboot, installing SQL Server / VS (Framework is installed with one of the two) should make your system running :-)

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

I need help with what appears to be a botched install.

Okay, i'm learning VB.NET (and having quite a bit of fun with it). Well, I had the old beta version. Anyway, went away for a week and found I could no longer use it. Why?

"Beta period is over.".

Yeah, it sucks.

Well, I uninstalled it via the uninstaller. I upgraded my .NET framework, etc, and redownloaded VB.NET. Everything installed okay, save for the SQL server. It repeatedly fails.

I have hunted down and shot each component quite ruthlessly, but I don't know what beta component remains. I can't get it to install because it says I have beta components left.

And VB.NET works. Barely. I had to disable the hosting process, otherwise it gives me a message about an invalid binding handle. Not often that a Beta product works better than the production one.

The uninstall tool won't work for some reason. I'm this close to just reformatting.

Please help, I'd like to code again.

Thanks.

bump|||Hi,

if you also had SQL Server beta installed you should also deinstall SQL Server as in the Beta period the SQL Server framework version and the version of the framework VS uses had to be in line.So installing VS / SQL Server / Framework version, reboot, installing SQL Server / VS (Framework is installed with one of the two) should make your system running :-)

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

I need help in purchasing sql server 2005

Hi everyone, I have a web application (ASP.NET 2.0) where user will access database informations (read, write) from the application (So the SQL server is not directly exposed to the internet). These users will be authenticated from the applications itself (Not using NT/AD authentications). My question is should I get the SQL server 2005 with license(s) processor? Or should I buy the one with 5 cals ? Thanks ...

You cannot use a User CAL for a web server that access a SQL Server - you will need a device CAL instead. You therefore need to consider whether a processor license is cheaper than a license + device CAL. Your best bet is to ring up a couple of SQL Server resellers, describe your scenario and get them to quote you some prices. Then choose the best.