RE: Having problems setting up DBD::ODBC

Is there a chance you made it a "file" or some other type of DSN other
than global?

Jeff

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

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

t/02simple.......ok 2/36DBI connect('UpdatesDatabase','gbuilder',...) =20
failed: [iODBC][Driver Manager]Data source name not found and no default

driver specified. Driver could not be loaded (SQL-IM002)(DBD: =20
db_login/SQLConnect err=3D-1) at t/02simple.t line 21

I have the database set up, using OpenLink's web administration I can =20
successfully run the test to this database. However, I still can't seem
to =20
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 =20
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 =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/