Re: FreeTDS on Debian: connect to MSSQL with ODBC fails

2011/1/14 Boniforti Flavio <[email protected]>:
> Hello Frediano, I'm still at this issue :-)
>
>> I don't know OTRS, I just visited the site. It appears to be
>> a Perl application so I would
>> - install DBD::ODBC, search on Internet on how to do it for
>> your application
>
> I'm on debian sid actually, thus I think libdbd-odbc-perl is the right
> package. Can you confirm?
>

yes

>> - check DBD::ODBC, there is a odbctest.pl script in our
>> samples directory
>
> I googled around to get that script from some debian package, but it
> seems not to exist. Where do you suggest me to download it from?
>

in our distribution, or at

http://freetds.cvs.sourceforge.net/viewvc/freetds/freetds/samples/odbctest.pl?view=markup

(the file is sufficient)

Personally I execute it like

$ perl odbctest.pl dbi:ODBC:sqlexpress user password
FREETDS\SQLEXPRESS

where sqlexpress is the same as DSN argument to isql

>> - configure OTRS (from
>> http://wiki.otrs.org/index.php?title=Installation_on_Ubuntu_Lu
>> cid_Lynx_%2810.4%29
>> you should change a Config.pm file)
>
> This will be the last stage, I hope.
>

yes

> Thanks again,
> Flavio Boniforti
>

freddy77