Since we are on this thread, perhaps I should mention that I have been struggling to connect to MS SQL via DBD::Sybase for the last two days. Connection to Sybase/Linux via DBD::Sybase is just fine, but connecting to MS SQL 2000 leads to problems

use DBI;                                                     
                                                              
my $data_source = "dbi:Sybase:database=SynergyOne;server=MSSQL";    
my $username = 'sa';                                                
my $auth = '';                                                        
+  
                                                                      
+  
my $dbh = DBI->connect($data_source, $username, $auth) 
or die "no connection: $DBI::errstr";
[download]

  
[tbone@MDB tbone]$ ~/bin/db-connect.pl 
DBI connect('database=SynergyOne;server=MSSQL','sa',...) failed:  at /
+home/tbone/bi\
n/db-connect.pl line 9 
no connection: OpenClient message: LAYER = (1) ORIGIN = (2) SEVERITY =
+ (6) NUMBER = (151) 
Message String: ct_connect(): user api layer: internal Client Library 
+error: A connection to the server must exist on the connection struct
+ure before this routine can
 be called. 
[tbone@MDB tbone]$
[download]

Carter's compass: I know I'm on the right track when by deleting something, I'm adding functionality