Re: DBD::Proxyserver/Win32/Threads?

2001-11-15 Thread Simon Oliver
Yes, but the patch is needed in the RPC::PlServer::Comm module. I'll look through the code and suggest an appropriate patch to the module author. -- Simon Oliver Jochen Wiedmann wrote: Zitiere Simon Oliver [EMAIL PROTECTED]: iThreads is supposed to emulate fork on Win32 but this

Re: DBD::Proxyserver/Win32/Threads?

2001-11-15 Thread Tim Bunce
On Wed, Nov 14, 2001 at 10:38:28PM +0100, Jochen Wiedmann wrote: Hi, Tim, Zitiere Tim Bunce [EMAIL PROTECTED]: Er, why not fix Storable to be thread safe (if it isn't). That's bound to be fairly trivial and Storable is many times faster than Data::Dumper. making Storable thread

Re: field type

2001-11-15 Thread Simon Oliver
Most portable method is to use $sth-{TYPE} Returns a reference to an array of integer values for each column. The value indicates the data type of the corresponding column. You would need to 'select * from table_name where 1=0' to get an open statement handle first. See perldoc DBI for more

Re: Access to MS-Access denied

2001-11-15 Thread Bart Lateur
On Tue, 13 Nov 2001 17:43:27 +, Vittorio wrote: I've tried to give the login De Martino (no password is required) to the DSN file to no avail AFAIK, you don't add users to the DSN. You pass them to the database when trying to connect to it, in the connect string. -- Bart.

Re: merant / ODBC - DBI/DBD

2001-11-15 Thread Simon Oliver
Why? Does the module maintainer know about this? Michael Peppler wrote: Simon Oliver writes: It works great as long as you have the freetds (I'm using 0.51) and the 0.91 version of DBD::Sybase. The newest version will NOT work. Once you set up your interfaces file in freetds

What's the best driver choice to use in a W2000/ActiveState Perl/MS Access environment?

2001-11-15 Thread Chris Spurgeon
I've just been handed a really tight deadline project, building some Perl CGI functionality on a Windows 2000 box using Active State Perl and a Microsoft Access DB. Looking through my O'Reilly DBI book, it looks like there are potentially several different ways to hook up to the DB

RE: What's the best driver choice to use in a W2000/ActiveState Perl/ MS Access environment?

2001-11-15 Thread Sterin, Ilya
I would definitelly use DBD::ODBC, which will then be easily ported to other db's if ever required. Ilya -Original Message- From: Chris Spurgeon To: '[EMAIL PROTECTED]' Sent: 11/15/01 8:13 AM Subject: What's the best driver choice to use in a W2000/ActiveState Perl/ MS Access

Re: What's the best driver choice to use in a W2000/ActiveState Perl/MS Access environment?

2001-11-15 Thread Etienne Marcotte
I used DBD::ODBC create a dns from win2k and it's a breeze to connect to the DB then it's only preparing, executing and displaying! Etienne Chris Spurgeon wrote: I've just been handed a really tight deadline project, building some Perl CGI functionality on a Windows 2000 box using Active

Re: What's the best driver choice to use in a W2000/ActiveState Perl/MS Access environment?

2001-11-15 Thread Simon Oliver
DBD::ADO DBD::ODBC Win32ADO That's 'ADO' via Win32::OLE Also add 'DAO' via Win32::OLE Win32::DBIODBC That's Win32::ODBC I recommend you use DBI (DBD::*) unless you need to make use of an ADO or DAO specific feature. It doesn't really matter which DBD (of

Re: merant / ODBC - DBI/DBD

2001-11-15 Thread Kevin Spencer
On Thu, 2001-11-15 at 06:58, Simon Oliver wrote: Why? Does the module maintainer know about this? Er, Michael Peppler *is* the DBD::Sybase maintainer.

Re: What's the best driver choice to use in a W2000/ActiveState Perl/MS Access environment?

2001-11-15 Thread Bart Lateur
On Thu, 15 Nov 2001 15:29:13 +, Simon Oliver wrote: Win32::DBIODBC That's Win32::ODBC No, both exist. Win32::DBIODBC is a compatibility layer between DBI and Win32::ODBC. See page 171 of the DBI book. To the OP: since you have access to the book, take a good look at chapter 7. All

Example of fetchall_arrayref with @bind_values

2001-11-15 Thread David D. Anderson
Hi all, I can't find any examples of fetcall_arrayref that actually use the @bind_values argument . All I've seen are reference pages that mention it in the definition, but no code that actually use it after the call. I'm sure there's examples out there, but so far nothing Could a kind

Re: What's the best driver choice to use in a W2000/ActiveState Perl/MS Access environment?

2001-11-15 Thread Simon Oliver
No, both exist. Win32::DBIODBC is a compatibility layer between DBI and Win32::ODBC. See page 171 of the DBI book. I've never seen the point in Win32::DBIODBC. If you want to use Win32::ODBC then use it. If you want to use DBI use that. As the module docs say This is a very basic very alpha

Re: merant / ODBC - DBI/DBD

2001-11-15 Thread Michael Peppler
If you mean DBD::Sybase then yes, the module maintainer knows about it :-). The problem is that I use some functions that aren't implemented (yet) in FreeTDS, but the FreeTDS folks are trying to get this at the very least stubbed out in the next release (.53) Michael Simon Oliver writes:

RE: Example of fetchall_arrayref with @bind_values

2001-11-15 Thread Wilson, Doug
From: David D. Anderson [mailto:[EMAIL PROTECTED]] I can't find any examples of fetcall_arrayref that actually use the @bind_values argument . All I've seen are reference pages that mention it in the definition, but no code that actually use it after the call. $ary_ref =

Re: ANNOUNCE: DBIx::Librarian 0.1

2001-11-15 Thread Tim Bunce
On Thu, Nov 15, 2001 at 08:31:59AM -0800, Terrence Brannon wrote: On Wednesday, November 14, 2001, at 10:33 PM, Jason W May wrote:     The implementation provided by DBIx::Librarian is sufficiently     different from other related modules (in particular, SQL::Catalog)     that this

Mail archives

2001-11-15 Thread Tim Harsch
Where are the archives for this list? Both of them of the Symbolstone home page are dead...

Re: Mail archives

2001-11-15 Thread Craig Kelley
On Thu, 15 Nov 2001, Tim Harsch wrote: Where are the archives for this list? Both of them of the Symbolstone home page are dead... A good question. -- It is financially more expensive to go to prison than to attend Harvard. Craig Kelley -- [EMAIL PROTECTED] http://www.isu.edu/~kellcrai

Re: Mail archives

2001-11-15 Thread Bart Lateur
On Thu, 15 Nov 2001 09:33:28 -0800, Tim Harsch wrote: Where are the archives for this list? http:[EMAIL PROTECTED]/ Even your post is in there, so I guess it isn't dead... -- Bart.

Installation Issue

2001-11-15 Thread Inbaraj,Suganthi
Hi, I am new to perl development. I installed Activeperl 5.6 on the web server(IIS4). I need to connect to Oracle database. I downloaded DBI interface module and DBD for Oracle from CPAN site. Here is my question. Do i have to copy file from DBI-1.20 (the extracted one comes with lib and t

RE: Mail archives

2001-11-15 Thread Tim Harsch
Thanks. So perhaps these archives should be listed on the homepage instead of the two broken links that are there. I'll send Alligator a note. -Original Message- From: Bart Lateur [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 15, 2001 9:56 AM To: Tim Harsch Cc: [EMAIL

Re: Mail archives

2001-11-15 Thread Bart Lateur
On Thu, 15 Nov 2001 10:35:38 -0800, Tim Harsch wrote: So perhaps these archives should be listed on the homepage instead of the two broken links that are there. I'll send Alligator a note. I simply found the link via http://lists.perl.org. Strange that there's no link in that direction on the

How to execute a stored proc

2001-11-15 Thread Tim Harsch
I hate to ask this question since it has been answered about a thousand times, but since there are probs with the archives here goes How do you execute an oracle stored procedure via DBI? Tim Harsch Lawrence Livermore National Laboratory IMAGE Consortium 7000 East

RE: How to execute a stored proc

2001-11-15 Thread Kotha, Nagaraju
Here is simple call: my $sp_sth = $dbh-prepare(q{begin my_Pack.my_SP(:in,:out); end; }); $sp_sth-bind_param(:in,$p); $sp_sth-bind_param_inout(:out,\$v_n,3000); $sp_sth-execute(); --Raju -Original Message- From: Tim Harsch

Re: How to execute a stored proc

2001-11-15 Thread Philip Newton
On Thu, 15 Nov 2001 11:02:32 -0800, [EMAIL PROTECTED] (Tim Harsch) wrote: How do you execute an oracle stored procedure via DBI? Have a look in DBD::Oracle; there are a couple of examples there. I managed to get things working based on that. Cheers, Philip

dbi:Oracle connections always go through Net8?

2001-11-15 Thread Dong Wang
Hi, From reading the doc on DBD::Oracle, it seems like a connection made within DBI always uses Net8 to make connections. Is this true? In sqlplus on the host that runs the instance, connections specified (without a tnsnames.ora entry and TWO_TASK is not set, only ORACLE_SID is set) as: SQL

inserting into CLOB field

2001-11-15 Thread Becka Louden
Hi, I am new to this newsgroup, so I hope this is not a bad question. I trying to use the Perl::DBI to insert a string value into the Oracle database. However, I get this error : ORA-01461: can bind a LONG value only for insert into a LONG column (DBD: oexec error) at query_crr.pl line 98.

What is the module to use to interface with Oracle 8.1.7

2001-11-15 Thread Satish Vadlamani
Hi: I would like to know what is the module to use along with DBI to interface with Oracle 8.1.7? Is it going to be DBD::Oracle or some variation of it? Appreciate your response. Satish _ Get your FREE download of MSN Explorer

RE: What is the module to use to interface with Oracle 8.1.7

2001-11-15 Thread Fischer, Cory
Satish, I just used the DBI module in my script. Be sure to use the Database name, not the DSN Name. DSN's are ODBC, not DBI! Cory -Original Message- From: Satish Vadlamani [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 15, 2001 3:17 PM To: [EMAIL PROTECTED] Subject: What is

RE: inserting into CLOB field

2001-11-15 Thread Scott T. Hildreth
use strict; use DBI; use DBD::Oracle qw(:ora_types); $insert_cr-bind_param(1, $cr, {ora_type = ORA_CLOB}); Not that I'm doubting you, but I had the same error and I found that the above bind works for me. Can you send a Trace use level 9. my $result_ins = $insert_cr

Re: inserting into CLOB field

2001-11-15 Thread Hardy Merrill
Maybe I'm missing something - this seems too easy, but in your statement: my $result_ins = $insert_cr -execute() || print Insert into CRR table failed!!\n; you have a space before the -execute() - try removing the space, and make it look like: my $result_ins = $insert_cr-execute()

Re: inserting into CLOB field

2001-11-15 Thread M.W. Koskamp
- Original Message - From: Becka Louden [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, November 15, 2001 10:00 PM Subject: inserting into CLOB field [...] my $result_ins = $insert_cr -execute() || print Insert into CRR table failed!!\n; try this: bind_param(1, $cr,

Re: perl -MCPAN -e 'install Bundle::DBI'

2001-11-15 Thread Hardy Merrill
I think you need to reconfigure the urllist in your cpan config. On your system, run perl -MCPAN -e shell that will put you into the CPAN shell, and give you the cpan prompt. Do this next cpan o conf and that will show you your current cpan configuration - pay special attention to the

Re: What is the module to use to interface with Oracle 8.1.7

2001-11-15 Thread Hardy Merrill
DBD::Oracle is what you need. Satish Vadlamani [[EMAIL PROTECTED]] wrote: Hi: I would like to know what is the module to use along with DBI to interface with Oracle 8.1.7? Is it going to be DBD::Oracle or some variation of it? Appreciate your response. Satish

Re: inserting into CLOB field

2001-11-15 Thread Becka Louden
Good idea.. tried it, though, only to get the same error message. Becka From: M.W. Koskamp [EMAIL PROTECTED] To: Becka Louden [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: Re: inserting into CLOB field Date: Thu, 15 Nov 2001 23:06:56 +0100 - Original Message - From: Becka Louden

Re: inserting into CLOB field

2001-11-15 Thread Becka Louden
Well, that was worth trying- taking out the space- but didn't change anything. The reason I have a hard-coded value in the prepare statement for crr_id is because someone suggested the bind problem might actually be with the id number and not the CLOB value. I did actually have it just as

RE: How to specify mysql.sock location to Msql-Mysql-modules?

2001-11-15 Thread Wiedmann, Jochen
I have installed MySQL-3.23.44-1.i386.rpm MySQL-client-3.23.44-1.i386.rpm and DBI-1.20.tar.gz Data-ShowTable-3.3.tar.gz You also need the MySQL-devel packages from the same source. Additionally a simple ln -s /var/lib/mysql/mysql.sock /tmp/mysql.sock might help for passing

ANNOUNCE: DBIx::Librarian 0.1

2001-11-15 Thread Jason W May
Alpha version of DBIx::Librarian is now available on CPAN.     This module is intended to provide an additional tool to support     proper separation of concerns. While there are several excellent     modules assisting in separate of UI (esp. HTML) from application     code, there is a similar

Re: ANNOUNCE: DBIx::Librarian 0.1

2001-11-15 Thread Terrence Brannon
On Wednesday, November 14, 2001, at 10:33 PM, Jason W May wrote:     The implementation provided by DBIx::Librarian is sufficiently     different from other related modules (in particular, SQL::Catalog)     that this module is not rehashing previously-explored territory. The example you