[freetds] FreeTDS on Windows to MS-SQL2005 (not ODBC!) with Perl (DBD::Sybase?)

Rob Biedenharn Rob at AgileConsultingLLC.com
Wed Nov 8 17:11:16 EST 2006


I have (or more to the point my client has) a set of Perl scripts  
that run on HP-UX connecting to Sybase:

Perl
  DBI
   DBD::Sybase
    ct-lib
     Sybase ASEv11.9.2
      HP-UX B.11.11 U

This is being transitioned to run on Microsoft Windows Server 2003  
(Standard Edition) SP1 connecting to SQL Server 2005:

Perl
  DBI
   DBD::Sybase
    (ct-lib from FreeTDS?)
      MS SQL 2005
       MS Windows Server 2003 SP1

However, the platform being Windows and not some form of Unix, I'm  
not only a bit out of my element, but seem to be coming up empty  
searching the archives for help.

It appears that the ctlib isn't built on Windows (as the dblib.lib  
and FreeTDS.lib are in freetds-0.65.dev.20061107 ) and the  
FreeTDS.dll for ODBC isn't what I want either.

We've already tried going down the path of using DBD::ODBC instead,  
but are running into issues with catching errors (RAISERROR) from the  
underlying stored procedures reliably.  (There are a few places where  
SQL is used directly, but most interaction is invoking a stored  
procedure.)  There may be issues to address in the SQL itself, but as  
everything runs on Sybase, that is less desirable.  (We'd already run  
into and addressed the issue of ODBC having strictly positional  
parameters for invoking stored procedures rather than the more  
flexible named parameters used widely in the business level code.)

Since there is substantial body of Perl code that sits on top of DBI  
and DBD::Sybase, we are running into enough issues to look at  
avoiding ODBC.  We have stored procedures with multiple result sets,  
PRINT statements, a few with COMPUTE results, etc. that aren't  
handled as well through the generic ODBC protocol.

Has anyone made the DBD::Sybase connection to MS SQL 2005 with  
FreeTDS?  Note that the connection originates from Windows, not Unix  
(not cygwin, not SFU).

I've tried to find the answer in the User Guide and Reference Manual  
and scanning the past 3.5 years of list archives (and Google was  
equally unhelpful this time).  If there's not a simple answer, but  
some work that I could be guided through offline, please contact me  
directly and I post the results later.

-Rob

Rob Biedenharn		http://agileconsultingllc.com
Rob at AgileConsultingLLC.com
+1 513-295-4739




More information about the FreeTDS mailing list