Friday, January 1, 2010

Can't get perl to attach to ASA

Originally Published 2003-09-29 01:54:53

I'm having a heck of a time attaching to ASA from perl. Here's what I did (on win32):



+ installed Apache 1.3.x

+ installed ActiveState perl

+ installed ASA 8.0x

+ installed DBI and ASA::DBD using PPM



I can log into ASA from the query manager (i've loaded the data correctly now, btw). I've copied the credentials verbatim from what I'm using in the query manager GUI and I have the following connect string, which I lifted from the ianywhere website ASA DBD documentation:



use DBI;



my $database = "INTEL_MSI_CONFERENCE_DATABASE";

my $data_source = "DBI:ASAny:$database";

my $username = "UID=DBA;PWD=sql;ENG=intel_msi_conference_database";

my $dbh = DBI->connect( $data_source, $username, 'na' );



I have played with the case of $database, uid, pwd, and eng. I also tried replacing 'na' with 'sql' in the last statement -- in connect strings I've used in the past, this third argument has been the password.



There are a couple of add'l combinations I can try...

No comments: