in reply to SQL Server

You're obviously going to want DBI, and an appropriate DBD module or whatever so it can talk to the database in question. When someone asks you to set things up so that Perl can talk to a database, DBI is what they want.

I too need to get this set up (with SQL Server 2000), and I guess the real question is, what DBD module is most appropriate for this scenario? Should we be using DBD::ODBC somehow, or is DBIx::MSSQLReporter the way to go? Something else?

Sanity? Oh, yeah, I've got all kinds of sanity. In fact, I've developed whole new kinds of sanity. Why, I've got so much sanity it's driving me crazy.

Replies are listed 'Best First'.
Re^2: SQL Server
by Losing (Acolyte) on Nov 09, 2006 at 16:00 UTC
    DBI it is, thank you very much. I will now look into whether or not there exists an appropriate DBD. Thanks
[reply]
      DBD::ODBC works very well for MS-SQL Server, at least on Windows. (See other replies for access from Unix).

      Allegedly, DBD::Sybase would work well to bypass ODBC, as MS-SQL Server is based on the (old) Sybase database. But I think I remember having heard to have its actual working for MS-SL Server is getting flakier.

      p.s. I found this parapgraph in the DBD::Sybase docs: Using_DBD::Sybase_with_MS-SQL

[reply]

In Section Seekers of Perl Wisdom