in reply to Re: Can i execute two queries connecting to same DB at a time.
in thread Can i execute two queries connecting to same DB at a time.
Right. MS SQL Server can handle only one active connection without sacrificing some chickens. This is a limitation of the communication protocol between the ODBC driver and the MS SQL Server, not a DBI or DBD::ODBC limitation, and it is documented in DBD::ODBC::FAQ. Other RDBMS like Oracle and PostgreSQL can handle multiple active connnections via DBI without any problems, at least with their native DBDs, but they should also support them with DBD::ODBC and a recent ODBC driver.
Alexander
--
Today I will gladly share my knowledge and experience, for there are no sweeter words than "I told you so". ;-)
Today I will gladly share my knowledge and experience, for there are no sweeter words than "I told you so". ;-)
|
---|
Replies are listed 'Best First'. | |
---|---|
Re^3: Can i execute two queries connecting to same DB at a time.
by Anonymous Monk on May 07, 2009 at 06:55 UTC | |
by Corion (Patriarch) on May 07, 2009 at 07:02 UTC | |
by afoken (Chancellor) on May 07, 2009 at 07:00 UTC |
In Section
Seekers of Perl Wisdom