RE: Having problems setting up DBD::ODBC

A few things come to mind:

Makefile.PL indicates: Warning: LD_LIBRARY_PATH doesn't include
/users/openlink, which may be a red-herring for the mis-recognized
driver.

I think the cruxt of the problem is Makefile.PL is recognizing the
driver as UnixODBC (or claims it is) -- this is probably because
Makefile.PL sees $ODBCHOME/lib/libodbc.*, whereas in the "old day",
openlink didn't deliver this file. Try hacking Makefile.PL, moving this
line:

$myodbc =3D 'iodbc'
if !$myodbc && (<$odbchome/*iodbc*> ||
<$odbchome/lib/*iodbc*>);

above this line:

$myodbc =3D 'unixodbc'
if !$myodbc && <$odbchome/lib/libodbc.*>;

That may solve your problem locally...

Jeff

-----Original Message-----
From: Mark Nettleingham [mailto:markfn@commvault.com]=20
Sent: Thursday, January 19, 2006 3:27 PM
To: dbi-users@perl.org
Cc: jurl@cpan.org
Subject: Having problems setting up DBD::ODBC

I'm currently using an evaluation copy of the OpenLink Lite
"Universal =20
Data Access Driver Suite" I have the drivers installed and the test =20
supplied by OpenLink is successful. However, when I try to test
DBD::ODBC =20
I get errors like this:

t/01base.........ok 3/5install_driver(ODBC) failed: Can't load =20
'/root/.cpanplus/5.8.5/build/DBD-ODBC-1.13/blib/arch/auto/DB D/ODBC/ODBC.
so' =20
for module DBD::ODBC: libiodbcinst.so.2: cannot open shared object file:

No such file or directory at =20
/usr/lib/perl5/5.8.5/x86_64-linux-thread-multi/DynaLoader.pm line 230.
at (eval 7) line 3
Compilation failed in require at (eval 7) line 3.
Perhaps a required shared library or dll isn't installed where expected

The library "libodbcinst.so.2" is in the library search path and
seems to =20
be set up correctly.

Attached is the requested information saved using typescript.

As usual, thanks in advance for any advice.

--=20
Using Opera's revolutionary e-mail client: http://www.opera.com/mail/

Re: Having problems setting up DBD::ODBC

Jeff,
First of all thank you for the quick responce to my plea, however, your
suggestion didn't change much. I'm still getting the same results from the
test. However, the output from perl Makefile.PL now contains the line:
"Umm, this looks like a iodbc type of driver manager." so your suggestion
had some effect.


On Fri, 20 Jan 2006 06:52:22 -0500, Jeff Urlwin
wrote:

> A few things come to mind:
>
> Makefile.PL indicates: Warning: LD_LIBRARY_PATH doesn't include
> /users/openlink, which may be a red-herring for the mis-recognized
> driver.
>
> I think the cruxt of the problem is Makefile.PL is recognizing the
> driver as UnixODBC (or claims it is) -- this is probably because
> Makefile.PL sees $ODBCHOME/lib/libodbc.*, whereas in the "old day",
> openlink didn't deliver this file. Try hacking Makefile.PL, moving this
> line:
>
> $myodbc = 'iodbc'
> if !$myodbc && (<$odbchome/*iodbc*> ||
> <$odbchome/lib/*iodbc*>);
>
> above this line:
>
> $myodbc = 'unixodbc'
> if !$myodbc && <$odbchome/lib/libodbc.*>;
>
> That may solve your problem locally...
>
> Jeff
>
> -----Original Message-----
> From: Mark Nettleingham [mailto:markfn@commvault.com]
> Sent: Thursday, January 19, 2006 3:27 PM
> To: dbi-users@perl.org
> Cc: jurl@cpan.org
> Subject: Having problems setting up DBD::ODBC
>
> I'm currently using an evaluation copy of the OpenLink Lite
> "Universal
> Data Access Driver Suite" I have the drivers installed and the test
> supplied by OpenLink is successful. However, when I try to test
> DBD::ODBC
> I get errors like this:
>
> t/01base.........ok 3/5install_driver(ODBC) failed: Can't load
> '/root/.cpanplus/5.8.5/build/DBD-ODBC-1.13/blib/arch/auto/DB D/ODBC/ODBC.
> so'
> for module DBD::ODBC: libiodbcinst.so.2: cannot open shared object file:
>
> No such file or directory at
> /usr/lib/perl5/5.8.5/x86_64-linux-thread-multi/DynaLoader.pm line 230.
> at (eval 7) line 3
> Compilation failed in require at (eval 7) line 3.
> Perhaps a required shared library or dll isn't installed where expected
>
> The library "libodbcinst.so.2" is in the library search path and
> seems to
> be set up correctly.
>
> Attached is the requested information saved using typescript.
>
> As usual, thanks in advance for any advice.
>



--
Using Opera's revolutionary e-mail client: http://www.opera.com/mail/