Re: DBI:Sybase - Period in database name

Try this:

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

"Its not how hard you work, its how much you get done."

Comment on Re: DBI:Sybase - Period in database name Download Code

Replies are listed 'Best First'.
Re^2: DBI:Sybase - Period in database name by apu (Sexton) on Feb 23, 2013 at 13:02 UTC
Thanks, roho! That works.	[reply]
Re^2: DBI:Sybase - Period in database name by runrig (Abbot) on Feb 25, 2013 at 20:42 UTC
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.	[reply] [d/l]