RE: Having problems setting up DBD::ODBC

Here's a warning I see:

Warning: LD_LIBRARY_PATH doesn't include /users/openlink/lib

Is that where libiodbcinst.so is located?

Jeff

-----Original Message-----
From: Mark Nettleingham [mailto:markfn@commvault.com]=20
Sent: Monday, January 23, 2006 2:24 PM
To: Jeff Urlwin; dbi-users@perl.org
Cc: jurl@cpan.org
Subject: Re: Having problems setting up DBD::ODBC

Jeff,
OK here is the output of perl Makefile.PL.

Thanks again for your help.
Mark.

On Fri, 20 Jan 2006 21:47:47 -0500, Jeff Urlwin =20
wrote:

> Can you please re-send the output of Makefile.PL?
>
> Jeff
>
>
> -----Original Message-----
> From: Mark Nettleingham [mailto:markfn@commvault.com]
> Sent: Friday, January 20, 2006 8:45 AM
> To: Jeff Urlwin; dbi-users@perl.org
> Cc: jurl@cpan.org
> Subject: 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 =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]
>> 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.
>>
>
>
>



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

Re: Having problems setting up DBD::ODBC

Jeff,
Well, I feel really silly about that one, setting LD_LIBRARY_PATH makes
things much better. However, I'm still getting failures. The current test
failure looks like this:

t/02simple.......ok 2/36DBI connect('UpdatesDatabase','gbuilder',...)
failed: [iODBC][Driver Manager]Data source name not found and no default
driver specified. Driver could not be loaded (SQL-IM002)(DBD:
db_login/SQLConnect err=-1) at t/02simple.t line 21

I have the database set up, using OpenLink's web administration I can
successfully run the test to this database. However, I still can't seem to
get DBD::ODBC to work correctly. Any ideas?

Thanks again for all your help
Mark

On Wed, 25 Jan 2006 01:06:32 -0500, Jeff Urlwin
wrote:

> Here's a warning I see:
>
> Warning: LD_LIBRARY_PATH doesn't include /users/openlink/lib
>
> Is that where libiodbcinst.so is located?
>
> Jeff
>
> -----Original Message-----
> From: Mark Nettleingham [mailto:markfn@commvault.com]
> Sent: Monday, January 23, 2006 2:24 PM
> To: Jeff Urlwin; dbi-users@perl.org
> Cc: jurl@cpan.org
> Subject: Re: Having problems setting up DBD::ODBC
>
> Jeff,
> OK here is the output of perl Makefile.PL.
>
> Thanks again for your help.
> Mark.
>
> On Fri, 20 Jan 2006 21:47:47 -0500, Jeff Urlwin
> wrote:
>
>> Can you please re-send the output of Makefile.PL?
>>
>> Jeff
>>
>>
>> -----Original Message-----
>> From: Mark Nettleingham [mailto:markfn@commvault.com]
>> Sent: Friday, January 20, 2006 8:45 AM
>> To: Jeff Urlwin; dbi-users@perl.org
>> Cc: jurl@cpan.org
>> Subject: 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/