Re: SQL to XML using DBIx::XML_RDB >> Can't connect to the database

[Bill Karwin]

lauragarcia_b wrote:
> my $xmlout = DBIx::XML_RDB->new($data_source,
> 'mysql', $mySqlUsername, $mySqlPassword
> {'RaiseError' => 1, 'PrintError' => 1});

A few comments on the above:

1. You don't have a comma between $mySqlPassword and the following hashref argument.

2. This DBIx::XML_RDB->new() function doesn't support a DBI-style connect option hashref anyway, based on reading the code at http://search.cpan.org/src/MSERGEANT/DBIx-XML_RDB-0.05/XML_RDB.pm

3. You aren't checking for this new() function returning undef, which it does if the connection fails. Since you're getting an error about undef when trying to use the $xmlout object, it is evidently having some problem connecting. Perhaps because of the hashref.

Regards,
Bill K.