[Melbourne-pm] Connecting to a MSSQL 2005 server
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
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