-----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>
