in reply to Re^3: Sybase(on WinXPProfessional) connectivity with Perl(Sybase 15, Perl5.8.8)
in thread Sybase(on WinXPProfessional) connectivity with Perl(Sybase 15, Perl5.8.8)

Thanks Rob! Well I just want to get Sybase(15, Dev Edition on Windows) talk to Perl 5.6.Is there a simple method to do this?
I could make MSSQL Server talk to Perl using Win32::ODBC and the best part is no username/password was required due to Windows Authentication Mode and that can get me going. But this is a prototype and later planting in production means its Sybase 12.5 on Unix. Somehow for Developemnt purposes, need, Sybase15 talk to Perl 5.6
I need a complete sample program.
Here is the one I used for MSSQLServer:
use Win32::ODBC; my $DSN = "MSSQLpubsDSN"; my $connection = new Win32::ODBC($DSN); ## Check to make sure the connection is valid if (!$connection) { die "Could not open connection to DSN because of [$!]"; } my $SQL = "SELECT * FROM authors"; if($connection->Sql($SQL)) { print "I could not execute the following statement:\n $SQL\n"; print "I encountered this error:\n"; print $connection->Error() . "\n"; ## Closing the database connection $connection->Close(); ## Exiting the program die; } print "The query returns the following list of authors:\n"; while ($connection->FetchRow()) { my %dataRow = $connection->DataHash(); print $dataRow{au_id} . " : " . $dataRow{au_lname} . "\n"; } ## Closing the database connection $connection->Close();

Edit: g0n - code tags