Well if you really want to avoid unixODBC, there is always DBD::Proxy. You 
would run DBD::Proxy on a windows machine to relay. 

I had to do that many years ago to talk to a data source ( Not SQL Server) that 
had an ODBC driver on windows, but no Unix/Linux option. 

I do stress the DBD::ODBC,FreeTDS,unixODBC stack a little bit and it works. 


    * Newer data types, ( datetime2, XML, nvarchar(max) ), 
    * Returning Large 200K nested data structures built with FOR XML PATH 

I do manage to mangle french characters occasionally, but my latest app's with 
a current stack work now if I don't over think it. 



From: "John Adams" <jxad...@ualr.edu> 
To: "peter" <pe...@phci.ca> 
Cc: "Kurt Jaeger" <dbi-us...@opsec.eu>, "Rob Dixon" <the.rob.di...@gmail.com>, 
"Tim Bunce" <dbi-users@perl.org> 
Sent: Thursday, 8 September, 2016 18:18:53 
Subject: Re: DBD for SQL Server 

I've never loved unixODBC. I'd go a long way to avoid it if I didn't _have_ to 
use it. 

On Wed, Sep 7, 2016 at 9:04 AM, Peter Hircock via dbi-users < 
dbi-users@perl.org > wrote: 



DBD::ODBC 

On Linux you can use FreeTDS & unixODBC , or Microsoft also has Microsoft ODBC 
Driver for SQL Server on Linux. 



From: "Kurt Jaeger" < dbi-us...@opsec.eu > 
To: "Rob Dixon" < the.rob.di...@gmail.com > 
Cc: "Tim Bunce" < dbi-users@perl.org > 
Sent: Wednesday, 7 September, 2016 10:01:40 
Subject: Re: DBD for SQL Server 

Hi! 

> I'm wondering why there is no DBD module for Microsoft SQL Server? 

MS SQL is mostly-compatible with DBD::Sybase, as far as I know. 

http://search.cpan.org/~mewp/DBD-Sybase-1.15/Sybase.pm#Using_DBD::Sybase_with_MS-SQL
 

> Is it a technical impossibility, or is it just waiting to be written? 

FreeTDS does the wire format, so if someone wants to get down 
to native stuff... 

http://lists.ibiblio.org/pipermail/freetds/ 

-- 
p...@opsec.eu +49 171 3101372 4 years to go ! 




Reply via email to