DBD for SQL Server?
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. -- Richard S. Crawford Programmer III, UC Davis Extension Distance Learning Group (http://unexdlc.ucdavis.edu) (916)327-7793 / [EMAIL PROTECTED] -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] <http://learn.perl.org/> <http://learn.perl.org/first-response>
RE: DBD for SQL Server?
> -Original Message- > From: Richard Crawford [mailto:[EMAIL PROTECTED] > Sent: Wednesday, May 12, 2004 12:40 AM > To: [EMAIL PROTECTED] > Subject: DBD for SQL Server? > > > 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. > I would try DBD::ODBC 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>
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 http://search.cpan.org/~gsar/libwin32-0.191/ODBC/ODBC.pm More info - perldoc Win32::ODBC HTH, Alok __ Do you Yahoo!? Yahoo! Movies - Buy advance tickets for 'Shrek 2' http://movies.yahoo.com/showtimes/movie?mid=1808405861 -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] <http://learn.perl.org/> <http://learn.perl.org/first-response>
RE: DBD for SQL Server?
> -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>
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. -- Richard S. Crawford Programmer III, UC Davis Extension Distance Learning Group (http://unexdlc.ucdavis.edu) (916)327-7793 / [EMAIL PROTECTED] -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] <http://learn.perl.org/> <http://learn.perl.org/first-response>
Re: DBD for SQL Server?
On Tue, 2004-05-11 at 18:40, Richard Crawford 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. Richard, I'm running a mod_perl site connected to a SQL Server 2000 backend via DBD::ODBC with a driver from OpenlinkSW. Go to http://www.openlinksw.com. They will let you download a full working driver, but it has a 30 license. If you need more than 30 days you'll have to redownload the driver and it'll email you another 30 day license. It took us about 6 months of "testing" before we bought the driver for about $600, buti it was well worth it. They'll also give you the iODBC SDK (driver manager) and phone support even if you're evaluating. Lot's of praise on the phone support as they worked with me for 5 days and had a developer helping me as I was having trouble getting it interfaced with mod_perl for some weird reason. Long story short mod_perl was only seeing unixODBC (another driver manager) and so I had use unixODBC instead of iODBC. No biggie, it was tracking this down that was the problem. Hope this helps, Kevin -- Kevin Old <[EMAIL PROTECTED]> -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] <http://learn.perl.org/> <http://learn.perl.org/first-response>
RE : DBD for SQL Server?
> -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>