> -----Original Message----- > From: Alok Bhatt [mailto:[EMAIL PROTECTED] > Sent: Wednesday, May 12, 2004 11:49 AM > To: [EMAIL PROTECTED]; [EMAIL PROTECTED] > Subject: Re: DBD for SQL Server? > > > > --- Richard Crawford <[EMAIL PROTECTED]> > wrote: > > Is there a DBD for SQL Server so that I can connect > > to our SQL Server > > 2000 database with DBI? I've hunted all over CPAN > > but I can't seem to > > find one. > Windows uses the Open Database Connectivity (ODBC) > Model. You can connect to an MS-SQL server using > Win32::ODBC, available at
Then you will no longer be using DBI API (what OP wanted) ! The advantage of DBD::ODBC (or DBD::ADO ) Is the portability of your code since you Will be using the same api syntax regarless the The database driver (DBD) you are dealing with behind DBI. The connection is always my $dbh=DBI->connect(...); Not a new api like: $Data = new Win32::ODBC(...); Which obviously will not work if you need To use your same code on a database running on unix box. HTH, José. **** DISCLAIMER **** "This e-mail and any attachment thereto may contain information which is confidential and/or protected by intellectual property rights and are intended for the sole use of the recipient(s) named above. Any use of the information contained herein (including, but not limited to, total or partial reproduction, communication or distribution in any form) by other persons than the designated recipient(s) is prohibited. If you have received this e-mail in error, please notify the sender either by telephone or by e-mail and delete the material from any computer". Thank you for your cooperation. For further information about Proximus mobile phone services please see our website at http://www.proximus.be or refer to any Proximus agent. -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] <http://learn.perl.org/> <http://learn.perl.org/first-response>