RE: First Connection To DB2

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?
.

Relevant Pages

  • Re: Connecting to IBM AS 400 or I5
    ... mention of a DB2 .net data provider. ... More important is there some install and ... The DB2 database which is built into the AS/400 operating system is ...
    (microsoft.public.data.odbc)
  • RE: First Connection To DB2
    ... OK here are some instructions about installing it: ... On the other hand if you want to access DB2 from your application, ... So how do I go about getting the .Net drivers properly installed? ... .Net Data Provider. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: old xp home computers
    ... > clean install ....i hope. ... utilities on the Internet for the type of BIOS you have. ... You also have hardware on your machine that requires drivers to interface ...
    (microsoft.public.windowsxp.security_admin)
  • Re: Format Fdsik XP
    ... you can install it first thing. ... patch/install the drivers you prepared with earlier. ... network drivers and finally your video card drivers. ... of the hardware drivers from here - always go to the actual manufacturers ...
    (microsoft.public.windowsxp.help_and_support)
  • Re: Problems using command format c:
    ... you can install it first thing. ... patch/install the drivers you prepared with earlier. ... network drivers and finally your video card drivers. ... of the hardware drivers from here - always go to the actual manufacturers ...
    (microsoft.public.windowsxp.help_and_support)