freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

[freetds] DBD::ODBC and $dbh->table_info()

From: Daniel Kasak <dkasak AT nusconsulting.com.au>
To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
Subject: [freetds] DBD::ODBC and $dbh->table_info()
Date: Tue, 07 Aug 2007 16:07:32 +1000

Hi all.

I'm after a list of table names.

I've tried executing the 'sp_tables' procedure and fetching a recordset
from the handle, but it doesn't produce a recordset ( no errors
though ).

I've tried $dbh->table_info(), but this fails with:

[unixODBC][Driver Manager]Function sequence error (SQL-HY010)(DBD:
st_execute/SQLExecute err=-1)

Any other ways?

--
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
North Sydney, NSW, Australia 2060
T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989
email: dkasak AT nusconsulting.com.au
website: http://www.nusconsulting.com.au

[freetds] DBD::ODBC and $dbh->table_info(), Daniel Kasak, 08/07/2007
- Re: [freetds] DBD::ODBC and $dbh->table_info(), James K. Lowden, 08/07/2007