Re: DBD for SQL Server
Peter Hircock via dbi-users <[email protected]>
| Newsgroups | gmane.comp.lang.perl.modules.dbi.general |
|---|---|
| Message-ID | <[email protected]> |
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" <[email protected]>
To: "peter" <[email protected]>
Cc: "Kurt Jaeger" <[email protected]>, "Rob Dixon" <[email protected]>, "Tim Bunce" <[email protected]>
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 < [email protected] > 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" < [email protected] >
To: "Rob Dixon" < [email protected] >
Cc: "Tim Bunce" < [email protected] >
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/
--
[email protected] +49 171 3101372 4 years to go !