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:[EMAIL PROTECTED] Sent: Wednesday, January 25, 2006 11:10 AM To: Jeff Urlwin; [email protected] Cc: [EMAIL PROTECTED] Subject: 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 <[EMAIL PROTECTED]> 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:[EMAIL PROTECTED] > Sent: Monday, January 23, 2006 2:24 PM > To: Jeff Urlwin; [email protected] > Cc: [EMAIL PROTECTED] > 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 <[EMAIL PROTECTED]> > wrote: > >> Can you please re-send the output of Makefile.PL? >> >> Jeff >> >> >> -----Original Message----- >> From: Mark Nettleingham [mailto:[EMAIL PROTECTED] >> Sent: Friday, January 20, 2006 8:45 AM >> To: Jeff Urlwin; [email protected] >> Cc: [EMAIL PROTECTED] >> 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 <[EMAIL PROTECTED]> >> 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:[EMAIL PROTECTED] >>> Sent: Thursday, January 19, 2006 3:27 PM >>> To: [email protected] >>> Cc: [EMAIL PROTECTED] >>> 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/DBD/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/
