Accessing oracle from windows 2000

From: Brian Barto (brian.barto_at_spectrum-health.org)
Date: 03/04/04 

To: dbi-users@perl.org
Date: Thu, 4 Mar 2004 09:02:37 -0500

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

Relevant Pages

  • Re: PostgreSQL-Ruby extention: calling Postgres functions
    ... not sure how it is done with raw postgres driver ... The DBI in ruby is a standard method of interfacing to SQL databases (it ... switch the database (and use different database driver) but your code ...
    (comp.lang.ruby)
  • changing db location on sql2000
    ... I've got sql server 2000 desktop running on a windows xp pro machine. ... My C: driver is too small and I'd like to move the databases to d: now. ...
    (microsoft.public.sqlserver.setup)
  • Re: Perl 6 DBI API ideas
    ... Though I didn't raise my hand when you asked for people to contribute to a DBI module for Perl 6, I've had some ideas that I thought about sharing. ... I would also love to see some standardization on the driver names ("mysql" when it's normally written ... DBI is supposed to be query language agnostic, even if SQL is the most commonly used group of languages, and if a user can declare this explicitly, it saves the driver from having to guess what they were given, which might be ambiguous. ...
    (perl.dbi.users)
  • Re: DBI and character sets (yet again)
    ... I don't really want the DBI to be involved in any recoding ... When selecting data from the database the driver should: ... - return strings which have a unicode character set as UTF8. ... - return strings with other character sets as-is on ...
    (perl.dbi.users)
  • DBD::ODBC make test fails
    ... I installed DBI ... this looks like a unixodbc type of driver manager. ... Undefined subroutine &main::BAILOUT called at t/02simple.t line 23. ... ok 2 - use ODBCTEST; ...
    (perl.dbi.users)