ANNOUNCE : DBIx::DataModel

2005-09-19 Thread PerlDiscuss - Perl Newsgroups and mailing lists
Dear DBI users, This is to announce yet another wrapper module on top of DBI, just posted on CPAN. Please have a look and see whether it can help suit your needs. The discussion forum is on http://www.cpanforum.com/. Below is an excerpt from the doc : DBIx::DataModel is written compactly as one

Re: DBD::Oracle Installation problem

2005-04-27 Thread PerlDiscuss - Perl Newsgroups and mailing lists
C.A. Merz - Original Message - From: PerlDiscuss - Perl Newsgroups and mailing lists [EMAIL PROTECTED] To: dbi-users@perl.org Sent: Tuesday, April 26, 2005 12:54 PM Subject: DBD::Oracle Installation problem Hi, When I install DBD::Oracle module, I get the following error

DBD::Oracle Installation problem

2005-04-26 Thread PerlDiscuss - Perl Newsgroups and mailing lists
Hi, When I install DBD::Oracle module, I get the following error. = ld: fatal: file /oracle/product/10/lib//libclntsh.so: wrong ELF class: ELFCLASS64 ld: fatal: File processing errors. No output written to blib/arch/auto/DBD/Oracle/Oracle.so collect2: ld returned 1

connecting to informix via network

2005-03-16 Thread PerlDiscuss - Perl Newsgroups and mailing lists
Hi all who help others, i would like to create a database handle to informix database on alpha maschine. what do i have: # uname -a OSF1 trm61 V4.0 878 alpha # /usr/informix/bin/tbstat -z RSAM Version 5.08.UD2 -- On-Line -- Up 07:53:56 -- 9968 Kbytes # i wrote a perl-script which works

connecting to informix via network

2005-03-16 Thread PerlDiscuss - Perl Newsgroups and mailing lists
Hi all who help others, i would like to create a database handle to informix database on alpha maschine. what do i have: # uname -a OSF1 trm61 V4.0 878 alpha # /usr/informix/bin/tbstat -z RSAM Version 5.08.UD2 -- On-Line -- Up 07:53:56 -- 9968 Kbytes # i wrote a perl-script which works

search fails if number at end of string

2004-12-15 Thread PerlDiscuss - Perl Newsgroups and mailing lists
If the string passed to Access has a number at the end no records are returned. If I remove the number and there are records in the file that match the remaining characters then records are returned. I can go into Access and use the same string and the search works. Any help would be greatly

Bulk Bind and Execute_Array()

2004-12-08 Thread PerlDiscuss - Perl Newsgroups and mailing lists
Hello, I am sure this question has come up hundreds of times, but I must ask it again: Are bind_param_array() and array_execute() fully implemented in the DBD::Oracle driver?? If they are, is there any known reference/examples of usage beyond the DBD/DBI docs?? For the life of me, I cannot

Re: DBD::ADO and CommandTimeout

2004-09-25 Thread PerlDiscuss - Perl Newsgroups and mailing lists
Hi David, I coded the connection stuff a little different. I too was having timeouts thrown back when the result sets were large. The same query would take almost three minutes in a query window. So I set the CommandTimeout to zero as described in the cpan doc. Looks like this for me:

Re: DBD::Oracle seems not working through Apache

2004-08-07 Thread PerlDiscuss - Perl Newsgroups and mailing lists
Hi John, U dont define $ORACLE_HOME in the connection string. Either you define it in httpd.conf using SetEnv, or if in a perl section using PerlSetEnv or even $ORACLE_HOME = '/your/oracle/home' in your startup script in a BEGIN block. Thanks Raj John wrote: Well, how could i define the

executing MS SQL Server stored procedures

2004-07-16 Thread PerlDiscuss - Perl Newsgroups and mailing lists
I am trying to run an MS SQL server stored procedure using Perl. We are using SQL Server 2000. Using the current Perl and DBI. Can I use the ODBC DBD? I am using a prepare,execute and fetch. Has anyone tried this and do you have examples or how to do this? I use the 'exec' command but get syntax

Re: Describe table

2004-07-06 Thread PerlDiscuss - Perl Newsgroups and mailing lists
Hi You cannot use the DESCRIBE statement as it is. Try it in the following way select * from sys.user_tab_columns where table_name = 'TABLE_NAME'; Cheers Prabu Jimmy Jauhal wrote: Hi All, I am trying to execute a DESCRIBE table statement from my perl script that connects to an oracle

DBI::Pg mutli-install problem

2004-06-29 Thread PerlDiscuss - Perl Newsgroups and mailing lists
Hello. I have a perl module that uses DBI and works when executed from shell. When its run from Apache I get gibberish error on connect. I have narrowed down that somehow my debian system had two installations of postgresql - one compiled and one via apt-get. The compiled psql in

help installing DBD::ODBC

2004-06-16 Thread PerlDiscuss - Perl Newsgroups and mailing lists
Platform: Windows XP Pro oDBC Driver Manager: included in windows backend database: MS Access 2000 Perl version: 5.8.3 Apache version: 2.0.48 DBI version: 1.42 DBD::oDBc version 1.09 MDAC version: 2.8 lil newbie here requiring help. im trying to upgrade from windows to open source and am

Multiple DBD on multiple Oracle version ???

2004-05-29 Thread PerlDiscuss - Perl Newsgroups and mailing lists
Hello dbi users, I'm using DBD Oracle with ORACLE 8.1.7 on HP-UX Cluster with 2 nodes on failover mode. There is 2 ou 3 databases running on same time (8.1.7) but the ORACLE_HOME used to compile DBD-Oracle may not be mounted. So, I make chatr +s on Oracle.sl library to enable use of SHLIB_PATH

multiple DBD for multiple oracle version

2004-05-29 Thread PerlDiscuss - Perl Newsgroups and mailing lists
Hello dbi users, I'm using DBD Oracle with ORACLE 8.1.7 on HP-UX Cluster with 2 nodes on failover mode. There is 2 ou 3 databases running on same time (8.1.7) but the ORACLE_HOME used to compile DBD-Oracle may not be mounted. So, I make chatr +s on Oracle.sl library to enable use of SHLIB_PATH

error installing Msql-modules-0.91 HELP!

2004-05-21 Thread PerlDiscuss - Perl Newsgroups and mailing lists
I sm trying to install Msql-modules-0.91 I need this module because i have many scripts that use use Msql; and don't want to install DBI::msql because I will have to rewrite code to 1000 scripts. I am on a suse 9.1 with perl 5.8.3 The error I get after unpacking and running make: cc -c

Re: proxying DBI connection

2004-05-21 Thread PerlDiscuss - Perl Newsgroups and mailing lists
I have a question along this line. I have: Windows NT which has MS Access with ODBC driver. Linux w/Apache2 and am trying to write Perl cgi. What I want to do is, User enter CustomerID at web page, then CGI will query customer info using ODBC and display the info to user. I found DBI::Proxy

Returning blob in sql

2004-05-18 Thread PerlDiscuss - Perl Newsgroups and mailing lists
Hi, Can you tell me why Insert into Foo values (?, EMPTY_BLOB()) returning data into ? causes a segmentation fault. Where Foo is create table Foo (id integer, data blob); The section of the code that runs this sql statement is $stmt = INSERT INTO Foo VALUES (?, EMPTY_BLOB()) returning the_file

incorrect perl-version guessed during DBI build

2004-02-24 Thread PerlDiscuss - Perl Newsgroups and mailing lists
I am not sure if it makes a lot of difference, but my perl version is: [opt]$ perl -v This is perl, v5.6.1 built for i386-linux But: DBI-1.41 Makefile uses $] to guess the perl version, and that gives a lower version: [opt]$ perl -e 'print $]\n' 5.006001 Will this have consequences for

Make test failure for Oracle DBD module

2004-02-13 Thread PerlDiscuss - Perl Newsgroups and mailing lists
When I run make test for my module, I get error code 29 - Command failed for target 'test_dynamic'. Here is the test output: # make test PERL_DL_NONLAZY=1 /usr/local/bin/perl -MExtUtils::Command::MM -e test_harness(0, 'blib/lib', 'blib/arch') t/*.t t/base... t/base...ok

ORACLE_HOME environment variable must be set

2003-08-29 Thread PerlDiscuss - Perl Newsgroups and mailing lists
I am getting this error: ORACLE_HOME environment variable must be set but when I type: echo $ORACLE_HOME I get: /opt/oracle/product/9.2.0 Seems the ORACLE_HOME is set. I have Oracle 9i R2 installed on Redhat9 Can anyone help with this error?