Hi all!
I'm sure this is a common question yet I've searched google, newgroups, and
perl.com, and even read through the documentation on DBI and I can't find
the answers I'm looking for.
I have years of experience with PERL but i'm pretty new to databases and
DBI. I'm trying to access an Oracle database from my windows 2000
workstatioon. I've successfully done this on Unix and trying to port my
script to windows and running into problems.
My connect statement is failing. Here is the syntax i'm using:
$db2 = DBI->connect('dbi:ODBC:oracle_instance:server_name', 'USER', 'PASS');
The error:
DBI connect(TAKEN OUT..) failed: [Microsoft][ODBC Driver Ma
nager] Data source name not found and no default driver specified
(SQL-IM002)(DB
D: db_login/SQLConnect err=-1) at C:\Documents and
Settings\misbjb\Desktop\lawch
eck.pl line 34
I have perl installed. I have DBI installed. I also installed DBD::ODBC. Am
I correct in thinking that windows users need to use ODBC to access oracle
databases? On my unix box I successfully used DBD::Oracle, but I get the
impression that this can not be used on a windows platform. I also have a
ODBC driver installed on my workstation and I can use it in excel to access
the same database I'm trying to access with perl.
I have a feeling I just didn't structure my connect statement right. Any
help will be appreciated.
Thanks!
Brian
