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: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]
> Sent: 04 March 2004 14:03
> To: [EMAIL PROTECTED]
> 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 [EMAIL PROTECTED] 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
________________________________________________________________________
