Tired this...

my $connect_str = "Provider=SQLOLEDB.1;" .
                  "User Id=$uid;Password=$pwd;" .
                  "Data Source=$svr;" .
                  "Initial Catalog=$db";

my $conn = new Win32::OLE('ADODB.Connection')
   or die "Cannot make ADODB connection : " . Win32::OLE->LastError;

$conn->Open($connect_str) 
   or die "Cannot connect to $db on $svr : " . Win32::OLE->LastError;

$conn->Close;
[download]

...but I'm still getting the same problem...

Cannot connect to $db on $svr : 0 at adodb.pl line 22
[download]

I tried using Win32::ODBC to connect, which I got working ok, but this method doesn't support stored procedures with output parameters, which is what I really need to do. I'm looking into DBI too.

Anyone got any ideas how to do this?