RE: Accessing oracle from windows 2000
From: Andy Crichton (andrew.crichton_at_abibuildingdata.com)
Date: 03/04/04
- Next message: Brian Barto: "RE: Accessing oracle from windows 2000"
- Previous message: Hardy Merrill: "Re: Accessing oracle from windows 2000"
- In reply to: Brian Barto: "Accessing oracle from windows 2000"
- Next in thread: Brian Barto: "RE: Accessing oracle from windows 2000"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
To: <brian.barto@spectrum-health.org>, <dbi-users@perl.org> Date: Thu, 4 Mar 2004 14:12:46 -0000
Hi,
I think the best way to connect from a windows box is to use
DBD::Oracle. You need oracle net8 anyway for odbc so it is likely you will
just be able to install the activestate DBD::Oracle and DBI. You will need
the appropriate entry in your tnsnames.ora file also.
Andy
> -----Original Message-----
> From: brian.barto@spectrum-health.org
> [mailto:brian.barto@spectrum-health.org]
> Sent: 04 March 2004 14:03
> To: dbi-users@perl.org
> Subject: Accessing oracle from windows 2000
>
> 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
>
>
> ______________________________________________________________
> __________
> This e-mail has been scanned for all viruses by Star
> Internet. The service is powered by MessageLabs. For more
> information on a proactive anti-virus service working around
> the clock, around the globe, visit:
> http://www.star.net.uk
> ______________________________________________________________
> __________
>
__________________________
This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. The contents are confidential and may be privileged.
Any views or opinions expressed are those of the sender and may not reflect the views or opinions of the company and the company accepts no liability in respect thereof.
If you have received this email in error please notify postmaster@abibuildingdata.com immediately.
________________________________________________________________________
This e-mail has been scanned for all viruses by Star Internet. The
service is powered by MessageLabs. For more information on a proactive
anti-virus service working around the clock, around the globe, visit:
http://www.star.net.uk
________________________________________________________________________
- Next message: Brian Barto: "RE: Accessing oracle from windows 2000"
- Previous message: Hardy Merrill: "Re: Accessing oracle from windows 2000"
- In reply to: Brian Barto: "Accessing oracle from windows 2000"
- Next in thread: Brian Barto: "RE: Accessing oracle from windows 2000"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Relevant Pages
|
