>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 _______________________________________________ List: http://lists.rawmode.org/cgi-bin/mailman/listinfo/dbix-class Wiki: http://dbix-class.shadowcatsystems.co.uk/ IRC: irc.perl.org#dbix-class SVN: http://dev.catalyst.perl.org/repos/bast/trunk/DBIx-Class/ Searchable Archive: http://www.mail-archive.com/[email protected]/
