Unless Im wrong, I found that DBD::ODBC won't connect to MS SQL, it needs to
be coupled with both an ODBC manager and driver that can talk to MS SQL.
Its finding this driver that is the problem.
On advice from Tim Bunce I have been playing with DBI::Sybase which when
coupled with the FreeTDS libraries is rumoured to be able to connect to MS
SQL directly without a crippleware request broker sitting on the MS SQL
server. This also doesn't seem to get through the make test
I get:
Can't load '../blib/arch/auto/Sybase/DBlib/DBlib.so' for module
Sybase::DBlib: ../blib/arch/auto/Sybase/DBlib/DBlib.so
: undefined symbol: dbopen at
/usr/lib/perl5/5.00503/i386-linux/DynaLoader.pm line 169.
I checked that this library exists - and it does. Its just that there is a
".." on the front of the library path. If only I could get rid of the ".."
this thing might actially all link together.
<sigh> the Perl to MS SQL investigation continues...
> -----Original Message-----
> From: Thomas A.Lowery [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, 29 August 2001 11:03 AM
> To: [EMAIL PROTECTED]
> Subject: Re: Perl DBI for SQL Server 7 ?
>
> Ed,
> DBD::ADO and DBD::ODBC both play well with SQL Server.
>
> Tom
>
> On Tue, Aug 28, 2001 at 05:20:06PM -0400, [EMAIL PROTECTED] wrote:
> >
> > I'm looking for a Perl DBI for SQL Server 7. I'm very happy with
> > ActivePerl version 5.6.1, but I couldn't find any Perl DBI for SQL
> > Server 7 in Active State's site.
> >
> > Same for CPAN and the Perl DBI FAQ, couldn't find anything on a Perl
> > DBI for SQL Server 7.
> >
> > Thanks for your help.
> >
> > Ed
> >
> > [EMAIL PROTECTED]
>
> --
> Thomas A. Lowery
> See DBI/FAQ http://tlowery.hypermart.net
>
> _________________________________________________________
> Do You Yahoo!?
> Get your free @yahoo.com address at http://mail.yahoo.com
