Relational Connection ODBC for AIX5.1 DB2V8 1

[june54]

Has anyone installed and configured this on AIX5.1 if so were did you get it ...

 

[juliane26]

From where do you really need the ODBC connection?
I mean, what exactly do you want to do ?

 

[june54]

We are activating the federated feature of UDB 8.1. Our need is to connect to and extract data from a SQLServer database (Vista). The software that is missing from our system is:
Connect ODBC Version 3.7 driver
DB2 Relational Connect, Version 8.

These software components will allow us to configure and test this feature.

Where do you get Connect ODBC?
How doe you get DB2 Relational Connect?

 

[june54]

Does anyone know were I can download ODBC drivers for AIX5.1 DB2V8

 

[juliane26]

In Version 8 Relational Connect and other have been replaced by DB2 Information Integrator for Data.
What you need are the relational wrappers, included in the the IIRW component.

For the SQLServer access: which SQL Server are you talking about?
For Sybase I would suggest you install the sybase client on your machine, and create a sybase wrapper.

(I guess in earlier times when there was only one SQL Server that would even have worked with MS)

For Microsoft, and I guess that is what you want to do, that is not too simple. They do have
- an JDBC driver
- XML and HTTP (Webservices)
- DBLibrary - some kind of client software
For federation you probably can do the XML Stuff (but you will need an HTTP server), I am not sure whether the DBibrary supports something like ODBC, but this is very well possible. I have no experience with that.

Where to get AIX ODBC Connect you should find in the AIX Supplements, i never had to do that myself.

 

[june54]

Thanks for the info . I will let you know how it turns out ...