On May 3, 5:07 am, martin.ev...@easysoft.com ("Martin J. Evans")
wrote:
> 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 Limitedhttp://www.easysoft.com
I am not explicitly specifying iODBC. I am using the same test script
from my Windows-box which has the line:
my $dsn = "DBI:ODBC:Driver={SQL Server};Server=$server;Database=
$db";
Is this correct?
Thanks,
Dave (from my personal email account)
