[Melbourne-pm] Connecting to a MSSQL 2005 server

[Guy Morton]

Thanks guys. I got connected by enabling DBI_TRACE and figuring out that I am an idiot. I had so many problems getting this connection happening (starting with routing, through to configuring freetds) that I tripped over the final hurdle - incorrect password! 

*sigh*

Guy




On 10/06/2010, at 2:23 PM, David Dick wrote:

> 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.
> _______________________________________________
> Melbourne-pm mailing list
> Melbourne-pm at pm.org
> http://mail.pm.org/mailman/listinfo/melbourne-pm