> I'm having a problem using the table_info() via ProxyServer... I'm getting the >following error messages: > I am using a Sun box to run the DBI on to talk to my Windows/2000 machine running >ProxyServer to access my SQL Db. Everything was fine until I tried to use table_info >to get a listing of the Tables .... > I've tried everything I can think of .... any ideas ? > Kevin M. Fenaughty MCP, MCP+I, MCSE AT&T Labs -Networked Computing Offer Development (407)805-5528 Office (407)341-0480 Cell [EMAIL PROTECTED] [EMAIL PROTECTED]
%attr = ( TABLE_CAT => $catalog # String value of the catalog name , TABLE_SCHEM => $schema # String value of the schema name , TABLE_NAME => $table # String value of the table name , TABLE_TYPE => $type # String value of the table type(s) ); # my $data_source = 'dbi:Proxy:hostname=192.215.10.89;port=5731;dsn=dbi:ODBC:VNPoller'; my $dbh = DBI->connect("$data_source",'sa','',{RaiseError => 1, PrintError => 1}) or die $DBI::errstr; $sth = $dbh->table_info( $catalog, $schema, $table, $type, \%attr ); $sth->execute(); while( @row = $sth->fetchrow_array ) { print $row[0]."\n"; } > -- Error Messages ---- > [kevinf@billdev]/export/home/kevinf/MySQL->perl table_info.pl > DBD::Proxy::db table_info failed: Server returned error: Failed to execute method >CallMethod: Can't use string ("1") as an ARRAY ref while "strict refs" in use at >e:/Perl/site/lib/DBI/ProxyServer.pm line 296. > DBD::Proxy::db table_info failed: Server returned error: Failed to execute method >CallMethod: Can't use string ("1") as an ARRAY ref while "strict refs" in use at >e:/Perl/site/lib/DBI/ProxyServer.pm line 296. > > --- VERSION info >--------------------------------------------------------------------------------------------------- > This is perl, version 5.005_03 built for sun4-solaris. > The version of DBD I'm using is: # $Id: DBD.pm,v 11.2 2001/08/24 22:10:44 timbo Exp $ > The version of ProxyServer I'm using is: #$Header: >/home/timbo/dbi/lib/DBI/RCS/ProxyServer.pm,v 11.7 2002/12/01 22:34:29 timbo Exp $ >