Your answer

[Jonathan Stowe]

Hi,
On Mon, 2008-04-07 at 15:35 +0300, Michael Engel wrote:
> Dear Jonathan,
> 

Please don't ignore the Reply-To address on the list messages in future.

> Thanks for your answer. In fact I am using option b. However I have some 
> difficulties in retrieving. No problem of accessing to MSSQL itself.
> The problem is in trying to retrieve data .
> 
> Your writing of 'more "help oriented" forum' indicated I was using the 
> wrong address. What is the right one?
> 

Well the London.pm mailling list is really more of a social list for
people who use Perl in London rather than a technical forum. While
people do send technical questions they are usually of a more general
nature. You probably would do better somewhere like PerlMonks.

> I receive errors like:
> 
> DBD::Sybase::st execute failed: Server message number=208 severity=16 
> state=1 line=1 server=GRAPHIT text=Invalid object name 'NodesBackup'. at 
> test3.pl line 18.
> unable to execute query SELECT * FROM NodesBackup   error Server   
> number=208 severity=16 state=1 line=1 server=GRAPHIT text=Invalid object 
> name 'NodesBackup'. at test3.pl line 18.
> 

Either 'NodesBackup' is an incorrect table name or you are looking at
the wrong database, this might be because of your client configuration.


> I received them upon using:
> 
> $dbh->do("use SwitchCenterDB");


You shouldn't need to do the above - you should have the correct
database in your connect string. Or specify the fully qualified name of
the tables in the query.

> $query = "SELECT * FROM NodesBackup";
> $sth = $dbh->prepare ($query) or die "prepare failed\n";
> $sth->execute() or die "unable to execute query $query error $DBI::errstr";
> 
> 
> Thanks,
> 
> Michael
> 
> 
> 
>