Re: Oracle dbi ?

2003-11-10 Thread Jared Still
The problem is, these aren't actually SQL commands. Rather, these are SQL*Plus commands. The DBD::Oracle doesn't know what to do with these. If you could figure out how to do this with OCI, then you could probably patch DBD::Oracle to provide this functionality. Tim would appreciate that patc

Re: Stored procedures and DBD::Sybase

2003-11-10 Thread Michael Peppler
On Mon, 2003-11-10 at 06:30, Steven Velez wrote: > Hello, > > I am using DBI v. 1.38, DBD::Sybase v. 1.01 (?), and FreeTDS 0.61.2 to > connect to an MSSQL 6.5 database from a Linux client and I am having > problems retrieving the values of out parameters to a stored procedure > call. MS-SQL doesn

Compile of DBD Solid

2003-11-10 Thread Patricia . Markiewicz
I am on a Solaris 2.8 system with a Solid 3.52 DB (embedded in Openview). I downloaded the SolidTechs library from their FTP site , uncompressed, untared and created a software link for libsolodbc.so referencing to soch1x30fe.sl in Solid lib directory. I already had Perl compiled and the DBI

DBI::Shell producing errors during test on RedHat 9

2003-11-10 Thread Scott R. Godin
cpan> install DBI::Shell Running install for module DBI::Shell Running make for T/TL/TLOWERY/DBI-Shell-11.93.tar.gz Is already unwrapped into directory /root/.cpan/build/DBI-Shell-11.93 CPAN.pm: Going to build T/TL/TLOWERY/DBI-Shell-11.93.tar.gz Checking if your kit is complete... Looks good

Re: Stored procedures and DBD::Sybase

2003-11-10 Thread Chuck Fox
Steven, Do perldoc DBD::Sybase. There is a writeup on how to detect multiple result sets. This method deviates from the DBI standards. Basically, you check a special Sybase attribute in the statement handle, syb_more_results, to see if more fetchable results exist. Chuck [EMAIL PROTECTED]

RE: Stored procedures and DBD::Sybase

2003-11-10 Thread Steven Velez
Chuck, Thanks for the response. Although, the DBD::Sybase docs do detail retrieving sproc out params as I have done, using the select statement to explicitly form a result is an interesting solution. One additional question rises from the fact that DBD::Sybase can handle returning many result se

Re: nmaking dbd-mysql errors

2003-11-10 Thread Colin Wetherbee
Chuck Fox said: > Looks like you are missing the c compiler that your make file is > requesting/requiring. > >>'cl' is not recognized as an internal or external command, >>operable program or batch file. Yes, cl.exe is the C/C++ compiler that comes with Visual Studio. Colin -- Colin W. Wetherbe

Re: Stored procedures and DBD::Sybase

2003-11-10 Thread Chuck Fox
Steven, I believe that you are misunderstanding what it is that you are receiving. The only output from your commands is the print @c. This comes through the error handler since a print statement is a level 0 or level 10 message from the server and not a result set. Try changing the print t

Re: nmaking dbd-mysql errors

2003-11-10 Thread Chuck Fox
Looks like you are missing the c compiler that your make file is requesting/requiring. Chuck [EMAIL PROTECTED] wrote: Hi: Please see snippet below. Perhaps someone could advise me where to go from here? OS is Win2K Thanks in advance, Howard Begin snippet+

Stored procedures and DBD::Sybase

2003-11-10 Thread Steven Velez
Hello, I am using DBI v. 1.38, DBD::Sybase v. 1.01 (?), and FreeTDS 0.61.2 to connect to an MSSQL 6.5 database from a Linux client and I am having problems retrieving the values of out parameters to a stored procedure call. I followed the example in the DBD::Sybase docs modifying for my purpose a

Re: DBD::ORACLE Hanges

2003-11-10 Thread Tim Bunce
Already fixed for the next release. Tim. On Fri, Nov 07, 2003 at 03:23:27PM +0100, Waldemar ?urowski wrote: > W li?cie z pi?, 07-11-2003, godz. 14:23, Tim Bunce pisze: > > And if so: http://www.mail-archive.com/[EMAIL PROTECTED]/msg18192.html > > Thank You Tim, that would be my next advise :) a

DBI Proxy Server Instability on Win with SQL Server

2003-11-10 Thread David Wesner
I’ve been searching and using mailing lists to try to find the best way to access, in multi-threaded mode, a SQL Server Database running on Windows 2000 from Linux perl scripts. I’m hearing that there seems to be inherent instability when running threads or “forks”, with the below note summarizing

nmaking dbd-mysql errors

2003-11-10 Thread Howard Fuchs
Hi: Please see snippet below. Perhaps someone could advise me where to go from here? OS is Win2K Thanks in advance, Howard Begin snippet+++ C:\Documents and Settings\Administrator\Desktop\Downloads\DBD-mysql-2.9003>nmake Microsoft

ANNOUNCE: DBD::ADO 2.78

2003-11-10 Thread Steffen Goeldner
file: $CPAN/authors/id/S/SG/SGOELDNER/DBD-ADO-2.78.tar.gz size: 45044 bytes md5: cf0559199ee51e261d9ccb0d1ca9771a Changes: Modified t/09bind.t to use Test::More. Added data_sources(). Moved some datatype related stuff into DBD::ADO::TypeInfo. Win32::OLE::Const is no longer bein