Re: Adding adExecuteStream support to ADO.pm

2006-03-21 Thread Steffen Goeldner
Luke Bakken wrote:

 Hi all,
 
 Attached/included is my hackish attempt to add support for the
 adExecuteStream option to ADO.pm. I needed this for retrieving data
 from several stored procedures that return XML and it works for my
 purposes but I'm not sure if I've integrated it well into ADO.pm
 (especially in the execute() subroutine.)

Thanks, I applied your patch. Sure, integration into execute() is
suboptimal. Normally, data retrieval is achieved via fetch() and/or
blob_read(). But I have no experience in using ADO Streams.
Further comments are welcome.


Steffen


DBI.pm

2006-03-21 Thread Ganesh Prasad A K
 Can't locate loadable object for module DBI in @INC (@INC contains:
C:/Perl/lib C:/Perl/site/lib .) at C:/Perl/lib/DBI.pm line 255 .

i am getting this error while i execute the program.

please give me solutions.

--
Thanks  Regards

Ganesh Prasad A K
Parity Computing India (P) Ltd.
1133/E, Service Road, RPC Layout
Vijayanagar
Bangalore-560040

PH: (080) 23143193


RE: DBI.pm

2006-03-21 Thread Reidy, Ron
What version of Perl are you running?

Have you properly installed DBI?


-Original Message-
From: Ganesh Prasad A K [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, March 21, 2006 4:31 AM
To: dbi-users@perl.org
Subject: DBI.pm


 Can't locate loadable object for module DBI in @INC (@INC contains:
C:/Perl/lib C:/Perl/site/lib .) at C:/Perl/lib/DBI.pm line 255 .

i am getting this error while i execute the program.

please give me solutions.

--
Thanks  Regards

Ganesh Prasad A K
Parity Computing India (P) Ltd.
1133/E, Service Road, RPC Layout
Vijayanagar
Bangalore-560040

PH: (080) 23143193

This electronic message transmission is a PRIVATE communication which contains
information which may be confidential or privileged. The information is 
intended 
to be for the use of the individual or entity named above. If you are not the 
intended recipient, please be aware that any disclosure, copying, distribution 
or use of the contents of this information is prohibited. Please notify the
sender  of the delivery error by replying to this message, or notify us by
telephone (877-633-2436, ext. 0), and then delete it from your system.



Re: Adding adExecuteStream support to ADO.pm

2006-03-21 Thread Luke Bakken
  Hi all,
 
  Attached/included is my hackish attempt to add support for the
  adExecuteStream option to ADO.pm. I needed this for retrieving data
  from several stored procedures that return XML and it works for my
  purposes but I'm not sure if I've integrated it well into ADO.pm
  (especially in the execute() subroutine.)

 Thanks, I applied your patch. Sure, integration into execute() is
 suboptimal. Normally, data retrieval is achieved via fetch() and/or
 blob_read(). But I have no experience in using ADO Streams.
 Further comments are welcome.

Thanks!

I'll look into execute more() - this is my first foray into DBI
programming at all. Perhaps the stream output should be treated as a
single row, single column return set?

Luke


Re: DBI.pm

2006-03-21 Thread Jay Strauss
On Tuesday 21 March 2006 5:31 am, Ganesh Prasad A K wrote:
  Can't locate loadable object for module DBI in @INC (@INC contains:
 C:/Perl/lib C:/Perl/site/lib .) at C:/Perl/lib/DBI.pm line 255 .

 i am getting this error while i execute the program.

 please give me solutions.


did you:

PPM3 install DBI
PPM3 install DBD_ some driver to your database

I think you will have more success on this message board if you provide even 
the most minimal information like:

1) Type and version of database you want to connect 
2) What Perl modules you have installed
3) What you have done so far to get to this point, where you get the error

Lastly, while English may not be your first language, if you are polite, 
people will gladly answer your questions.

Jay


Re: Adding adExecuteStream support to ADO.pm

2006-03-21 Thread Steffen Goeldner

Luke Bakken wrote:


I'll look into execute more() - this is my first foray into DBI
programming at all. Perhaps the stream output should be treated as a
single row, single column return set?


Perhaps. Or, because your data are returned from stored procedures,
it's time to implement bind_param_inout():

  http://search.cpan.org/~timb/DBI-1.50/DBI.pm#bind_param_inout

Can you provide a small, self-contained use case? Are stored
procedures the only way to select your data?


Steffen