| Subject: | Cannot specify a database name to set_up_table |
Hi,
I'm trying to use Class::DBI::Sybase in an environment that uses multiple databases on a server. I need to be able to get the columns for a database other than the default one. If I try to use the syntax DATABASE..TABLE, I get the following error:
Error: DBD::Sybase::st execute failed: Server message number=102 severity=15 state=1 line=1 server=SYB_SWPCLR_TSTtext=Incorrect syntax near '.'.
t/001_load....NOK 1# [for Statement "sp_columns CLEARING_TST2..PLAINVANILLASWAP"] at /home/williami/lib/DBIx/ContextualFetch.pm line 51.
I also get a similar error if I try to use sp_columns DATABASE..TABLE from isql.
Tables in the default database are fine, but this is not an option for me.
I'm running this on Solaris 2.8 and perl 5.6.1 by the way.