Re^3: Connecting to Sybase using Win32::ODBC

OK,....I changed the following;

use DBI;
$dsn = 'dbi:MDB:LNB_HHH_App';
$user = 'DB_analyst';
$password = 'DB_Pass';
$qry = 'dbo_vfunction_applications';
$dbh = DBI->connect($dsn,$user, $passwd);
$ary_ref  = $dbh->selectall_arrayref($qry);
[download]

And this what I got back in return;

DBD::DBM::db selectall_arrayref failed:  Couldn't parse!
  <dbo_vfunction_applications>
[download]

Any advice on how can I extract the data from the query $qry?

Cheers

Blackadder

Comment on Re^3: Connecting to Sybase using Win32::ODBC Select or Download Code

Replies are listed 'Best First'.
Re^4: Connecting to Sybase using Win32::ODBC by paulbort (Hermit) on Jun 09, 2004 at 18:15 UTC
I thought you also needed to `use DBI::ODBC;`. Also, I suspect that the reason you're getting that error is that "dbo_vfunction_applications" is not SQL. If it is a stored procedure or function, you might need to SELECT or EXEC it. If it is a command of a query analyzer of some sort, it won't work here. My guess would be that you need to EXEC it. -- Spring: Forces, Coiled Again!	[reply] [d/l]