On 03/05/11 03:47, Tim Bunce wrote:
----- Forwarded message from david_st...@mcafee.com -----
Date: Mon, 2 May 2011 18:40:11 -0700 From: david_st...@mcafee.com To:
tim.bu...@pobox.com Subject: Perl DBI on Mac OS X
Hi Tim,
Sorry to bother you. I am new to Perl DBI. I have it working fine on
my Windows 7 box.
I have installed the module on Ubuntu and tried running the same test
script but get a connection error:
DBI connect('Driver={SQL
Server};Server=[dsn];Database=[db]','[pwd]',...) failed:
[iODBC][Driver Manager]Specified driver could not be loaded
(SQL-IM003) [state was IM003 now 00000]
[iODBC][Driver Manager]dlopen({SQL Server}, 6): image not found
(SQL-00000) at testDBI.pl line 14
Can't connect to DBI:ODBC:Driver={SQL
Server};Server=[dsn];Database=[db]: [iODBC][Driver Manager]Specified
driver could not be loaded (SQL-IM003) [state was IM003 now 00000]
[iODBC][Driver Manager]dlopen({SQL Server}, 6): image not found
(SQL-00000) at testDBI.pl line 14.
Do I need to install another module? Or configure ODBC?
Thanks,
David Stiff
----- End forwarded message -----
I don't use iODBC myself or a MAC but "dlopen image not found" suggests to me that
wherever your iODBC config file points the "SQL Server" entry to the path/name of the
shared object is wrong or you don't have all the dependencies to load it (on Linux I'd run ldd on
the shared object pointed to but I don't know the equivalent on MAC).
Martin
--
Martin J. Evans
Easysoft Limited
http://www.easysoft.com