[Templates] Connection to a MSSQL server

klaushorsten email.10@gmx.net
Sun, 09 Jul 2006 18:01:11 +0200


Hallo,

can someone help me to connect to a Mssql Database? On Windows.

I think this has do be done via ODBC.

I want to do something like this

[% USE DBI('dbi:Mssql:mydbname') %]
[% FOREACH user = DBI.query('SELECT * FROM user ORDER BY id') %]
[% END %]

There is a Mssql class, which is a wrapper for Odbc, but I do not 
know how to use it, since I do not know how to do it in Perl.

Regards,

Klaus