[Dbix-class] how do others connect with MSSQL?

[Robert Dobbs]

>Ugh!  Yes, I tried that (to '::DBI::Sybase::MSSQL' and '::DBI::MSSQL') but
>then this happens on a 'create':
>
>ct_send(CS_DESCRIBE_INPUT) returned 0 at /usr/lib/perl5/DBD/Sybase.pm line
>124.
>Segmentation fault
>
>However, if I set it to '::DBI::Sybase' it works correctly to save!  I get
>back the ID.  Weird, since I am using MSSQL.
>
>Except then loading InflateColumn::DateTime doesn't work.
>
>Invalid date format: Sep  1 2006 05:13PM at
>/usr/local/share/perl/5.8.8/DBIx/Class/InflateColumn/DateTime.pm line 63
>    (InflateColumn 83, etc...)

I was able to get it working with my own inflators, until I tried to do an 
update(), which uses ? placeholders, and I get a segfault from the driver.

How do other people connect under Linux/Unix to a Microsoft SQL server?  Do 
you use ODBC, and if so which driver do you recommend?

Thanks....

Mark

_________________________________________________________________
Get real-time traffic reports with Windows Live Local Search  
http://local.live.com/default.aspx?v=2&cp=42.336065~-109.392273&style=r&lvl=4&scene=3712634&trfc=1