Why does the old photo remain in my blog after being replaced by a new one?
Building DBD::Oracle on XP w/ VC 2005
Hello Guest		   
  • Login
• Register…
• Start blog		   • Who, Where, When
• What can I do?
• What to Read?		   • Polls
• Avatars
• Interests		   • Cities and Countries
• Random blog
• Users search		   • Search
• Games
• Tests
• QAIX		   • Talxy Chat
• Horoscope
• Online		  
Зарегистрируйся!
QAIX > Perl web-programming > Building DBD::Oracle on XP w/ VC 2005 8 May 2008 21:50:22
  Recent blog posts: 
real ventures
My prayer for u: Starting from today, you are moving from glory to glory; anything you lay your hands on…

Of Gold and Current Trends
Gold still hovers over the $860/oz mark. As usual, whenever such a price spike occurs -- and they do not…

Handpunch
if any one want to know about handpunch programming(Rsidll3­­2.dll), plz contact me. Hi hairul…

My Best Person
Hello, I have some one whom i love very much. Love beyond anyone cud think of . This brother of mine…

The valley of life
I WALKED THROUGH THE VALLEY OF LIFE THE VALLEY WAS FILLED WITH ROSE LIFE SEEMED TO BE BEAUTIFUL BUT…

A Poem by Gloria Oelman
:-)­ I knew You once in all your glory When I was unafraid And had no guilt to block Your…

Watch out the network trap
I wonder if everybody notice recent in the msn, our window have nothing to be different? Anyway I am…

RSIDLL32.DLL
Hi All, I done a programme for HandPunch device using RSIDLL32.DLL. I can establish a connection with…

Not until we see there fear !!!
"Can you smell that" I asked my friend as the car lurched forward and sped off into the night…

locking a cell dependant upon…
Hi I have a sheet full of look ups, charts etc. that I have designed for managing projects and…

  They have birthday today: 
islamsabri
  Forums:   
    topic feeds

• QAIX  all topics, blogs and comments

• PHP web-programming

• Perl web-programming

• ASP web-programming

• Visual Basic Programming

• .Net Development

• C/C++ Programming

• Java Programming

• Javascript web-programming

• Apache HTTP Server

• Web-design

• Web-hosting, dedicated, colocation

• HTML web-programming

• XML development

• General Web-programming

• Content Management Systems

• ColdFusion

• Search Engine Optimization

• Hardware

• Software, Computer Help

• MySQL database development

• PostgreSQL database development

• MS Access database development

• Oracle database development

• MS SQL database development

• Informix database development

• Buy / Sell

• Open discussion

• Anonymous
  Discuss: 
DBD::Oracle, InstantClient…
Hello, I'm trying to get the Oracle InstantClient to work so we can connect to some remote data…

DBI->connect Error
A very simple script: #!/usr/bin/perl -w use strict; use DBI; my $dbname = "test"; my $host…

DBD::ODBC and cancel()
(DBI 1.604, DBD::ODBC 1.15, WinXP, AS 5.8.8) I'm trying to test cancel of long running queries via…

DBD::ODBC 1.16 uploaded to CPAN
Hi, I have just uploaded DBD::ODBC 1.16 to CPAN. This release contains the following changes: =head1…

ANNOUNCE: IBM Informix Database…
IBM Informix Database Driver for Perl DBI Version 2008.0513 (2008-05-13) has been uploaded to CPAN…
  Recent forum topics: 
Register Globals &…
I'm converting old code to work with Register globals turned off in php.ini. With it on…

[JBoss jBPM] - Problem during…
Hello all, I want to deploy a very simple process in jbpm Bpel. I could configure and test helloworld…

DBD::Oracle, InstantClient…
Hello, I'm trying to get the Oracle InstantClient to work so we can connect to some remote data…

DBI->connect Error
A very simple script: #!/usr/bin/perl -w use strict; use DBI; my $dbname = "test"; my $host…

DBD::ODBC and cancel()
(DBI 1.604, DBD::ODBC 1.15, WinXP, AS 5.8.8) I'm trying to test cancel of long running queries via…
  Recent forum comments:
RE: Re: Convert .exe to .html Is…
no -appledyl

RE: Register Globals &…
You are working with Register globals turned off, so try…

RE: [JBoss jBPM] - Problem during…
]:-)­ same with me.... r u working on jBPM BPEL

RE: DBD::ODBC and cancel()
Tim Bunce wrote: Thanks for that - as Tim says it is a bug, cancel is not just for select statements…

RE: neopets hacking
Wtf??! Yew just wanna get referrals and prizes don't think I don't knoe that it's not gonna work pplz…

RE: DBD::ODBC and cancel()
On Wed, May 14, 2008 at 03:12:27PM -0700, Dean Arnold wrote: I don't think it should be checking the…

RE: Cannot see AND Windows system…
Steven Perreau wrote: Is this a 64 bit windows machine? I only ask because on 64 bit windows there are…

RE: DBD-ODBC and DBI 1.21
Hi Beadles: "ppm install DBD-ODBC.ppd -nodeps" worked for me also. thanks for the trick…

RE: Cannot see AND Windows system…
Here's the code that does this, maybe some guru can see something wrong! #!/usr/bin/perl # # This…

RE: DBI::_new_handle leak?
On Fri, May 09, 2008 at 11:31:46AM -0500, James R. Leu wrote: You've two choices: cut-down or…
  Moderators:
 Administrator
 Protorioris

Building DBD::Oracle on XP w/ VC 2005

Christopher J Gerber 8 May 2008 21:50:22
 First off, I am new to the list. If there is a FAQ, feel free to point
me there!

This morning I built DBD-Oracle-1.21 on my XP machine using Visual
Studio 2005. After building, I needed to copy the redistributable files
to blib/arch/auto/DBD/­Oracle, and I needed to embed the manifest into
Oracle.dll with the following command:

mt.exe -manifest Oracle.dll.manifest­ -outputresource:Ora­cle.dll;2

I also needed to include my SID in ORACLE_USERID:

set ORACLE_USERID=user/­password@tns_entry/O­RCL
^^^^^

After all this, things worked, *except* for two tests:

t/26exe_array......­.....ok 1/14
t/26exe_array......­.....NOK 11/14# Failed test '... we should have 19
tuple_status'
# at t/26exe_array.t line 120.
# got: 10
# expected: 19

t/26exe_array......­.....NOK 14/14# Failed test '... we should have 48
rows'
# at t/26exe_array.t line 146.
# got: 30
# expected: 48
# Looks like you failed 2 tests of 14.
t/26exe_array......­.....dubious
Test returned status 2 (wstat 512, 0x200)

I'm curious if others have seen these problems.

Chris

OptionsAdd comment
John Scoles 1 May 2008 19:22:27 [ permanent link ]
 Can you point it to a different non 11 DB instance??

and run the tests again?

Could be a bug on the oracle side?

seems to be a number of them on 11 64 dbs coming up the past few days.

cheers
John Scoles
Gerber, Christopher J wrote:
Odd
Gerber, Christopher J wrote:
First off, I am new to the list. If there is a FAQ, feel free to
point
me there!
This morning I built DBD-Oracle-1.21 on my XP machine using Visual
Studio 2005. After building, I needed to copy the redistributable
files
to blib/arch/auto/DBD/­Oracle, and I needed to embed the manifest
into
Oracle.dll with the following command:
mt.exe -manifest Oracle.dll.manifest­ -outputresource:Ora­cle.dll;2
I also needed to include my SID in ORACLE_USERID:
set ORACLE_USERID=user/­password@tns_entry/O­RCL
^^^^^
After all this, things worked, *except* for two tests:
t/26exe_array......­.....ok 1/14
t/26exe_array......­.....NOK 11/14# Failed test '... we should have
19
tuple_status'
# at t/26exe_array.t line 120.
# got: 10
# expected: 19
this means that 9 rows did not get inserted for some reason
t/26exe_array......­.....NOK 14/14# Failed test '... we should have
48
rows'
# at t/26exe_array.t line 146.
# got: 30
# expected: 48
# Looks like you failed 2 tests of 14.
t/26exe_array......­.....dubious
Test returned status 2 (wstat 512, 0x200)
this is linked to the not inserted 9 above so if we fix 11 we fix this
I'm curious if others have seen these problems.
Can you tell me the which Oracle version you are running the tests on?
and which version of DBI?
I am using Oracle Instant Client 11.1.0.6.0 32bit on Windows to connect
to a server running Oracle 11.1.0.6.0 64bit on Linux. I am using DBI
version 1.601, although I see that 1.602 is now available.
This could be a permission problem with the user that is running the
test.
Try running the tests again with the 'system' user and password and
see
what you get.
Using the SYSTEM account I get the same test results.
I just updated DBI to 1.602 and tested again... the results are the
same.
cheers
John Scoles
Chris

Add comment
Christopher J Gerber 1 May 2008 19:44:07 [ permanent link ]
 
Can you point it to a different non 11 DB instance??
and run the tests again?
Could be a bug on the oracle side?
seems to be a number of them on 11 64 dbs coming up the past few days.

Using an Oracle 9i server, the errors went away. I think that you're
right about the 11g bug. Thanks for the assistance. I guess I have to
find someone at Oracle to pester now! :)­

cheers
John Scoles
Gerber, Christopher J wrote:
Odd
Gerber, Christopher J wrote:
First off, I am new to the list. If there is a FAQ, feel free to
point
me there!
This morning I built DBD-Oracle-1.21 on my XP machine using Visual
Studio 2005. After building, I needed to copy the redistributable
files
to blib/arch/auto/DBD/­Oracle, and I needed to embed the manifest
into
Oracle.dll with the following command:
mt.exe -manifest Oracle.dll.manifest­ -outputresource:Ora­cle.dll;2

I also needed to include my SID in ORACLE_USERID:
set ORACLE_USERID=user/­password@tns_entry/O­RCL
^^^^^
After all this, things worked, *except* for two tests:
t/26exe_array......­.....ok 1/14
t/26exe_array......­.....NOK 11/14# Failed test '... we should
have
19
tuple_status'
# at t/26exe_array.t line 120.
# got: 10
# expected: 19
this means that 9 rows did not get inserted for some reason
t/26exe_array......­.....NOK 14/14# Failed test '... we should
have
48
rows'
# at t/26exe_array.t line 146.
# got: 30
# expected: 48
# Looks like you failed 2 tests of 14.
t/26exe_array......­.....dubious
Test returned status 2 (wstat 512, 0x200)
this is linked to the not inserted 9 above so if we fix 11 we fix
this
I'm curious if others have seen these problems.
Can you tell me the which Oracle version you are running the tests
on?
and which version of DBI?
I am using Oracle Instant Client 11.1.0.6.0 32bit on Windows to
connect
to a server running Oracle 11.1.0.6.0 64bit on Linux. I am using DBI
version 1.601, although I see that 1.602 is now available.
This could be a permission problem with the user that is running the
test.
Try running the tests again with the 'system' user and password and
see
what you get.
Using the SYSTEM account I get the same test results.
I just updated DBI to 1.602 and tested again... the results are the
same.
cheers
John Scoles
Chris

Add comment
John Scoles 1 May 2008 19:47:56 [ permanent link ]
 I will CC this one to a contact I have at Oracle as the first question
Oracle suport will as is what it DBD::Oracle??? followed by we don't
support it.

If you do follow up say the execute array dose not work as expected.
and that it works in 9.

cheers
John Scoles

Gerber, Christopher J wrote:
Can you point it to a different non 11 DB instance??
and run the tests again?
Could be a bug on the oracle side?
seems to be a number of them on 11 64 dbs coming up the past few days.
Using an Oracle 9i server, the errors went away. I think that you're
right about the 11g bug. Thanks for the assistance. I guess I have to
find someone at Oracle to pester now! :)­
cheers
John Scoles
Gerber, Christopher J wrote:
Odd
Gerber, Christopher J wrote:
First off, I am new to the list. If there is a FAQ, feel free to
point
me there!
This morning I built DBD-Oracle-1.21 on my XP machine using Visual
Studio 2005. After building, I needed to copy the redistributable
files
to blib/arch/auto/DBD/­Oracle, and I needed to embed the manifest
into
Oracle.dll with the following command:
mt.exe -manifest Oracle.dll.manifest­ -outputresource:Ora­cle.dll;2
I also needed to include my SID in ORACLE_USERID:
set ORACLE_USERID=user/­password@tns_entry/O­RCL
^^^^^
After all this, things worked, *except* for two tests:
t/26exe_array......­.....ok 1/14
t/26exe_array......­.....NOK 11/14# Failed test '... we should
have
19
tuple_status'
# at t/26exe_array.t line 120.
# got: 10
# expected: 19
this means that 9 rows did not get inserted for some reason
t/26exe_array......­.....NOK 14/14# Failed test '... we should
have
48
rows'
# at t/26exe_array.t line 146.
# got: 30
# expected: 48
# Looks like you failed 2 tests of 14.
t/26exe_array......­.....dubious
Test returned status 2 (wstat 512, 0x200)
this is linked to the not inserted 9 above so if we fix 11 we fix
this
I'm curious if others have seen these problems.
Can you tell me the which Oracle version you are running the tests
on?
and which version of DBI?
I am using Oracle Instant Client 11.1.0.6.0 32bit on Windows to
connect
to a server running Oracle 11.1.0.6.0 64bit on Linux. I am using DBI
version 1.601, although I see that 1.602 is now available.
This could be a permission problem with the user that is running the
test.
Try running the tests again with the 'system' user and password and
see
what you get.
Using the SYSTEM account I get the same test results.
I just updated DBI to 1.602 and tested again... the results are the
same.
cheers
John Scoles
Chris

Add comment
John Scoles 8 May 2008 21:50:22 [ permanent link ]
 Seem I now have access to an Oracle 11 box so I can have a look into this.

So far I get the same results as you.

Tomorrow I will have to do some debugging with this.

Cheers John Scoles

John Scoles wrote:
I will CC this one to a contact I have at Oracle as the first
question Oracle suport will as is what it DBD::Oracle??? followed by
we don't support it.
If you do follow up say the execute array dose not work as expected.
and that it works in 9.
cheers
John Scoles
Gerber, Christopher J wrote:
Can you point it to a different non 11 DB instance??
and run the tests again?
Could be a bug on the oracle side?
seems to be a number of them on 11 64 dbs coming up the past few days.
Using an Oracle 9i server, the errors went away. I think that you're
right about the 11g bug. Thanks for the assistance. I guess I have to
find someone at Oracle to pester now! :)­
cheers
John Scoles
Gerber, Christopher J wrote:
Odd
Gerber, Christopher J wrote:
First off, I am new to the list. If there is a FAQ, feel free to
point
me there!
This morning I built DBD-Oracle-1.21 on my XP machine using Visual
Studio 2005. After building, I needed to copy the redistributable
files
to blib/arch/auto/DBD/­Oracle, and I needed to embed the manifest
into
Oracle.dll with the following command:
mt.exe -manifest Oracle.dll.manifest­ -outputresource:Ora­cle.dll;2
I also needed to include my SID in ORACLE_USERID:
set ORACLE_USERID=user/­password@tns_entry/O­RCL
^^^^^
After all this, things worked, *except* for two tests:
t/26exe_array......­.....ok 1/14
t/26exe_array......­.....NOK 11/14# Failed test '... we should
have
19
tuple_status'
# at t/26exe_array.t line 120.
# got: 10
# expected: 19
this means that 9 rows did not get inserted for some reason
t/26exe_array......­.....NOK 14/14# Failed test '... we should
have
48
rows'
# at t/26exe_array.t line 146.
# got: 30
# expected: 48
# Looks like you failed 2 tests of 14.
t/26exe_array......­.....dubious
Test returned status 2 (wstat 512, 0x200)
this is linked to the not inserted 9 above so if we fix 11 we fix
this
I'm curious if others have seen these problems.
Can you tell me the which Oracle version you are running the tests
on?
and which version of DBI?
I am using Oracle Instant Client 11.1.0.6.0 32bit on Windows to
connect
to a server running Oracle 11.1.0.6.0 64bit on Linux. I am using DBI
version 1.601, although I see that 1.602 is now available.
This could be a permission problem with the user that is running the
test.
Try running the tests again with the 'system' user and password and
see
what you get.
Using the SYSTEM account I get the same test results.
I just updated DBI to 1.602 and tested again... the results are the
same.
cheers
John Scoles
Chris

Add comment
 

Add new comment

As:
Login:  Password:  
 
 
  
 
Пожалуйста, относитесь к собеседникам уважительно, не используйте нецензурные слова, не злоупотребляйте заглавными буквами, не публикуйте рекламу и объявления о купле/продаже, а также материалы нарушающие сетевой этикет или УК РФ.

QAIX > Perl web-programming > Building DBD::Oracle on XP w/ VC 2005 8 May 2008 21:50:22
see also:
table variables
invalid byte sequence for encoding…
Re: Insert into partition table hangs
see also:
allow LIMIT in UPDATE and DELETE
Best practice to grant all privileges…
ALTER SEQUENCE ... RESTART WITH…
see also:
PostgreSQL and EnterpriseDB in New York…
Advocacy generation for Postgrsql
To recover data corrupted
  Copyright © 2001—2008 QAIX
Idea: Miсhael Monashev
You can find the help and FAQ in the Admin's blog.
Write us at:
If you would like to report an abuse of our service, such as a spam message, please .