> -----Message d'origine----- > De : Richard Crawford [mailto:[EMAIL PROTECTED] > Envoyé : mercredi 12 mai 2004 22:17 > À : NYIMI Jose (BMB) > Cc : Alok Bhatt; [EMAIL PROTECTED] > Objet : Re: DBD for SQL Server? > > NYIMI Jose (BMB) wrote: > > > > >>-----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é. > > I've learned that in order to use DBD::ODBC I will still need to install > an ODBC driver on the machine (which is actually running Solaris 9). > Not a problem, if I can find one.
http://www.unixodbc.org/ José. -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] <http://learn.perl.org/> <http://learn.perl.org/first-response>