Thanks, table_info is ok.
I did "my @tables = $dbh->tables();",
it's a simple way but it has like;
`C:\temp\test`.`MSysAccessObjects`
Answer was not good.
I wonder if we had more smart way...
> $sth = $dbh -> table_info(undef, undef, '%', 'TABLE');
>
> while ($data = $sth -> fetchrow_hashref()
On Fri, 2007-12-07 at 11:19 +0900, 田口 浩 wrote:
Hi
> my $dbh = DBI->connect("dbi:ODBC:test", "", "",
>{RaiseError => 1, AutoCommit => 0, LongReadLen => 409600})
>or die "$DBI::errstr";
>
> Anyone will teach me how to get all names of tables
> (in test.mdb)?
$sth = $dbh -> table_info(unde
you definitely have your work cut out as microsoft expects a local
DataSource to have all the DB connection info
which of course you do not have on a nix box
from what I gather from CPAN this is the official release
http://search.cpan.org/~evo/DBIx-SQLEngine-0.93/SQLEngine/Driver/MSSQL.pm
I also
Sent: Friday, December 07, 2007 8:52 AM
To: dbi-users@perl.org
Subject: Connecting to Database
Hello
At the present time I am using Perl, cgi, Apache Web Page, SQL, and
SYBASE database on a unix server(SUN Fire V 880). I have no problem
accessing the Sybase database, fetching records and display