#!/usr/bin/perl
use strict;
use warnings;
use DBIx::SQLEngine;

eval {
my $engine = DBIx::SQLEngine->new'DBI:mssql:MyDB:127.0.0.1', 'sa', 'sq
+l',
{
RaiseError => 1,
ShowErrorStatement => 1,
}
);
#... and so fourth....
[download]

DBIx::SQLEngine is just a wrapper. In order to use that, the OP still needs the ODBC driver AFAICT.

A quick Google search turned up an article called Connecting to MS SQL Server from Unix, which covers several ways of dealing with SQL Server from a Unix environment by using Perl.

HTH

Thanks for all your replies,
I think the best way is to buy a commercial driver...
The DBIx thing doesn't work without any driver and to use JDBC is not my way :-)

Thx anyway.

Cheers physi

-----------------------------------
--the good, the bad and the physi--
-----------------------------------

I'm not familiar with the Microsoft product but I guess it supports JDBC connections drivers. If it does, enable the JDBC service on the server side then use DBD::JDBC on the client (Unix) side. In order to use DBD::JDBC you need Java to run a middleware program together with the drivers from Microsoft (not necessarily on the same computer with the client application). Just my 2c.

Update: Another idea: run DBI::ProxyServer on a windows machine with MS SQL ODBC drivers and use DBD::Proxy on the Unix client.

Update 2: Mixed up client-server stuff...

Michael