A
anonymous
Does anyone know how to connect to an MS SQL 2000 db from
Perl?
thanks.
Perl?
thanks.
B
Ben Morrow
I have had success (under linux) with DBI and DBD::Sybase. From Windows
I guess you can use DBD::ODBC.
Ben
J
Jim
my $dbhandle = DBI->connect(
"DBI:ADO
RIVER={SQL Server};SERVER=$servername;DATABASE=$dbname",
$uid, $pwd,{ RaiseError => [1],
PrintError => [1],
AutoCommit => [1])
) || die "Db connection not made: $DBI::errstr";
"DBI:ADO
RIVER={SQL Server};SERVER=$servername;DATABASE=$dbname",$uid, $pwd,{ RaiseError => [1],
PrintError => [1],
AutoCommit => [1])
) || die "Db connection not made: $DBI::errstr";
J
Jim
Oh yeah,
use DBI;
use DBI qwsql_types);
use DBI;
use DBI qw
sql_types);my $dbhandle = DBI->connect(
"DBI:ADO
$uid, $pwd,{ RaiseError => [1],
PrintError => [1],
AutoCommit => [1])
) || die "Db connection not made: $DBI::errstr";