Re: Class::DBI and DBD::ODBC

[prev] [thread] [next] [Date index for 2004/09/29]

Veljko Vidovic wrote:
> Hi, all
> 
> I am trying to transfer mdb (access) data to oracle.
> So, I was thinking of using DBD::ODBC and DBD::Oracle
> together with CDBI.
> Problem is that table names in mdb are space separated, eg. "THIS IS TABLE
> NAME",
> so I am getting:
> DBD::ODBC::db prepare_cached failed: [Microsoft][ODBC Microsoft Access
> Driver]
> Syntax error in FROM clause. (SQL-42000)(DBD: st_prepare/SQLPrepare err=-1)
> [for Statement "SELECT ata FROM   ATA CODES AND DESCRIPTIONS"] at
> C:/Perl/site/lib/Ima/DBI.pm line 391.

Have you tried using Access's table name quoting scheme? Try enclosing 
the name in square brackets, e.g.

	__PACKAGE__->table('[ATA CODES AND DESCRIPTIONS]');

HTH,
Rhesa