http://qs321.pair.com?node_id=371654


in reply to Cannot connect to SQL Server 2000 using DBI

Have you confirmed that DBI is loaded on your system? (What platform? What version of Perl?)

You also should add a DBD module. When connecting to a SQL Server I tend to use DBD::ODBC. Look into the documentation. Do a super search on DBI and DBD::ODBC.

  • 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:43 UTC
    I thought in the connection string, you need to specify the driver of connecting database??? Why do I need to add DBD???
[reply]
      I suppose the simpliest way to say it is that the DBD is the driver to the database. If I understand the process correctly, the DBD contains the specifics for the particular database that you are trying to connect to. You need to understand both DBI and your chosen driver. I haven't pursued the "why" as much as the "how". You just need all the correct pieces or the connection isn't going to work. Have you looked at the DBI site? You can download a DBD there and get more information.
[reply]

In Section Seekers of Perl Wisdom