Re: DBI:Sybase - Period in database name

[roho]

in reply to DBI:Sybase - Period in database name

Try this:

my $DBNAME = '[ps_inventory.ad]';
$dbh->do("use $DBNAME");

[apu]

Thanks, roho! That works.

[runrig]

This suggests to me that $dbh->quoted_identifier(..) should wrap things in brackets, not quotes, for DBD::Sybase, and so currently has a bug. Though there is also a syb_quoted_identifier atribute, which if set, should allow you to use quotes (though I've never used it). And I do now recall having to occasionally use brackets to quote some table/column names.