This sums it up well Brian: http://www.perlmonks.org/?node_id=117694
I've never found anything that ADO could do that ODBC couldn't. The MS development tools and languages can be easier to use with ADO once you figure out its quirks but for Perl ODBC works perfectly. I've done lots of work with ADO on Win development tools but always used DBD::ODBC in Perl. Neil -----Original Message----- From: Brian H. Oak [mailto:[email protected]] Sent: 20 May 2009 16:23 To: 'Stricker, Scott E (IS)' Cc: [email protected] Subject: RE: :ODBC vs. DBD::ADO So are there any maturity, reliability, performance, or functionality differences between ODBC and ADO, anything that might recommend one over the other? Thank you, -Brian -----Original Message----- From: Stricker, Scott E (IS) [mailto:[email protected]] Sent: Wednesday, May 20, 2009 06:48 To: Brian H. Oak Subject: RE: :ODBC vs. DBD::ADO I've got perl code that to swap between ODBC and ADO, I simply change the connect string. At one point, there was a bug in ADO driver that pushed me to ODBC, other than that, I was able to swap back and forth. E. Scott Stricker Senior Software Engineer Northrop Grumman - Information Systems - C2SD MailStop 4S02 2340 Dulles Corner Blvd. Herndon, VA 20171 703-561-3671 703-713-1601 (fax) -----Original Message----- From: Brian H. Oak [mailto:[email protected]] Sent: Tuesday, May 19, 2009 6:48 PM To: [email protected] Subject: DBD::ODBC vs. DBD::ADO I have used DBD::ODBC for years, connecting to and working with MS SQL Server. In all that time I have been very happy with DBD::ODBC. Now I'm porting someone else's code into Perl, and it was originally written to use ADO. I already know that I can make the code work with ODBC, but I have to wonder if there would be enough advantages in using ADO to justify the jump -- and the corresponding learning curve. Has anyone out there used both technologies with SQL Server? If so, have you formed an opinion about the pluses and minuses of each? Thank you, -Brian . This message is intended only for the use of the person(s) to whom it is addressed. It may contain information which is privileged and confidential. Accordingly any unauthorised use is strictly prohibited. If you are not the intended recipient, please contact the sender as soon as possible. It is not intended as an offer or solicitation for the purchase or sale of any financial instrument or as an official confirmation of any transaction, unless specifically agreed otherwise. All market prices, data and other information are not warranted as to completeness or accuracy and are subject to change without notice. Any opinions or advice contained in this Internet email are subject to the terms and conditions expressed in any applicable governing Marble Bar Asset Management LLP's terms and conditions of business or client agreement letter. Any comments or statements made herein do not necessarily reflect those of Marble Bar Asset Management LLP. Marble Bar Asset Management LLP is regulated and authorised by the FSA.
