in reply to Re: Cannot connect to SQL Server 2000 using DBI
in thread Cannot connect to SQL Server 2000 using DBI

do you have any sample on how to best connect to SQL Server 2000 uisng DBI??
  • Comment on Re^2: Cannot connect to SQL Server 2000 using DBI

Replies are listed 'Best First'.
Re^3: Cannot connect to SQL Server 2000 using DBI
by bart (Canon) on Jul 04, 2004 at 10:39 UTC
    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"
Re^3: Cannot connect to SQL Server 2000 using DBI
by Anonymous Monk on Jul 04, 2004 at 03:54 UTC