Re: Perl DBI and DBD::ODBC for Oracle on Windows

2009-07-28 Thread Mike Nhan
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

Re: Perl DBI and DBD::ODBC for Oracle on Windows

2009-07-28 Thread Ming Yu
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

RE: Perl DBI and DBD::ODBC for Oracle on Windows

2009-07-28 Thread pmonschein
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,