minimum for connecting to MsSQL from UNIX with perl

[bazi]

Hey All,

I moved to a next level and require to write a script that connects to MsSQL DB. The script is run from a Linux box what makes it little bit tricky. What is the minimum that I need to put on the box to achieve it? Forums all over the internet suggest very different solutions and I do not have much room to test them. Before I use DBD::Sybase or DBD::ODBC what do I actually need to have installed on the box? Is is either of freeTDS or unixODBC or do I maybe need them both?

Any suggestions welcome.

Thanks in advance.

Wojtek

[thewebsi]

I am successfully connected to an MS-SQL database with FreeTDS, unixODBC, and DBD::ODBC installed. They are all required: DBD::ODBC is the DBI driver interface layer, unixODBC provides the ODBC layer, and FreeTDS is the database driver. I believe you will also have to edit /etc/odbcinst.ini to recognize FreeTDS as a driver.

[BrowserUk]

Have you read DBD::ODBC::FAQ?

In particular Where do I get an ODBC driver manager for Unix/Linux?.

[GrandFather]

If you are connecting to a mysql database then you need DBD::mysql. The connect line looks like:

use DBI;

my $dbh = DBI->connect(
    'dbi:mysql:dbname=MyDatabase;host=myhost.somewhere.someplace',
    'MyUserName', 'MyPassword'
    );

Update: Urg, misread 'ms' as 'my' - even with the strong OBDC etc. hints!