in reply to MS SQL Server
I'm also wondering if there is a performance hit with using ODBC as opposed to connecting to the database directly.
It is very likely for a small performance hit of using the ODBC. Due to the overhead function calls of DBI -> DBD::ODBC -> ODBC -> MSSQL. But I don't see the reason for a large performance hit.
Actually I don't see any reason not to use ODBC. Even if it is Microsoft technology but MSSQL and ODBC agree with each other, why shouldn't they... both are Microsoft.
JanneVee
In Section
Seekers of Perl Wisdom