wrote:
Date: Tue, 28 Jul 2009 07:51:12 -0700 (PDT)
From: Ming Yu
To: pmonsch...@groupe-casino.fr, dbi-users@perl.org
Subject: Re: Perl DBI and DBD::ODBC for Oracle on Windows
I changed {Microsoft ODBC for Oracle} to {Oracle in instantclient_11_1} as
specified in ODBC_IC_Readme_Win.html file. And I
Thanks a lot for your help.
Ming
- Original Message
From: "pmonsch...@groupe-casino.fr"
To: my600...@yahoo.com; dbi-users@perl.org
Sent: Tuesday, July 28, 2009 9:21:02 AM
Subject: RE: Perl DBI and DBD::ODBC for Oracle on Windows
Hello
1) By adding sid= in the DSN, yo
Hello
1) By adding sid= in the DSN, you should be able to point to the correct
SID.
So in your case :
my $DSN = 'driver={Microsoft ODBC for
Oracle};server=10.1.6.9:1521;sid=XX;uid=oradbuser;pwd=oradbpassword;';
2) You should not use "Microsoft ODBC for Oracle" that is a very old driver,