There's more than one way to do things | |
PerlMonks |
Re^2: Remote Oracle database access from windowsby my600080 (Novice) |
on Jul 24, 2009 at 19:54 UTC ( [id://783082]=note: print w/replies, xml ) | Need Help?? |
I'm using DBD::ODBC module. When I execute my connecting string, I kept getting this error: Data source name not found and no default driver specified. I tried to use the DBD::ODBC's connecting without DSN: my $DSN = 'driver={Oracle ODBC Driver};Server=10.2.3.0:1521;database=ORADB;uid=oraadmin;pwd=oraadminpassword;'; my $dbh = DBI->connect("dbi:ODBC:$DSN") or die "$DBI::errstr\n"; But the same error message occurs. I think I might have put the wrong driver= because I cannot find an example for oracle database so I just used the syntax for mysql: http://search.cpan.org/~mjevans/DBD-ODBC-1.22/FAQ#How_do_I_connect_without_DSN
In Section
Seekers of Perl Wisdom
|
|