topic Re: Installation of ODBC driver in HP-UX in Operating System - HP-UX

Installation of ODBC driver in HP-UX

Raoof — Tue, 17 Jul 2012 08:19:40 GMT

Hello Experts,

Good Day

Need help to install ODBC driver in hp-unix 11.31 to create db link from oracle database installed on unix to mysql database.

Will be really thankful if you could please provide me the procedure to follow for it.

Regards

Re: Installation of ODBC driver in HP-UX

Raoof — Tue, 17 Jul 2012 08:56:54 GMT

Dear Experts,

Please do the needful, as am a newbie need the procedure to follow to install mysql odbc driver in hpunix 11.31

REgards

Re: Installation of ODBC driver in HP-UX

Ken Grabowski — Tue, 17 Jul 2012 16:55:09 GMT

ODBC is a MS-Windows protocol and by default is not available in UNIX. Various vendors provide ODBC compatible drivers for UNIX. They are usually compatible with most ODBC features, but rarely 100%. To my knowledge, these are all software for purchase products. Last time I looked there were no free versions out there.

I would suggest you search the internet for "ODBC for HP-UX". You should get several vendor links that will lead you to a product to use.

Re: Installation of ODBC driver in HP-UX

Raoof — Wed, 18 Jul 2012 08:29:35 GMT

Hi,

Thanks for the response.

I found drivers and the procedure to follow for the installation. I start doing installation, and was able to pass the first huddle by executing the first commande ./configure --prefix="directory/path".

But after i tried for the second and third command i.e. make and make install it failed with the errors mentioned in the attached file for the refrence.

Please have a look towards the attached fine and advice.

Awaiting for the valuable advices from you all experts.

Regards

Re: Installation of ODBC driver in HP-UX

Dennis Handly — Wed, 18 Jul 2012 14:14:11 GMT

>ld: Unknown input file type: "../DriverManager/.libs/libodbc.so"

This is the wrong architecture. What do these show:

uname -a

file ../DriverManager/.libs/libodbc.so

Re: Installation of ODBC driver in HP-UX

Ken Grabowski — Wed, 18 Jul 2012 15:19:46 GMT

That's a Linux application that your trying to compile on HP-UX. To do that you have to find all the supporting shared libraries and port them first. It's a long and involved process with no guarantee of success and definitely no support from anybody. HP use to offer a Linux to HP-UX porting kit, but those are no longer offered. Internet Express also use to include Linux development tools for HP-UX but those are also gone. If this is for a production application you have or are trying to develop, I strongly suggest you look at the commercial products on the market. Their the only reasonably stable and supported options that I know of for ODBC on HP-UX.

Re: Installation of ODBC driver in HP-UX

Raoof — Sat, 21 Jul 2012 11:40:10 GMT

I will be really thnkful to you all if you could please provide me the procedure to configure odbc setup in hpunix 11.31.

Re: Installation of ODBC driver in HP-UX

Raoof — Sat, 21 Jul 2012 11:53:28 GMT

uname -a

HP-UX mcmsdbl1 B.11.31 U ia64

Re: Installation of ODBC driver in HP-UX

Raoof — Sun, 22 Jul 2012 09:13:18 GMT

Please do the needful, need help to resolve this issue at earliest.

Re: Installation of ODBC driver in HP-UX

Raoof — Sat, 28 Jul 2012 11:51:34 GMT

Hello experts,

Please help me out to resolve my issue, its really very urgent.

Thanks & Regards

Re: Installation of ODBC driver in HP-UX

Dennis Handly — Sun, 29 Jul 2012 18:51:07 GMT

>HP-UX mcmsdbl1 B.11.31 U ia64

Again, what does this show?

$ file ../DriverManager/.libs/libodbc.so

Re: Installation of ODBC driver in HP-UX

Raoof — Mon, 30 Jul 2012 08:57:58 GMT

Hi Dennis,

Thanks for your concern. Please find attached the request file i.e. libodbc.so

Awaiting for your reply.

Regards

Re: Installation of ODBC driver in HP-UX

Dennis Handly — Sun, 29 Jul 2012 18:52:17 GMT

>Please find attached the request file i.e. libodbc.so

I didn't want the file, I wanted you to execute file(1) on that shlib to find the architecture..

Please delete your attachment.

Re: Installation of ODBC driver in HP-UX

Raoof — Mon, 30 Jul 2012 09:01:19 GMT

Hi,

File cannot be open.

mcmsdbl1@root@/u01/app/unixODBC-2.3.1>#file ../DriverManager/.libs/libodbc.so
../DriverManager/.libs/libodbc.so: cannot open

Regards

Re: Installation of ODBC driver in HP-UX

Dennis Handly — Mon, 30 Jul 2012 17:16:17 GMT

>File cannot be open.

You have to be in the right directory. Or use find(1) to find the file and then use file(1) on it.

Re: Installation of ODBC driver in HP-UX

Raoof — Tue, 31 Jul 2012 06:56:29 GMT

Please find below the result.

mcmsdbl1@root@/u01/app/unixODBC-2.3.1/DriverManager/.libs>#file libodbc.so
libodbc.so: ELF-32 executable object file - IA64

Re: Installation of ODBC driver in HP-UX

Dennis Handly — Tue, 31 Jul 2012 08:17:05 GMT

>libodbc.so: ELF-32 executable object file - IA64

This looks fine for a 32 bit executable but NOT for a shlib.

Some how you or libtool isn't passing -b to ld.

Re: Installation of ODBC driver in HP-UX

Raoof — Tue, 31 Jul 2012 09:31:14 GMT

So what will be the accurate steps i have to follow?

I will be really thankful if you could please help me to resolve this issue, its really very important and urgent too. As am a newbie to hp-ux so not much aware about the installation/configuration area.

Your help will be highly appreciated.

Thanks & Regards

Re: Installation of ODBC driver in HP-UX

Dennis Handly — Tue, 31 Jul 2012 09:41:28 GMT

>I will be really thankful if you could please help me to resolve this issue

Since I can't see what you have, not much I can do to help.

I would assume these foreign devil tools would just work. The only problem might be if you use the bundled C compiler to link. That driver will NOT create shlibs.

Do you have any warnings?

Re: Installation of ODBC driver in HP-UX

Raoof — Tue, 31 Jul 2012 11:00:29 GMT

You can please review the attached file contains the error or warning messages on running make and makeinstall commands after running successfully ./configure command.