in reply to Perl, DBD and SQL Server 2008 (R2)
Just to add one little bit to the excellent information roboticus provided as it sometimes confuses people. When you use "dbi:ODBC:mydsn" DBD::ODBC actually calls the SQLConnect ODBC API first with the DSN mydsn and only if that fails does it call the SQLDriverConnect ODBC API. The SQLConnect API is old, still called for backwards compatibility and does not support connection attributes of the form "a=b;c=d". If you want to skip the call to SQLConnect and go immediately to SQLDriverConnect then use "dbi:ODBC:DSN=mydsn" or "dbi:ODBC:DRIVER={xxx}".
|
---|
Replies are listed 'Best First'. | |
---|---|
Re^2: Perl, DBD and SQL Server 2008 (R2)
by campblem (Initiate) on Feb 03, 2011 at 18:51 UTC | |
by mje (Curate) on Feb 04, 2011 at 15:19 UTC | |
by Anonymous Monk on Mar 24, 2011 at 23:44 UTC |
In Section
Seekers of Perl Wisdom