| Subject: | DBI access error |
| Date: | Wed, 02 May 2007 05:47:52 +0100 |
| To: | bug-SQL-Translator [...] rt.cpan.org, sqlfairy-developers [...] lists.sourceforge.net |
| From: | dmahler [...] gmail.com |
when running:
dsn="dbi:ODBC:driver=$driver;Server=$host;Port=$port;database=$name;uid=$user;pwd=$pass;"
sqlt -f DBI -t YAML --dsn $dsn --db-user $user --db-password $pass
I get:
setting dbh attribute {FetchHashKeyName} to NAME_uc at /home/dm/sqlfairy/lib/SQL/Translator/Parser/DBI/SQLServer.pm line 53.
setting dbh attribute {ChopBlanks} to 1 at /home/dm/sqlfairy/lib/SQL/Translator/Parser/DBI/SQLServer.pm line 58.
DBD::ODBC::db column_info failed: [unixODBC][FreeTDS][SQL Server]Procedure or function 'sp_columns' expects parameter '@table_name', which was not supplied. (SQL-42000)(DBD: odbc_columns/SQLColumns err=-1) at /home/dm/sqlfairy/lib/SQL/Translator/Parser/DBI/SQLServer.pm line 72.
Error: translate: Error with parser 'SQL::Translator::Parser::DBI':DBD::ODBC::db column_info failed: [unixODBC][FreeTDS][SQLServer]Procedure or function 'sp_columns' expects parameter '@table_name', which was not supplied. (SQL-42000)(DBD: odbc_columns/SQLColumns err=-1) at /home/dm/sqlfairy/lib/SQL/Translator/Parser/DBI/SQLServer.pm line 72.
thanks
Daniel