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

[Robert Dobbs]

>Robert Dobbs wrote:
> > 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?

It seems the solution to this whole problem is not to use DBD::Sybase, but 
to use DBD::ODBC which is more mature now than the documentation says it is. 
  Seems to be working okay so far.  I'll let you know how it goes, if there 
are other things to put in there.  I may need to set the MSSQL module as the 
storage type, and/or I may still need my own datetime inflators since our 
dates seem to be returned as "Sep  1 2006 03:45PM" and not like the strftime 
pattern in the current module.

For posterity, here are example entries from the files I needed to get 
FreeTDS/ODBC/MS SQL Server 200* working.

;; /etc/odbc.ini or equiv
[mydb]
Driver      = FreeTDS
Description = my mssql db
Trace       = No
Servername  = mydb_freetdsconf_entry
Database    = mydatabase

;; /etc/odbcinst.ini or equiv
[FreeTDS]
Driver		= /usr/lib/odbc/libtdsodbc.so
Setup		= /usr/lib/odbc/libtdsS.so

;; /etc/freetds/freetds.conf or equiv
; ... defaults ...
[mydb_freetdsconf_entry]
   host = myserver.mydomain.foo
   port = 1433
   tds version = 8.0

_________________________________________________________________
All-in-one security and maintenance for your PC.  Get a free 90-day trial!   
http://www.windowsonecare.com/trial.aspx?sc_cid=msn_hotmail