Beefy Boxes and Bandwidth Generously Provided by pair Networks
There's more than one way to do things
 
PerlMonks  

Re^2: Remote Oracle database access from windows

by my600080 (Novice)
on Jul 24, 2009 at 19:54 UTC ( [id://783082]=note: print w/replies, xml ) Need Help??


in reply to Re: Remote Oracle database access from windows
in thread Remote Oracle database access from windows

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
  • Comment on Re^2: Remote Oracle database access from windows

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://783082]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others taking refuge in the Monastery: (6)
As of 2024-04-25 11:54 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found