in reply to Cannot connect to SQL Server 2000 using DBI

my $data_source = "dbi::SQL Server:Interfaces";
dbi::?
  • Comment on Re: Cannot connect to SQL Server 2000 using DBI

Replies are listed 'Best First'.
Re^2: Cannot connect to SQL Server 2000 using DBI
by Anonymous Monk on Jul 04, 2004 at 03:41 UTC
    do you have any sample on how to best connect to SQL Server 2000 uisng DBI??
[reply]
      The AM is right, you should have a DBD driver defined between the first and the second colon.

      Assuming your perl code runs on Windows... I think the easiest way is to use the DBD::ODBC driver. Make a System-DSN to your database, with the "32-bit ODBC data sources" control panel from Windows, and use the name you gave it there, as the third part for your connect string. If that name was "Foo" (just a silly example :-) ), the connect string can then look like: 

         "DBI:ODBC:Foo"

      [download]
[reply]
[d/l]
[reply]

In Section Seekers of Perl Wisdom