First Connection To DB2

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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…
 
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 said:
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 said:
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?
Click to expand...
Click to expand...
 
OK here are some instructions about installing it:
http://publib.boulder.ibm.com/infoc....ibm.db2.udb.dndp.doc/htm/frlrfIBMDataDB2.htm

Did you look into the GAC folder (Windows\assembly)?
Also you try to access DB2 on iSeries? If so what version is (V5R3 or less)?

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 said:
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 said:
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?
Click to expand...
Click to expand...
Click to expand...
 
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?
 
So one step at the time
DB runs on 2 kind of machines:
· iSeries (a custom IBM machine) from one version up all have the .Net
provider
· or Windows or Linux on PC
The 2 versions have subtle differences among them, and how do you access
them, and what you need to have on your computer to access them and so on.

..Net 2.0 is backward compatible with 1.1 so is real problem if the .Net Data
Provider is done with .Net 11 (some performance issues and so but not
incompatibility).

About the rest the Database Explorer from Visual Studio maybe you will never
be able to see all the information about the tables etc… The Visual does not
know to my knowledge the queries needed to get these information’s from DB2,
know SQL Server, limited Oracle… Is not a problem with the provider but one
with the system views queries.
But programmatically you can do what ever you wish if you have “aâ€
connection. You can use a separate tool to explore the database instead
Visual (most Oracle developers I know for example avoid using the Visual
Database Explorer and use Toad) and the programming is all done in Visual.
 
Back
Top