Rahool,

Problem with loading ODBC IBM driver most definitely indicates an issue with your UDB DB2 client installation.

What type of client do you use, Development, Administrative or Runtime?

Make sure you are not using personal client edition.

Are you able to connect from the same workstation to any other version 7 UDB database?

Usually, the only one thing you should do when going from UDB client 8 to UDB Data Bases version 7 is to rebind all utilities (ODBC, CLI, Data Base, etc) from client 8 to the target DB you want to access. But before you can do so you should be able to connect without any problem. If you can’t establish a connection to any DB from the same workstation, then it’s definitely a client installation problem.

If you cannot connect just to version 7 UDB DB, then check your set up of catalog entries.

It also should not matter if you connecting to the database on UNIX or Z/OS or OS/390 MVS system. Proper catalog entries should be set up on your client workstation including DCS directory.

Regards,

Dmitry.


----- Original Message -----
From: [Email Address Removed] Wednesday, October 15, 2003 1:35 pm
Subject: Re: Issues with DB2 8.x

> Hi Rahool;
>
>
> I tried to connect from an UDB 8 client to a UDB 7 Connect Server
>
> (to go to a DB2 v7.1 z/Os database); this was not possible.
>
>
> From the IBM docs :
>
>
> Product and product-level support
>
> Back-level DB2 server support
>
> If you migrate your DB2 client systems to version 8 before you
> have
> migrated all of your DB2 servers to version 8, several
> restrictions and
> limitations apply. For version 8 clients to work with version 7
> servers,
> you need to configure and enable the use of DRDA(R) application
> server
> capability on the version 7 server. For information on how to do
> this,
> refer to the version 7 Installation and Configuration Supplement.
> You
> cannot access a DB2 Connect Version 7 server from a version 8
> client. When
> accessing version 7 servers from version 8 clients, there is no
> support
> available for the following:
>
> · The following data types:
> ...
> · The following security capabilities:
> ...
> · The following connections and communication protocols:
> ...
> · The following application features and tasks:
> ...
>
> There are similar limitations and restrictions for version 8 tools
> working
> with version 7 servers. The following Version 8 GUI tools,
> products, and
> Centers support only Version 8 servers:
> · Control Center
> · 1Development Center
> · Health Center (including the Web version of this center)
> · Indoubt Transaction Manager
> · Information Catalog Center (including the Web version of this
> center)
> · Journal
> · License Center
> · Satellite Administration Center
> · Spatial Extender
> · Task Center
> · Tools Settings
>
> The following Version 8 tools support Version 7 servers (with some
> restrictions):
> · Command Center (including the Web version of this center)
> Saving,
> importing, and scheduling of scripts are not supported by the
> Command
> Center.
> · Data Warehouse Center
> · Replication Center
> · The import/export configuration file function of the
> Configuration
> Assistant
> · SQL Assist
> · Visual Explain
>
> In general, any Version 8 tool that is only launched from within
> the
> navigation tree of the Control Center, or any details view based
> on such a
> tool, will not be available or accessible to Version 7 and earlier
> servers. You should consider using the Version 7 tools when
> working with
> Version 7 or earlier servers.
>
> We now use (also) UDB7 client tools to access through UDB 8
> (Connect
> server) to DB2 v7 database on the z/Os.
>
>
> Regards;
>
> Ben ten Thije
>
>
> Citeren Rahool Moray <[Email Address Removed]
> > Hi,
> >
> > Does anyone have any idea if we can connect to DB2 UDB 7.x
> databases> using the DB2 UDB 8.x tools. I recently removed my 7.x
> setup and
> installed
> > the 8.x. I am unable to connect to the 7.x databases. I use the
> JDBC ODBC
> > connections. I thought there would have been a backward
> compatibility.
> But,
> > i am unable to for some reason. is there a work around so that i can
> > connect to Db2 UDB 7.x databases. I keep on getting the error
> message.>
> > The setup routines for the IBM DB2 ODBC DRIVER ODBC driver could
> not be
> > loaded due to the system error code 126
> > Could not load the setup or translator library
> >
> > Any ideas .... please ... if anything can be done about this. I
> am new to
> > DB2.
> >
> > regards,
> >
> > --RAHool
> >
>
>
>
>
> --
> _____________________________________________________________________
> Snel en voordelig ADSL nu voor iedereen bereikbaar.
> Zon Breedband Budget voor EUR 14,95 per maand.
> Nu tijdelijk geen aansluitkosten. Bestel snel op zonnet.nl/breedband
>
>
> -------------------------------------------------------------------
> --
> PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
> To unsubscribe, e-mail: db2udbdba-[Email Address Removed] For additional commands, e-mail: db2udbdba-[Email Address Removed]
>

DB2 & UDB email list listserv db2-l LazyDBA home page