Amiri Barksdale wrote:
I also seem to remember reading or hearing that DBD::ODBC may be a
better solution for MSSQL, but don't quote me on that
We use DBD::ODBC for MSSQL with little problem. The main issue was to
get quoting right. We enabled portability by getting MySQL to use ANSI
quotes, and using the following (we use YAML) configuration when
talking to MSSQL:
connect_info:
- 'dbi:ODBC(dbi_connect_method=connect_cached):Driver={SQL
Server};Server=localhost;database=armdb'
- 'username'
- 'password'
- AutoCommit: 1
-
quote_char: '"'
name_sep: '.'
The additional quote_char and name_sep args were required to get DBIC to
do the right thing.
All the best
Stuart
--
Stuart Watt
ARM Product Developer
Information Balance
_______________________________________________
List: [email protected]
Listinfo: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst
Searchable archive: http://www.mail-archive.com/[email protected]/
Dev site: http://dev.catalyst.perl.org/
