"OldButStillLearning" wrote:

> Hello, I have used mainly Oracle and VS, but now I am taking a crack at DB2.
> I am using DB2 Mainframe.   If I go to the DB2 software which is installed on
> my machine amd bring up "information center", it brings back the following
> information.
> ===========================================
> About DB2 Administration Tools Environment
> ===========================================
> DB2 administration tools level:
> Product identifier           SQL08015
> Level identifier             02060106
> Level                        DB2 v8.1.5.540
> Build level                  special_10709
> PTF                          WR21334
> ===================================
> Java development kit (JDK):
> Level                        IBM Corporation 1.3.1
> ===================================
>
> Is there a .Net provider for DB2?  I have gone to their web site and I can
> see a reference to a .Net provided but I am unsure if it is applicable to the
> version of DB2 which I am using.  What do I need to know to determine if I
> can/should loade the .Net provider for VS 2005?
>
> I am able to connect to DB2 using the DSN in the in the "ODBC Data Source
> Administration window".  I am also seemingly able to connect from within VS
> 2005, but when I click on (+) on the tables object, I get an error message
> saying "[ERROR] 56072 .. Function not supported by server".  Why am I getting
> this. 
>
> I have used WinSql and it provides me this information (Table names,
> attribute names, etc.) just fine(although it takes about 5 minutes to
> retrieve all of the tables), so why doesn't VS 2005?

"MrSmersh" wrote:

> So yes you can use the ODBC one. So if you have the DSN you can use the ODBC
> .Net Data Provider.
> On the server explorer you can connect but you wont be able to see the
> tables and so since the Visual does not know to interrogate the DB2 catalog
> views.
> There is a DB2 .Net Data Provider IBM.Data.DB2, if you have the client it
> should be on the system (look into GAC for this assembly).
> Exist also commercial .Net Data Providers some better some worse.
>
> If was not clear or if you have more questions, I read this forum daily…
>
>
> "OldButStillLearning" wrote:
>
> > Hello, I have used mainly Oracle and VS, but now I am taking a crack at DB2.
> > I am using DB2 Mainframe.   If I go to the DB2 software which is installed on
> > my machine amd bring up "information center", it brings back the following
> > information.
> > ===========================================
> > About DB2 Administration Tools Environment
> > ===========================================
> > DB2 administration tools level:
> > Product identifier           SQL08015
> > Level identifier             02060106
> > Level                        DB2 v8.1.5.540
> > Build level                  special_10709
> > PTF                          WR21334
> > ===================================
> > Java development kit (JDK):
> > Level                        IBM Corporation 1.3.1
> > ===================================
> >
> > Is there a .Net provider for DB2?  I have gone to their web site and I can
> > see a reference to a .Net provided but I am unsure if it is applicable to the
> > version of DB2 which I am using.  What do I need to know to determine if I
> > can/should loade the .Net provider for VS 2005?
> >
> > I am able to connect to DB2 using the DSN in the in the "ODBC Data Source
> > Administration window".  I am also seemingly able to connect from within VS
> > 2005, but when I click on (+) on the tables object, I get an error message
> > saying "[ERROR] 56072 .. Function not supported by server".  Why am I getting
> > this. 
> >
> > I have used WinSql and it provides me this information (Table names,
> > attribute names, etc.) just fine(although it takes about 5 minutes to
> > retrieve all of the tables), so why doesn't VS 2005?

"OldButStillLearning" wrote:

> Thanks for your comments.
>
> I went and looked .Net Framework 2.0 Configuration and found no entry for
> IBM.Data.DB2.  I did not mention to the person who installed the drivers that
> I also wanted to configure VS, so perhaps they needed to know this when they
> installed.  I know I have an IBM ODBC driver, as this driver show up in the
> window when you got to configure a System DSN.
>
> So how do I go about getting the .Net drivers properly installed?  Something
> that I need to download and install or is it just something I need to run
> which already exists on my workstatation?
>
> Again, thanks for your comments.
>
> "MrSmersh" wrote:
>
> > So yes you can use the ODBC one. So if you have the DSN you can use the ODBC
> > .Net Data Provider.
> > On the server explorer you can connect but you wont be able to see the
> > tables and so since the Visual does not know to interrogate the DB2 catalog
> > views.
> > There is a DB2 .Net Data Provider IBM.Data.DB2, if you have the client it
> > should be on the system (look into GAC for this assembly).
> > Exist also commercial .Net Data Providers some better some worse.
> >
> > If was not clear or if you have more questions, I read this forum daily…
> >
> >
> > "OldButStillLearning" wrote:
> >
> > > Hello, I have used mainly Oracle and VS, but now I am taking a crack at DB2.
> > > I am using DB2 Mainframe.   If I go to the DB2 software which is installed on
> > > my machine amd bring up "information center", it brings back the following
> > > information.
> > > ===========================================
> > > About DB2 Administration Tools Environment
> > > ===========================================
> > > DB2 administration tools level:
> > > Product identifier           SQL08015
> > > Level identifier             02060106
> > > Level                        DB2 v8.1.5.540
> > > Build level                  special_10709
> > > PTF                          WR21334
> > > ===================================
> > > Java development kit (JDK):
> > > Level                        IBM Corporation 1.3.1
> > > ===================================
> > >
> > > Is there a .Net provider for DB2?  I have gone to their web site and I can
> > > see a reference to a .Net provided but I am unsure if it is applicable to the
> > > version of DB2 which I am using.  What do I need to know to determine if I
> > > can/should loade the .Net provider for VS 2005?
> > >
> > > I am able to connect to DB2 using the DSN in the in the "ODBC Data Source
> > > Administration window".  I am also seemingly able to connect from within VS
> > > 2005, but when I click on (+) on the tables object, I get an error message
> > > saying "[ERROR] 56072 .. Function not supported by server".  Why am I getting
> > > this. 
> > >
> > > I have used WinSql and it provides me this information (Table names,
> > > attribute names, etc.) just fine(although it takes about 5 minutes to
> > > retrieve all of the tables), so why doesn't VS 2005?

"OldButStillLearning" wrote:

> Thanks for your response.
>
> I looked in Windows\assemblies, but did not find IBM.Data.Db2
>
> The link you provided me does not say anything about the drivers being
> compatable with 2.0 Framework.  I know the Oracle updated their drivers for
> 2.0.  So is the software compatable with 2.0?
>
> I do not know what DB2 iSeries is, so no, I have not tried to access db2
> from there.
>
> I know that the "System DSN" was created with the IBM drivers.  So when I
> use that same DSN from within VS 2005, why would it not understand how to get
> the list of tables, attributes, etc.  Your response seem to suggest that if I
> was using generic drivers VS 2005 would not understand how to access those
> characteristics.  Maybe I am just reading that incorrectly.  Will I never be
> able to access the tables, attributes, etc. from within VS 2005?
>
> So it is clear that while I do have the IBM ODBC, I do not have the .Net
> provider.  So is there something I need to down load to get these?  Do I need
> to have my current drivers uninstalled and re-installed, will this solve
> anything?
>
>
>
>