[Melbourne-pm] Connecting to a MSSQL 2005 server

David Dick ddick at iinet.net.au
Wed Jun 9 21:23:38 PDT 2010


On 10/06/10 14:03, Guy Morton wrote:
> Hello fellow perlers,
>
> I am having trouble getting DBI to connect to an MSSQL 2005 server.
>
> I have FreeTDS installed.
>
> I have DBD::Sybase installed:
>
> $ perl -MDBI -e 'DBI->installed_versions;'
>    Perl            : 5.008008	(i386-freebsd-64int)
>    OS              : freebsd	(6.1-release)
>    DBI             : 1.607
>    DBD::mysql      : 4.010
>    DBD::Sybase     : 1.02
>    DBD::Sponge     : 12.010002
>    DBD::SQLite2    : 0.33
>    DBD::SQLite     : 1.14
>    DBD::Proxy      : install_driver(Proxy) failed: Can't locate RPC/PlClient.pm in @INC
>    DBD::Gofer      : 0.011565
>    DBD::File       : 0.35
>    DBD::ExampleP   : 12.010007
>    DBD::DBM        : 0.03
>
> So, it *kinda* looks like this:
>
> use DBI;
>
> my $dbh = DBI->connect("dbi:Sybase:server=myserver", 'user','pass') || die $DBI::errstr;
>
> should work, but it generates this error instead:
>
> DBI connect('server=myserver','user',...) failed: (no error string) at mssqltest.pl line 3
> Died at mssqltest.pl line 3.
>
> Anyone got any clues they can throw me?

i have to admit that i have been working a lot with this setup.  first 
thing to do is to set the TDSDUMP environment variable, documented at 
http://www.freetds.org/userguide/logging.htm

you can either work through the issues by looking at the log, or post 
the log so we can help.


More information about the Melbourne-pm mailing list