install_driver(Oracle) error when CGI pgm called by Webserver
Hi, I have a CGI program written to connect to Database and execute/fetch data for the SQL - Select tname from tab. It is a very simple program, which when executed from command line works fine, but when I give a input on the HTML Form and when the same cgi is being called by the WebServer I get the following error: --- install_driver(Oracle) failed: [Wed Jun 6 13:08:16 2001] order.cgi: [Wed Jun 6 13:08:16 2001] order.cgi: Can't load '/usr/local/lib/perl5/site_perl/i86pc-solaris/auto/DBD/Oracle/Oracle.so' for module DBD::Oracle: ld.so.1: /usr/local/bin/perl: fatal: libclntsh.so.1.0: open failed: No such file or directory at /usr/local/lib/perl5/i86pc-solaris/5.00404/DynaLoader.pm line 166. [Wed Jun 6 13:08:16 2001] order.cgi: [Wed Jun 6 13:08:16 2001] order.cgi: [Wed Jun 6 13:08:16 2001] order.cgi: [Wed Jun 6 13:08:16 2001] order.cgi: at (eval 2) line 2 Perhaps a required shared library or dll isn't installed where expected at /export/home/ajay/apache/cgi-bin/order.cgi line 17 --- Mind you, I have set the LD_LIBRARY_PATH environment variable to Oracle Home/Lib. The following is the code of my cgi: #!/usr/local/bin/perl ($field_name, $orderid) = split (/=/, $ENV {'QUERY_STRING'}); #$user_name =~ s/\+/ /eg; #$position=index($user_name,); #$user_name=substr($user_name, 0, $position); use DBI; use CGI::Carp qw(fatalsToBrowser); #use strict; $dbuser = $ENV{ORACLE_USERID} || 's1_gwy/s1_gwy01'; $dbh = DBI-connect('DBI:Oracle:', $dbuser, '') or die Couldnt connect to database: . DBI-errstr; $sth = $dbh-prepare('SELECT TNAME FROM TAB') or die Couldnt prepare statement: . $dbh-{RaiseError }; $sth-execute or die Couldnt execute statement: . $sth-errstr; my @data; while (@data = $sth-fetchrow_array()) { my $tname = $data[0]; print \t$tname \n; } if ($sth-rows == 0) { print No names matched .\n\n; } $sth-finish; $dbh-disconnect; print Content-type: text/html, \n\n; print Content-type: text/html\n\n; print HTML\nHEAD\nTITLERegistration Results/TITLE\n/HEAD\n; print BODY\n; print PFONT SIZE=5Hey, , $tname, , thanks for registering!/FONT /P; print /BODY\n/HTML; The Environment variables are set as below: PATH=/usr/bin:/usr/local/bin:/usr/ccs/bin:/export/home/app/oracle/product/8.0.5/bin LD_LIBRARY_PATH=/usr/local/lib:/export/home/app/oracle/product/8.0.5/lib TWO_TASK=sqadb_s1gwy ORACLE_HOME=/export/home/app/oracle/product/8.0.5 System Information DBI 1.18 - Upgraded from 1.15 and rebuilt DBD::Oracle DBD 1.06 Sun OS 5.6 Perl 5.004_04 Need your help in solving this error, Thanks in advance for the help, Ajay
RE: DBD-Oracle 1.0.7/AIX make problem
Make is broken on AIX. Download gnu-make from your nearest mirror. --Neil -Original Message- From: Tobias Hausmann [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 07, 2001 8:03 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: DBD-Oracle 1.0.7/AIX make problem Hi, I am working on the following environment: AIX 4.3.3, Oracle 8.1.6i, Perl 5.00503 , DBI 1.15, DBD-Oracle 1.0.7 I am trying to install want to install DBD-Oracle 1.0.7. After perl Makefile.PL, make gives me the following error message: make Makefile:2425: *** missing separator (did you mean TAB instead of 8 spaces?). Stop. I replaced the beginning spaces with a tab and became the following error message: make Makefile:2425: *** commands commence before first target. Stop. __ Makefile: # these two targets are the same as the ones above extproc_no_context and # extproc_with_context. They are preserved for backward compatibility. /bin/nm -B -h -g $$1 | grep -v ' U ' | awk '{print $$3}' | \ - error line egrep -v '^\.|^TOC' | sort | uniq ; \ }; \ generate_export_list $(OBJS) $(SHARED_LIBNAME).exp; \ $(LD) -bnoentry -bM:SRE -bE:$(SHARED_LIBNAME).exp -o $(SHARED_LIBNAME)\ $(OBJS) -L$(ORACLE_HOME)/lib -lc_r $(OCISHAREDLIBS) $(LIBEXTP) \ $(LIBSQL) $(TTLIBS) $(DEF_OPT) $(SSDBED) $(LIBAGENT) $(LIBEPCPT) __ Any help or advice will be most welcome. Tobias Hausmann __ Please Note : Only the intended recipient is authorised to access or use this e-mail. If you are not the intended recipient, please delete this e-mail and notify the sender immediately. The contents of this e-mail are the writer's opinion and are not necessarily endorsed by the Gunz Companies unless expressly stated. We use virus scanning software but exclude all liability for viruses or similar in any attachment.
SQL Red Flags [was: Newbie looking for some Win32::ODBC Help]
You realise you just posted to dbi-users when your not even using DBI! You should be though. Look for the DBI and DBD-ODBC packages. There is a slightly different syntax to use but get used to it. On the other hand, this is perfectly viable for discussion here. Your JOIN syntax is wrong and pretty illegal. What you want is: SELECT A1.DefaultIPGateway0, A1.IPAddress0, A1.IPSubnet0, A1.MACAddress0, A2.Name0, A2.UserName0, EID00, EID, FNAME, LNAME, ORG, ROOM FROM $Table A1 INNER JOIN $Table2 A2 ON (A1.MachineID = A2.MachineID) INNER JOIN $Table3 A3 ON (A2.MachineID = A3.MachineID) LEFT OUTER JOIN $Table4 A4 ON(A3.EID00 = A4.EID) This bit is also screwy: AND A1.IPAddress0 '' AND A1.IPAddress0 '0.0.0.0' AND A1.IPAddress0 '10.10.10.10' Try this: WHERE A1.IPAddress0 NOT IN ('','0.0.0.0','10.10.10.10') Pretty Clear? --Neil -Original Message- From: Patricio M. Rueda [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 07, 2001 5:33 AM To: [EMAIL PROTECTED] Subject: Newbie looking for some Win32::ODBC Help Could some one help me here and tell me what's wrong with the following code: #= $DSN= IPMac; $Table=dbo_Network_DATA; $Table2=dbo_Computer_System_data; $Table3= dbo_User_data; $Table4=cids; use Win32::ODBC; if (!($db = new Win32::ODBC($DSN))){ print MACHINES Failure no good . Win32::ODBC::Error(). \n\n; }else{ print MACHINES Success (connection #, $db-Connection(), )\n\n; $ip=; if (! $db-Sql(SELECT A1.DefaultIPGateway0, A1.IPAddress0, A1.IPSubnet0, A1.MACAddress0, A2.Name0, A2.UserName0, EID00, EID, FNAME, LNAME, ORG, ROOM FROM $Table A1, $Table2 A2, $Table3 A3 LEFT OUTER JOIN $Table4 A4 ON(A3.EID00 = A4.EID) WHERE ((A1.MachineID = A2.MachineID) AND (A1.MachineID = A3.MachineID)) AND A1.IPAddress0 '' AND A1.IPAddress0 '0.0.0.0' AND A1.IPAddress0 '10.10.10.10' )){ } #= === I am trying to use (4) MSAccess Tabels, two of which need to be join. I am getting the following error: -3530[Microsoft][ODBC Microsoft Access Driver] Join expression not supported.10 __ Please Note : Only the intended recipient is authorised to access or use this e-mail. If you are not the intended recipient, please delete this e-mail and notify the sender immediately. The contents of this e-mail are the writer's opinion and are not necessarily endorsed by the Gunz Companies unless expressly stated. We use virus scanning software but exclude all liability for viruses or similar in any attachment.
DBD::Oracle: two-task internal error
Hallo Tim, i have some DBD::Oracle errormessage, i cant' figure out what it could mean: DBD::Oracle::st execute failed: ORA-03124: two-task internal error (DBD ERROR: OCIStmtExecute) at export_from_mysql.pl line 188. ORA-03124: two-task internal error (DBD ERROR: OCIStmtExecute) at export_from_mysql.pl line 188. i'm doing some $sth = $dbh-prepare (insert into table(a,b,c) values (?,?,?)); $sth-execute (1,2,3); unfortunately the table has 63 columns and the prepare and execute statements don't look nice. i'm importing the data for the inserts from an other database (mysql) and for the most values the insert works. so i don't know where to start searching for invalid input. do you have any idea? thanks in advance. -- ++ | Alexander Knack Entropie erfordert keine Wartung .| | dasburo.de ..| | Schlesische Str. 27 10997 Berlin Tel/Fax: +49 30 611 281 33/38| ++
(Fwd) DBD::Oracle: two-task internal error
- Forwarded message from Alexander Knack [EMAIL PROTECTED] - Date: Wed, 6 Jun 2001 19:19:50 +0200 From: Alexander Knack [EMAIL PROTECTED] To: Tim Bunce [EMAIL PROTECTED] Subject: DBD::Oracle: two-task internal error User-Agent: Mutt/1.2.2i In-Reply-To: [EMAIL PROTECTED]; from [EMAIL PROTECTED] on Fri, Mar 30, 2001 at 04:43:22PM +0100 Hallo Tim, i have some DBD::Oracle errormessage, i cant' figure out what it could mean: DBD::Oracle::st execute failed: ORA-03124: two-task internal error (DBD ERROR: OCIStmtExecute) at export_from_mysql.pl line 188. ORA-03124: two-task internal error (DBD ERROR: OCIStmtExecute) at export_from_mysql.pl line 188. i'm doing some $sth = $dbh-prepare (insert into table(a,b,c) values (?,?,?)); $sth-execute (1,2,3); unfortunately the table has 63 columns and the prepare and execute statements don't look nice. i'm importing the data for the inserts from an other database (mysql) and for the most values the insert works. so i don't know where to start searching for invalid input. do you have any idea? thanks in advance. -- ++ | Alexander Knack Entropie erfordert keine Wartung .| | dasburo.de ..| | Schlesische Str. 27 10997 Berlin Tel/Fax: +49 30 611 281 33/38| ++ - End forwarded message -
Re: DBD::Oracle: two-task internal error
Please direct questions like this to the DBI mail list. If the statement works for most, but not all, data lines, try to discover which data triggers the problem. You should be able to write the data to a debug file while troubleshooting. If you write both the error messages and the data to the file, you should be able to see which data line has the problem. Without seeing an actual example that causes the problem, it would be difficult to say more. -- Mac :}) ** I normally forward private database questions to the DBI mail lists. ** Give a hobbit a fish and he'll eat fish for a day. Give a hobbit a ring and he'll eat fish for an age. - Original Message - From: Alexander Knack [EMAIL PROTECTED] To: Tim Bunce [EMAIL PROTECTED] Sent: Wednesday, June 06, 2001 10:19 Subject: DBD::Oracle: two-task internal error i have some DBD::Oracle errormessage, i cant' figure out what it could mean: DBD::Oracle::st execute failed: ORA-03124: two-task internal error (DBD ERROR: OCIStmtExecute) at export_from_mysql.pl line 188. ORA-03124: two-task internal error (DBD ERROR: OCIStmtExecute) at export_from_mysql.pl line 188. i'm doing some $sth = $dbh-prepare (insert into table(a,b,c) values (?,?,?)); $sth-execute (1,2,3); unfortunately the table has 63 columns and the prepare and execute statements don't look nice. i'm importing the data for the inserts from an other database (mysql) and for the most values the insert works. so i don't know where to start searching for invalid input.
Re: DBD-Oracle-1.07
On Wed, Jun 06, 2001 at 02:18:59PM -0300, Katja Sattler (EDS) wrote: There is a lost fi at line 2670 in the Makefile (DB-Oracle-1.07). I have noticed the same at the previous DBD-Oracle version (DB-Oracle-1.06) Because DBD::Oracle is simply copying chunks of your Oracle makefiles. What shall I do ? Can I just take it off ? Probably. And complain to Oracle. Tim. Thanks, Katja See part of the code below : IBSKGXPD_STATIC=$(RDBMSLIB)$(LIB_PREFIX)$(SKGXPD_NAME).$(LIB_EXT) LIBSKGXPU_STATIC=$(RDBMSLIB)$(LIB_PREFIX)$(SKGXPU_NAME).$(LIB_EXT) LIBSKGXPT_STATIC=$(RDBMSLIB)$(LIB_PREFIX)$(SKGXPT_NAME).$(LIB_EXT) SKGXP_EXT=$(LIB_EXT) LIBSKGXPD=$(LIBSKGXPD_STATIC) LIBSKGXPU=$(LIBSKGXPU_STATIC) LIBSKGXPT=$(LIBSKGXPT_STATIC) POST_SKGXP_UPDATE= SKGXP_DEFAULT=ipc_none SKGXP_OPS_ON=ipc_udp # Exiting /project/815/src/rdbms/s_rdbms.mk # Exiting rdbms.mk # Entering /project/815/src/buildtools/mkfile/libclntsh.mk fi # Exiting /project/815/src/buildtools/mkfile/libclntsh.mk RDBMSLIB64=$(ORACLE_HOME)/rdbms/lib64/ LIBHOME64=$(ORACLE_HOME)/lib64/ LDFLAGS64=+DA2.0W +DS2.0 -L$(LIBHOME64) -L$(ORACLE_HOME)/rdbms/lib64 LIBCLNTSH64=$(ORACLE_HOME)/lib64/libclntsh.$(SO_EXT) OCISTATICLIBS64=$(STATICTTLIBS64) $(LLIBTHREAD) SSDBED64=$(RDBMSLIB64)ssdbaed.$(OBJ_EXT) HPARCHFLAGS=$(COMPFLAGS) +DS2.0 ...
RE: Question regarding dbi:ADO isolation level,Connection and command properties , and streams
Thanks for the quick reply, I will probably not have the time to make the changes in the next couple of weeks. But as I am in the position of wanting Perl on NT to talk to multiple data sources and would prefer to use ADO, I will try and make the changes to ado.pm and send it to you. When I can. Not sure about your answer to 1. If I pass thru a connect string with ;IsolationLevel=adXactBrowse; Then in the STORE function you could access check $value to see if existed in $ado_consts. Or I think that I am actually exposing my lack of understanding about what $this-STORE is actually doing. Tim -Original Message- From: Thomas A. Lowery [mailto:[EMAIL PROTECTED]] Sent: 06 June 2001 19:22 To: [EMAIL PROTECTED] Subject: Re: Question regarding dbi:ADO isolation level,Connection and command properties , and streams Importance: Low On Wed, Jun 06, 2001 at 11:17:25AM +0100, [EMAIL PROTECTED] wrote: Hi all I have a few questions that I have not seen anything in the archives for. I have ADO2.1 installed on DBI 1.16 1. dbi:ADO supports setting Isolation Level but only as a number. Is there a reason that it does not seem to use the ado_const's, eg adXactBrowse I haven't exported these constants from the module for the calling application. I'll add it to the To-Do list. 2.dbi:ADO supports setting Connectiontimeout and CommandTimeout in the connection string but I have discovered that ADO does not let a command inherit its connections Command and Connection timeout values see the following (also quoted below) http://msdn.microsoft.com/library/psdk/dasdk/mdap4wc4.htm The CommandTimeout setting on a Connection object has no effect on the CommandTimeout setting on a Command object on the same Connection; that is, the Command object's CommandTimeout property does not inherit the value of the Connection object's CommandTimeout value. /quote the upshot of which was a long query (over 9 minutes) was failing with a timeout. I thought I had support for inheriting the CommandTimeout from the Connection object, but reviewing the code, it doesn't. I have made a addition to my copy of ado.pm to add this to the %attr that you can pass through on a prepare, and it seems to work. Great! Send me a patch (prefer diff -c) and if possible, a test(s) for the change. 3. Is there a reason that Stream support should not be added to ADO.pm. Has anyone experimented with this The short answer: No. Not I. Please feel free and encouraged to do so. The long answer: When I did most of my development on DBD::ADO, I worked in an Windows NT environment with HP large database servers. All the desktops, web servers, and some database servers where Windows based. ADO was prefect for integrating the numerous data sources. Since August 2000, I changed positions to a Linux and Sun based environment with very little interaction with Windows. Occasionally I still need a Windows data source, but not day to day. Additionally, I've an older version of VC++ (5.0 sp3), which I finding doesn't work with the newer version of Activestate Perl (for building modules either not supplied by PPM or installing more current versions). I haven't shelled out the money for a newer compiler, yet. What this means is development time (for me) on DBD::ADO is very limited now. If you've features or changes, please send me patches, documents, and/or tests. Thomas -- Thomas A. Lowery See DBI/FAQ http://tlowery.hypermart.net _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com For more information about Barclays Capital, please visit our web site at http://www.barcap.com. Internet communications are not secure and therefore the Barclays Group does not accept legal responsibility for the contents of this message. Although the Barclays Group operates anti-virus programmes, it does not accept responsibility for any damage whatsoever that is caused by viruses being passed. Any views or opinions presented are solely those of the author and do not necessarily represent those of the Barclays Group. Replies to this email may be monitored by the Barclays Group for operational or business reasons.
Problems makeing DBD-1.07 on Dec Alpha
I am trying to compile DBD-1.07 with perl 5.61 on DEC Alpha with Oracle 7.34. I had the same problems listed below whether I was the root user or the oracle user.I tried the perl Makefile.PL -b, -c, -l, and -n LIBCLNTSH same error. I did not try rebuilding perl using Configure -Uusemymalloc. Please help Thanks! Tom Dempster 703 396-1426. Script started on Thu Jun 7 09:35:48 2001 husky1perl Makefile.PL -v Using DBI 1.14 installed in /usr/local/lib/perl5/site_perl/5.6.1/alpha-dec_osf/auto/DBI Configuring DBD::Oracle ... Remember to actually *READ* the README file! ( I DID READ THIS) Especially if you have any problems. Using Oracle in /oracle/app/oracle/product/7.3.4 1.0.1.0.0Oracle On-Line Text Viewer 7.3.4.0.0ORACLE NLS Libraries and Utilities 7.3.4.0.0ORACLE Core Libraries 7.3.4.0.0Oracle Common RDBMS Libraries and Utilities 7.3.4.0.0ORACLE PL/SQL Libraries 7.3.4.0.0ORACLE Common Libraries 7.3.4.0.0ORACLE Common Precomp Libraries 7.3.4.0.0ORACLE Common Network Libraries and Utilities 7.3.4.0.0ORACLE Common Trace Libraries 7.3.4.0.0ORACLE Common Utilities 7.3.4.0.0ORACLE Common Libraries and Utilities 7.3.4.0.0Platform specific Libraries and Utilities 2.3.4.0.0SQL*Net (V2) 2.3.4.0.0TCP/IP Protocol Adapter (V2) 1.3.2.0.0Remote Operations 2.1.4.14.1 ToolKit 2.1 Base 7.3.4.0.0SLAX: parser 2.3.4.4.0PL/SQL V2 7.3.4.0.0Oracle7 Distributed Database option 7.3.4.0.0Oracle7 Parallel Server Option 7.3.4.0.0Oracle7 Parallel Query option 2.3.4.0.0Oracle Server Manager 7.3.4.4.0Oracle7 Server (RDBMS) 1.0.0.0.1Database Startup Load Files 7.3.4.0.0Oracle7 XA Library 7.3.4Oracle Trace 7.3.4.0.0Precomp 2.2.4.0.0Pro*C 1.1.5.0.0SQL*Module 1.1.5.0.0SQL*Module for C 3.3.4.0.0SQL*Plus 2.1.4.14.1 ToolKit 2.1 Extension 2.0.5.4.0Multimedia APIs 2.1.1.0.0Oracle Help 2.1.3.0.0Oracle Office Automation Core 2.3.4.0.0Oracle Server Manager (Motif) Found rdbms/demo/ocidfn.h Found rdbms/demo/ocidem.h Found rdbms/demo/ociapr.h Found rdbms/demo/ocikpr.h Found rdbms/demo/oratypes.h Found header files in rdbms/demo. Found /oracle/app/oracle/product/7.3.4/rdbms/demo/oracle.mk Found /oracle/app/oracle/product/7.3.4/otrace/demo/atmoci.mk Found /oracle/app/oracle/product/7.3.4/precomp/demo/proc/proc.mk Using /oracle/app/oracle/product/7.3.4/rdbms/demo/oracle.mk Reading /oracle/app/oracle/product/7.3.4/rdbms/demo/oracle.mk. Reading /oracle/app/oracle/product/7.3.4/rdbms/lib/env_rdbms.mk. Read a total of 555 lines from /oracle/app/oracle/product/7.3.4/rdbms/lib/env_rdbms.mk (including inclusions) Read a total of 708 lines from /oracle/app/oracle/product/7.3.4/rdbms/demo/oracle.mk (including inclusions) Deleted AR definition: AR=ar Deleted LDFLAGS definition: LDFLAGS =-o $@ $(PRODUCT_LIBHOME) -L$(LIBHOME) Deleted SHELL definition: SHELL=/bin/sh Deleted ECHO definition: ECHO = echo Deleted CHMOD definition: CHMOD = chmod Deleted CFLAGS definition: CFLAGS= $(GFLAG) $(OPTIMIZE) $(CDEBUG) $(CCFLAGS) $(QACCFLAGS) $(PFLAGS) $(SHARED_CFLAG) $(ENV_FLAGS) Deleted CCFLAGS definition: CCFLAGS=$(GEMC_FLAGS) $(CC_COMPRESS) $(ANSI_C) -DOSF1 -DA_OSF -Wf,-readonly_strings -D_INTRINSICS $(OM_FLAGS) Deleted CPP definition: CPP=/usr/bin/cpp Deleted OPTIMIZE definition: OPTIMIZE=$(CDEBUG?:-O2) Deleted PERL definition: PERL = perl Deleted ASFLAGS definition: ASFLAGS=$(OPTIMIZE) $(CDEBUG) Deleted AS definition: AS=as ASFLAGS macro redefined by Oracle from $(OPTIMIZE) $(CDEBUG) to Deleted ASFLAGS definition: ASFLAGS = Deleted CC definition: CC=cc Deleted LD definition: LD=ld LDFLAGS macro redefined by Oracle from -o $@ $(PRODUCT_LIBHOME) -L$(LIBHOME) to $(LDOPTIMIZE) $(SHARED_FLAG) -o $@ $(PRODUCT_LIBHOME) -L$(LIBHOME) -L$(ORACLE_HOME)/rdbms/lib $(NO_STRIP_EXE?:-s) Deleted LDFLAGS definition: LDFLAGS = $(LDOPTIMIZE) $(SHARED_FLAG) -o $@ $(PRODUCT_LIBHOME) -L$(LIBHOME) -L$(ORACLE_HOME)/rdbms/lib $(NO_STRIP_EXE?:-s) LDCCOM macro redefined by Oracle from $(LDOPTIONS) $(CC) $(GFLAG) $(CCFLAGS) $(LDFLAGS) to $(CC) $(GFLAG) $(CDEBUG) $(CCFLAGS) $(LDFLAGS) Deleting ORA_NLS = $(ORACLE_HOME)/ocommon/nls/admin/data because it is not already set in the environment and it can cause ORA-01019 errors. Deleted ORA_NLS definition: ORA_NLS = $(ORACLE_HOME)/ocommon/nls/admin/data NTCONTAB macro redefined by Oracle from ntcontab.c to $(LIBHOME)/ntcontab.o LDFLAGS macro redefined by Oracle from $(LDOPTIMIZE) $(SHARED_FLAG) -o $@ $(PRODUCT_LIBHOME) -L$(LIBHOME) -L$(ORACLE_HOME)/rdbms/lib $(NO_STRIP_EXE?:-s) to -L$(LIBHOME) -L$(ORACLE_HOME)/rdbms/lib Deleted LDFLAGS definition: LDFLAGS=-L$(LIBHOME)
Re: I want to unsuscribe
On Wed, 6 Jun 2001 14:57:05 -0600 , Sterin, Ilya wrote: Well depends. Sometimes you don't want them trimmed, so if someone comes in in the middle of the thread, they don't have to read each and every message, but rather the last one. What, you mean, like, upside down? -- Bart.
Please unsuscribe
Please unsuscribe
RE: Newbie looking for some Win32::ODBC Help
The problem is the join syntax. Access has limited choice on joins. If you use the Query GUI from Access, go to View, SQL view. You will see the SQL generated for the join. From the three choices you are given in the GUI, it supports JOIN, Left Join and Right Join. The DBI passes the statements to the DB, which uses it's SQL commands. You can test your perl SQL by using the SQL view in Access. You should get the results expected by removing OUTER. -Original Message- From: Patricio M. Rueda [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 06, 2001 3:33 PM To: [EMAIL PROTECTED] Subject: Newbie looking for some Win32::ODBC Help Could some one help me here and tell me what's wrong with the following code: #= $DSN= IPMac; $Table=dbo_Network_DATA; $Table2=dbo_Computer_System_data; $Table3= dbo_User_data; $Table4=cids; use Win32::ODBC; if (!($db = new Win32::ODBC($DSN))){ print MACHINES Failure no good . Win32::ODBC::Error(). \n\n; }else{ print MACHINES Success (connection #, $db-Connection(), )\n\n; $ip=; if (! $db-Sql(SELECT A1.DefaultIPGateway0, A1.IPAddress0, A1.IPSubnet0, A1.MACAddress0, A2.Name0, A2.UserName0, EID00, EID, FNAME, LNAME, ORG, ROOM FROM $Table A1, $Table2 A2, $Table3 A3 LEFT OUTER JOIN $Table4 A4 ON(A3.EID00 = A4.EID) WHERE ((A1.MachineID = A2.MachineID) AND (A1.MachineID = A3.MachineID)) AND A1.IPAddress0 '' AND A1.IPAddress0 '0.0.0.0' AND A1.IPAddress0 '10.10.10.10' )){ } # I am trying to use (4) MSAccess Tabels, two of which need to be join. I am getting the following error: -3530[Microsoft][ODBC Microsoft Access Driver] Join expression not supported.10
Re: DBD-Oracle 1.0.7/AIX make problem
I replaced the AIX make with a GNU make and deleted the following lines from the make file # these two targets are the same as the ones above extproc_no_context and # extproc_with_context. They are preserved for backward compatibility. /bin/nm -B -h -g $$1 | grep -v ' U ' | awk '{print $$3}' | \ egrep -v '^\.|^TOC' | sort | uniq ; \ }; \ generate_export_list $(OBJS) $(SHARED_LIBNAME).exp; \ $(LD) -bnoentry -bM:SRE -bE:$(SHARED_LIBNAME).exp -o $(SHARED_LIBNAME)\ $(OBJS) -L$(ORACLE_HOME)/lib -lc_r $(OCISHAREDLIBS) $(LIBEXTP) \ $(LIBSQL) $(TTLIBS) $(DEF_OPT) $(SSDBED) $(LIBAGENT) $(LIBEPCPT) Both actions fixed the problem. Thanks you, Tobias Gilmour Sean-WSG014 wrote: The make that ships with 4.3.3 is not that great, you can either get the gnu-make or download a newer c compiler from IBM, I downloaded the latest visual age c++ and it works great. -Original Message- From: Tobias Hausmann [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 06, 2001 5:03 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: DBD-Oracle 1.0.7/AIX make problem Hi, I am working on the following environment: AIX 4.3.3, Oracle 8.1.6i, Perl 5.00503 , DBI 1.15, DBD-Oracle 1.0.7 I am trying to install want to install DBD-Oracle 1.0.7. After perl Makefile.PL, make gives me the following error message: make Makefile:2425: *** missing separator (did you mean TAB instead of 8 spaces?). Stop. I replaced the beginning spaces with a tab and became the following error message: make Makefile:2425: *** commands commence before first target. Stop. __ Makefile: # these two targets are the same as the ones above extproc_no_context and # extproc_with_context. They are preserved for backward compatibility. /bin/nm -B -h -g $$1 | grep -v ' U ' | awk '{print $$3}' | \ - error line egrep -v '^\.|^TOC' | sort | uniq ; \ }; \ generate_export_list $(OBJS) $(SHARED_LIBNAME).exp; \ $(LD) -bnoentry -bM:SRE -bE:$(SHARED_LIBNAME).exp -o $(SHARED_LIBNAME)\ $(OBJS) -L$(ORACLE_HOME)/lib -lc_r $(OCISHAREDLIBS) $(LIBEXTP) \ $(LIBSQL) $(TTLIBS) $(DEF_OPT) $(SSDBED) $(LIBAGENT) $(LIBEPCPT) __ Any help or advice will be most welcome. Tobias Hausmann -- ** * Tobias Hausmann* * System Administrator * * BOSTON MEDICAL CENTER * * Vose Hall * * 88 East Newton Street * * Boston, MA 02118-2393 * * Work : (617) 414 - 1856* * Fax : (617) 638 - 8201* * Pager: (617) 638 - 5795 PIN#: 1936 * **
Re: Please unsuscribe
I might unsuscribe if I knew what it was. If _you_ want to unsu_b_scribe, send an email to [EMAIL PROTECTED] for instructions. -- Mac :}) ** I normally forward private database questions to the DBI mail lists. ** Give a hobbit a fish and he'll eat fish for a day. Give a hobbit a ring and he'll eat fish for an age. - Original Message - From: Mamadou Lamine Diatta [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, June 07, 2001 09:49 Subject: Please unsuscribe Please unsuscribe
Re: Anyone else experiencing problems with the dbi-* mailing lists?
Hi Ed,You're right compared to a a couple weeks ago . I got a ton of emails and its substantially fallen off. I see a good number unsubscribing. Dexter - Original Message - From: Edward J. Sabol [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, June 07, 2001 1:18 PM Subject: Anyone else experiencing problems with the dbi-* mailing lists? Is there a problem with the [EMAIL PROTECTED], [EMAIL PROTECTED], and [EMAIL PROTECTED] mailing lists? I seem to be experiencing sporadic delivery problems. Recently, I noticed that I haven't received a single e-mail from [EMAIL PROTECTED] since May 11th or [EMAIL PROTECTED] since May 4th. Both of those are low-volume mailing lists, so that's somewhat plausible. However, although I have received e-mail from [EMAIL PROTECTED], I noticed that the volume of posts that I have received has dropped drastically. For example, between May 22nd and June 1st, I received *one* e-mail from [EMAIL PROTECTED] Since then, there has been some improvement, but it's still a trickle compared to what the volume was just a couple months ago. And the e-mails I do receive from [EMAIL PROTECTED] often refer to e-mails that I haven't received. At first, I thought maybe I had been unsubscribed from dbi-announce and/or dbi-dev, so I sent e-mail to [EMAIL PROTECTED], but I received no response from the list server. I also tried to send e-mail to [EMAIL PROTECTED] and didn't get any response there either. Next I tried [EMAIL PROTECTED] Again no response. The e-mail I sent to [EMAIL PROTECTED] has gone unanswered for two days as well. So I decided to check the mailing list archives to see what's going on. http://lists.perl.org/ referred me to the mailing list archives at http://archive.develooper.com/, but I couldn't access that web site at all. No response at all to my HTTP connections. Next, I checked the DBI home page at http://dbi.symbolstone.org/. It has links to two other mailing list archives: One at http://outside.organic.com/mail-archives/dbi-users/ and another one at http://www.rosat.mpe-garching.mpg.de/mailing-lists/PerlDB-Interest. But I couldn't get a response from outside.organic.com either! Fortunately, the fine folks at MPE have figured out how to correctly administer a web site. I also checked my old dbi-* e-mails and found a link to a mailing list archive at http://marc.theaimsgroup.com/?l=perl-dbi. I was able to access that site as well. Comparing the mailing list archive at theaimsgroup.com with the mailing list at MPE, the MPE archive seems to be complete, but theaimsgroup.com archive is missing e-mails that the MPE archive has received. It's also missing e-mails that I've received. Both the MPE archive and theaimsgroup.com archive contain lots of e-mails that I haven't received. MPE has archived 242 dbi-users e-mails in the month of June, theaimsgroup.com has archived 22, and I've received even less than that. I'm subscribed to a dozen mailing lists from places other than perl.org and I'm receiving e-mail from all of these other lists just fine, so I don't think it's a problem with my machine. My workstation has been turned on and connected to the Internet 24/7 for years now, and I've been subscribed to the dbi-* mailing lists since April 1997. Looking at the dbi-users archive at http://marc.theaimsgroup.com/?l=perl-dbi, I'm more convinced of that than ever, since they seem to be experiencing the same problem as me. Anyone have clue what's going on? Anyone else experiencing this? I've checked my mail logs and the e-mails just aren't getting here. I wonder if maybe lists.perl.org has bitten off more than it can chew. Perhaps at various times their load becomes so high that sendmail processes are being terminated before they finish propagating an e-mail to all the members of the mailing list? Needless to say, please CC: me on all responses and/or follow-ups. I've set the Reply-To: header on this e-mail accordingly. But I don't trust that the mailing list server will send any e-mails to me. (I estimate that I have a 1 in 5 chance of receiving a particular dbi-users e-mail from the mailing list server.) Thanks, Ed
RE: Anyone else experiencing problems with the dbi-* mailing lists?
Haven't had a problem, get many email a day from dbi-users, might want to check you mail server, since I had a mail account before where the server would for some reason or another loose messages. Ilya Sterin -Original Message- From: Edward J. Sabol To: [EMAIL PROTECTED] Sent: 6/7/01 2:18 PM Subject: Anyone else experiencing problems with the dbi-* mailing lists? Is there a problem with the [EMAIL PROTECTED], [EMAIL PROTECTED], and [EMAIL PROTECTED] mailing lists? I seem to be experiencing sporadic delivery problems. Recently, I noticed that I haven't received a single e-mail from [EMAIL PROTECTED] since May 11th or [EMAIL PROTECTED] since May 4th. Both of those are low-volume mailing lists, so that's somewhat plausible. However, although I have received e-mail from [EMAIL PROTECTED], I noticed that the volume of posts that I have received has dropped drastically. For example, between May 22nd and June 1st, I received *one* e-mail from [EMAIL PROTECTED] Since then, there has been some improvement, but it's still a trickle compared to what the volume was just a couple months ago. And the e-mails I do receive from [EMAIL PROTECTED] often refer to e-mails that I haven't received. At first, I thought maybe I had been unsubscribed from dbi-announce and/or dbi-dev, so I sent e-mail to [EMAIL PROTECTED], but I received no response from the list server. I also tried to send e-mail to [EMAIL PROTECTED] and didn't get any response there either. Next I tried [EMAIL PROTECTED] Again no response. The e-mail I sent to [EMAIL PROTECTED] has gone unanswered for two days as well. So I decided to check the mailing list archives to see what's going on. http://lists.perl.org/ referred me to the mailing list archives at http://archive.develooper.com/, but I couldn't access that web site at all. No response at all to my HTTP connections. Next, I checked the DBI home page at http://dbi.symbolstone.org/. It has links to two other mailing list archives: One at http://outside.organic.com/mail-archives/dbi-users/ and another one at http://www.rosat.mpe-garching.mpg.de/mailing-lists/PerlDB-Interest. But I couldn't get a response from outside.organic.com either! Fortunately, the fine folks at MPE have figured out how to correctly administer a web site. I also checked my old dbi-* e-mails and found a link to a mailing list archive at http://marc.theaimsgroup.com/?l=perl-dbi. I was able to access that site as well. Comparing the mailing list archive at theaimsgroup.com with the mailing list at MPE, the MPE archive seems to be complete, but theaimsgroup.com archive is missing e-mails that the MPE archive has received. It's also missing e-mails that I've received. Both the MPE archive and theaimsgroup.com archive contain lots of e-mails that I haven't received. MPE has archived 242 dbi-users e-mails in the month of June, theaimsgroup.com has archived 22, and I've received even less than that. I'm subscribed to a dozen mailing lists from places other than perl.org and I'm receiving e-mail from all of these other lists just fine, so I don't think it's a problem with my machine. My workstation has been turned on and connected to the Internet 24/7 for years now, and I've been subscribed to the dbi-* mailing lists since April 1997. Looking at the dbi-users archive at http://marc.theaimsgroup.com/?l=perl-dbi, I'm more convinced of that than ever, since they seem to be experiencing the same problem as me. Anyone have clue what's going on? Anyone else experiencing this? I've checked my mail logs and the e-mails just aren't getting here. I wonder if maybe lists.perl.org has bitten off more than it can chew. Perhaps at various times their load becomes so high that sendmail processes are being terminated before they finish propagating an e-mail to all the members of the mailing list? Needless to say, please CC: me on all responses and/or follow-ups. I've set the Reply-To: header on this e-mail accordingly. But I don't trust that the mailing list server will send any e-mails to me. (I estimate that I have a 1 in 5 chance of receiving a particular dbi-users e-mail from the mailing list server.) Thanks, Ed
RE: Anyone else experiencing problems with the dbi-* mailing list s?
I am with Ilya. I am not facing any problems from last one month. :-) Prem -Original Message- From: Sterin, Ilya [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 07, 2001 4:36 PM To: 'Edward J. Sabol '; '[EMAIL PROTECTED] ' Subject: RE: Anyone else experiencing problems with the dbi-* mailing list s? Haven't had a problem, get many email a day from dbi-users, might want to check you mail server, since I had a mail account before where the server would for some reason or another loose messages. Ilya Sterin -Original Message- From: Edward J. Sabol To: [EMAIL PROTECTED] Sent: 6/7/01 2:18 PM Subject: Anyone else experiencing problems with the dbi-* mailing lists? Is there a problem with the [EMAIL PROTECTED], [EMAIL PROTECTED], and [EMAIL PROTECTED] mailing lists? I seem to be experiencing sporadic delivery problems. Recently, I noticed that I haven't received a single e-mail from [EMAIL PROTECTED] since May 11th or [EMAIL PROTECTED] since May 4th. Both of those are low-volume mailing lists, so that's somewhat plausible. However, although I have received e-mail from [EMAIL PROTECTED], I noticed that the volume of posts that I have received has dropped drastically. For example, between May 22nd and June 1st, I received *one* e-mail from [EMAIL PROTECTED] Since then, there has been some improvement, but it's still a trickle compared to what the volume was just a couple months ago. And the e-mails I do receive from [EMAIL PROTECTED] often refer to e-mails that I haven't received. At first, I thought maybe I had been unsubscribed from dbi-announce and/or dbi-dev, so I sent e-mail to [EMAIL PROTECTED], but I received no response from the list server. I also tried to send e-mail to [EMAIL PROTECTED] and didn't get any response there either. Next I tried [EMAIL PROTECTED] Again no response. The e-mail I sent to [EMAIL PROTECTED] has gone unanswered for two days as well. So I decided to check the mailing list archives to see what's going on. http://lists.perl.org/ referred me to the mailing list archives at http://archive.develooper.com/, but I couldn't access that web site at all. No response at all to my HTTP connections. Next, I checked the DBI home page at http://dbi.symbolstone.org/. It has links to two other mailing list archives: One at http://outside.organic.com/mail-archives/dbi-users/ and another one at http://www.rosat.mpe-garching.mpg.de/mailing-lists/PerlDB-Interest. But I couldn't get a response from outside.organic.com either! Fortunately, the fine folks at MPE have figured out how to correctly administer a web site. I also checked my old dbi-* e-mails and found a link to a mailing list archive at http://marc.theaimsgroup.com/?l=perl-dbi. I was able to access that site as well. Comparing the mailing list archive at theaimsgroup.com with the mailing list at MPE, the MPE archive seems to be complete, but theaimsgroup.com archive is missing e-mails that the MPE archive has received. It's also missing e-mails that I've received. Both the MPE archive and theaimsgroup.com archive contain lots of e-mails that I haven't received. MPE has archived 242 dbi-users e-mails in the month of June, theaimsgroup.com has archived 22, and I've received even less than that. I'm subscribed to a dozen mailing lists from places other than perl.org and I'm receiving e-mail from all of these other lists just fine, so I don't think it's a problem with my machine. My workstation has been turned on and connected to the Internet 24/7 for years now, and I've been subscribed to the dbi-* mailing lists since April 1997. Looking at the dbi-users archive at http://marc.theaimsgroup.com/?l=perl-dbi, I'm more convinced of that than ever, since they seem to be experiencing the same problem as me. Anyone have clue what's going on? Anyone else experiencing this? I've checked my mail logs and the e-mails just aren't getting here. I wonder if maybe lists.perl.org has bitten off more than it can chew. Perhaps at various times their load becomes so high that sendmail processes are being terminated before they finish propagating an e-mail to all the members of the mailing list? Needless to say, please CC: me on all responses and/or follow-ups. I've set the Reply-To: header on this e-mail accordingly. But I don't trust that the mailing list server will send any e-mails to me. (I estimate that I have a 1 in 5 chance of receiving a particular dbi-users e-mail from the mailing list server.) Thanks, Ed
RE: How to get last insert id using DBI
Depends on the database. Check 'perldoc DBD::your_dbd_name_here' -Original Message- From: Dexter [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 07, 2001 5:03 PM To: [EMAIL PROTECTED] Subject: How to get last insert id using DBI How do I get the last insert using DBi. I tried the $-{insertid} but that doesnt work. Thanks Dexter
Installing Perl DBI 1.14/DBD 1.06on HP-UX 11.00/Oracle 8.1.7
I am trying to install Perl DBI 1.14 /DBD 1.06 on HP-UX 11.00/Oracle 8.1.7 The installation of Perl DBI dynamic linking works OK (static linking does not work ) The installation of DBD does not work for either dynamic or static linking. Please can someone advise me what I need to do. I have attached a perl_log file which details what I have done so far Also I am trying to use DBD with DBI installed in the /home/oracle/DBI directory not the DBIgiven in my perl_log file Austen -- Austen Birchall [EMAIL PROTECTED] perl Makefile.PL -v perl_log Using DBI 1.14 installed in /opt/perl5/lib/site_perl/5.6.0/PA-RISC1.1/auto/DBI Configuring DBD::Oracle ... Remember to actually *READ* the README file! Especially if you have any problems. Using Oracle in /opt/u01/product/8.1.7 Found /opt/u01/product/8.1.7/rdbms/demo/demo_rdbms.mk Found /opt/u01/product/8.1.7/otrace/demo/atmoci.mk Using /opt/u01/product/8.1.7/rdbms/demo/demo_rdbms.mk Reading /opt/u01/product/8.1.7/rdbms/demo/demo_rdbms.mk. Reading /opt/u01/product/8.1.7/rdbms/lib/env_rdbms.mk. Read a total of 1954 lines from /opt/u01/product/8.1.7/rdbms/lib/env_rdbms.mk (including inclusions) Read a total of 2243 lines from /opt/u01/product/8.1.7/rdbms/demo/demo_rdbms.mk (including inclusions) Deleted SHELL definition: SHELL=/bin/sh Deleted LIB_EXT definition: LIB_EXT=a Deleted OBJ_EXT definition: OBJ_EXT=o Deleted AR definition: AR=ar Deleted AS definition: AS=as Deleted CC definition: CC=cc Deleted CHMOD definition: CHMOD=chmod Deleted CPP definition: CPP=cpp Deleted ECHO definition: ECHO=echo Deleted LD definition: LD=ld Deleted PERL definition: PERL=perl Deleted CFLAGS definition: CFLAGS=$(GFLAG) $(OPTIMIZE) $(CDEBUG) $(CCFLAGS) $(QACCFLAGS) $(PFLAGS)\ $(SHARED_CFLAG) $(USRFLAGS) Deleted LDFLAGS definition: LDFLAGS=-o $@ $(LDPATHFLAG)$(PRODLIBHOME) $(LDPATHFLAG)$(LIBHOME) STATIC_ORACLETTLIBS macro redefined by Oracle from $(KPUADEF) $(NTZEOBJ) $(NETLIBS) $(LIBRDBMS_CLT) \ $(LIBMM) $(CORELIBS) $(NETLIBS) $(LIBRDBMS_CLT) $(LIBPLS_CLT) \ $(LIBEPC) $(CORELIBS) $(LIBRDBMS_CLT) $(CORELIBS) to $(LLIBCLNTST) $(LDFLAGSLIST) SO_EXT macro redefined by Oracle from so to sl Deleted CC definition: CC=cc CCC macro redefined by Oracle from CC to `if [ -f /opt/aCC/bin/aCC ]; then echo '/opt/aCC/bin/aCC'; else echo 'cc'; fi ` LMAKE macro redefined by Oracle from make to /usr/ccs/bin/make FIND macro redefined by Oracle from find to /usr/bin/find CPP macro redefined by Oracle from cpp to $(CC) Deleted CPP definition: CPP=$(CC) SHELL macro redefined by Oracle from /bin/sh to /usr/bin/sh Deleted SHELL definition: SHELL=/usr/bin/sh Deleted AR definition: AR=ar Deleted AS definition: AS=as LDFLAGS macro redefined by Oracle from -o $@ $(LDPATHFLAG)$(PRODLIBHOME) $(LDPATHFLAG)$(LIBHOME) to -Wl,+s -Wl,+n $(OPTIMIZE) -o $@ -L$(PRODLIBHOME) -L$(LIBHOME) Deleted LDFLAGS definition: LDFLAGS= -Wl,+s -Wl,+n $(OPTIMIZE) -o $@ -L$(PRODLIBHOME) -L$(LIBHOME) LDLIBS macro redefined by Oracle from $(EXPDLIBS) $(EXOSLIBS) $(SYSLIBS) $(EXSYSLIBS) $(MATHLIB) $(USRLIBS) to $(EXPDLIBS) $(EXOSLIBS) $(SYSLIBS) $(EXSYSLIBS) $(MATHLIB) $(USRLIBS) $(LLIBTHREAD) LINK macro redefined by Oracle from $(LDCCOM) to $(CC) $(LDFLAGS) $(COMPOBJS) TTLIBS macro redefined by Oracle from $(LLIBCLNTSH) $(STATICTTLIBS) to $(NAETTOBJS) $(STATICTTLIBS) $(LLIBPLS) $(LLIBSQL) Deleting ORA_NLS = $(ORACLE_HOME)/ocommon/nls/admin/data/ because it is not already set in the environment and it can cause ORA-01019 errors. Deleted ORA_NLS definition: ORA_NLS = $(ORACLE_HOME)/ocommon/nls/admin/data/ Deleting ORA_NLS33 = $(ORACLE_HOME)/ocommon/nls/admin/data/ because it is not already set in the environment and it can cause ORA-01019 errors. Deleted ORA_NLS33 definition: ORA_NLS33 = $(ORACLE_HOME)/ocommon/nls/admin/data/ SHELL macro redefined by Oracle from /usr/bin/sh to /bin/sh Deleted SHELL definition: SHELL=/bin/sh Deleted LIB_EXT definition: LIB_EXT=a Deleted OBJ_EXT definition: OBJ_EXT=o SO_EXT macro redefined by Oracle from sl to so Deleted AR definition: AR=ar Deleted AS definition: AS=as Deleted CC definition: CC=cc CCC macro redefined by Oracle from `if [ -f /opt/aCC/bin/aCC ]; then echo '/opt/aCC/bin/aCC'; else echo 'cc'; fi ` to CC Deleted CHMOD definition: CHMOD=chmod CPP macro redefined by Oracle from $(CC) to cpp Deleted CPP definition: CPP=cpp Deleted ECHO definition: ECHO=echo FIND macro redefined by Oracle from /usr/bin/find to find Deleted LD definition: LD=ld LMAKE macro redefined by Oracle from /usr/ccs/bin/make to make Deleted PERL definition: PERL=perl Deleted CFLAGS definition: CFLAGS=$(GFLAG) $(OPTIMIZE) $(CDEBUG) $(CCFLAGS) $(QACCFLAGS) $(PFLAGS)\ $(SHARED_CFLAG) $(USRFLAGS) LINK macro redefined by Oracle from $(CC) $(LDFLAGS) $(COMPOBJS) to $(LDCCOM) LDFLAGS macro redefined by Oracle from -Wl,+s -Wl,+n $(OPTIMIZE) -o $@ -L$(PRODLIBHOME) -L$(LIBHOME) to -o $@
Version of Oracle 8i
Hi All, I will appreciate it if you could please let me know the following info: latest version of DBI.pm which is compatible with the latest version of Oracle 8, loaded on the latest HP-UX machine. Looking forward to hearing from you, Thank you, Naren
Problems with DBI in the bind values substitution on a MySQL select
Hi, This is a problem that I have encountered with the substitution of bind values into an SQL statement. This is a generalized statement of the SQL that I am trying to get to work: $statement = q{ SELECT * FROM table WHERE field1 = ? AND field2 = ? ORDER BY fieldname LIMIT ? , ? }; Here is how the statement is executed: @queryresults = $dbh-selectall_arrayref( $statement, { dbi_fetchall_arrayref_attr = {} }, @bind_values, $offset, $rows ); Here is one set of bind values that works on the substitution: @bind_values = [ 1, '%data%' ]; $offset = 0; $rows = 30; The first field is a numeric field in the database. The second field is a string field in the database. The last two bind values are substituted into the limit part of the SQL query. With those bind values passed in, the query executes properly with no errors. When the '$offset' is changed to 30, I get the error: DBD::mysql::db selectall_arrayref failed: You have an error in your SQL syntax near ''30' , 30' at line xx If I set the $offset to any value other than zero (0), I get the error but the first number is whatever I change the $offset to. Here are some other things that I have tried to get it to work: @queryresults = $dbh-selectall_arrayref( $statement, { dbi_fetchall_arrayref_attr = {} }, @bind_values, 0 + $offset, $rows ); @queryresults = $dbh-selectall_arrayref( $statement, { dbi_fetchall_arrayref_attr = {} }, @bind_values, $offset + 0, $rows ); @queryresults = $dbh-selectall_arrayref( $statement, { dbi_fetchall_arrayref_attr = {} }, @bind_values, int($offset), $rows ); None of these worked. It still seems to quote the number coming into the statement which causes the SQL engine to complain. In the program that I am using, the $offset value is passed through HTML::FormValidator and is run through a field_filter which is 'sub { return (shift =~ /^([0-9]+)$/)[0] }'. This should return a number only. If I hardcode a numeric value of 30 into selectall_arrayref where $offset is, it works. But if the $offset is set to 30 and used in the selectall_arrayref, it fails. I am using DBI version 1.18 Is there a way to tell it to NOT quote that number? The number of values in the @bind_values changes depending on the data that is submitted to the cgi script. Thanks for any help that you might be able to provide, Trevor Schellhorn Internet Marketing Center
Re: DBD-Informix Fails to Connect After Editing sqlhosts File
[EMAIL PROTECTED] wrote: After commenting out two lines in our sqlhosts file attempts to use DBI errored out with Informix SQL error 25596: The INFORMIXSERVER value is not listed in the sqlhosts file. So, what was the value of $INFORMIXSERVER ($ENV{INFORMIXSERVER})? Why did you decide to eliminate that entry from the sqlhosts file? Why does ESQL/C insist that the entry implied by $INFORMIXSERVER is valid even when you specify the database server in the connect string? I'm not convinced I care about the answer to the first question; I'm moderately convinced that the problem is precisely that you removed an entry which was referenced by $INFORMIXSERVER. And I'm moderately convinced that there is no good answer to the third question, because it is a usability bug, but anyway, you have to have $INFORMIXSERVER set to a valid server even when you specify the server in the DBI-connect call. I hope to get this fixed eventually, but it make take a while. The lines commented out did not pertain to the server to which the connection was attempted nor to the server DBD-Informix was built against. After uncommenting the lines DBI connected and returned the proper values. It is not unusual in our development environment to alter the sqlhosts file which has not impacted accessing those Informix servers not affected by the sqlhosts file change from other clients, eg., dbaccess, esql-c, Uniface. Does DBI require rebuilding DBD whenever the sqlhosts file changes and is there someway, eg., specifying a proxy file that will not be changed, to avoid this inconvenience? No, the sqlhosts file is completely dynamic. You can even select the name with the INFORMIXSQLHOSTS environment variable at run time. However, you must have a valid entry in the sqlhosts file for the value specified by $INFORMIXSERVER, and you must have $INFORMIXSERVER set in the environment, even if you specify the required server explicitly in the connect string. And it isn't DBD::Informix's fault! Our system architecture: DBI v. 1.15 DBD-Informix v 1.00.PC1 Perl v 5.6.1 Solaris 5.6 Informix v 7.31UD1 Thanks for the summary info. -- Jonathan Leffler ([EMAIL PROTECTED], [EMAIL PROTECTED]) Guardian of DBD::Informix 1.00.PC1 -- see http://www.cpan.org/ #include disclaimer.h
Re: calling stored procedures with DBD::Informix
John Saylor wrote: I need to call a stored procedure, and I can't find the documentation and I'm not sure I remember the syntax, so I'm writing this note in the hope that someone will help me. I think it's something like this: $s = 'STORED PROCEDURE ( var1, var2 ); $dbh-do ( $s ); With all the error checking stuff left out for brevity. Am I right? I'm sorry I was away on vacation, starting the day you asked this question... No, as you will have found out by now. The magic word is 'EXECUTE' in place of 'STORED'. If the procedure returns values, then you need to treat it as if it was a SELECT statement (in Informix and hence DBD::Informix -- the rules may be different for other DBMS). -- Jonathan Leffler ([EMAIL PROTECTED], [EMAIL PROTECTED]) Guardian of DBD::Informix 1.00.PC1 -- see http://www.cpan.org/ #include disclaimer.h
RE: Thanks All on How to get last insert id using DBI
Like Paul mentioned you need to use {mysql_insertid} instead since insert_id is deprecated. Ilya Sterin -Original Message- From: Dexter To: [EMAIL PROTECTED]; Paul DuBois Sent: 6/7/01 6:19 PM Subject: Re: Thanks All on How to get last insert id using DBI I tried the $-{insertid} It does look alfully weird Ha, Ha Imeant $sth-{insert_id} I know when using PHP , simply uses the insert_id() function . thanks Dexter *** I suppose not, it looks pretty weird. You might have better luck with: $dbh-{mysql_insertid} At least, if you're using MySQL. Thanks Dexter - Original Message - From: Paul DuBois [EMAIL PROTECTED] To: Dexter [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, June 07, 2001 2:07 PM Subject: Re: How to get last insert id using DBI At 5:03 PM -0700 6/7/01, Dexter wrote: How do I get the last insert using DBi. I tried the $-{insertid} but that doesnt work. I suppose not, it looks pretty weird. You might have better luck with: $dbh-{mysql_insertid} At least, if you're using MySQL. Thanks Dexter -- Paul DuBois, [EMAIL PROTECTED]
Re: Anyone else experiencing problems with the dbi-* mailing lists?
Edward J. Sabol wrote: Is there a problem with the [EMAIL PROTECTED], [EMAIL PROTECTED], and [EMAIL PROTECTED] mailing lists? I seem to be experiencing sporadic delivery problems. No problems here. (If you don't count that nasty unsubscribe me thread... ;-))) ) MPE has archived 242 dbi-users e-mails in the month of June, theaimsgroup.com has archived 22, and I've received even less than that. I got about 250-300 mails from [EMAIL PROTECTED] in June (no exact count because I deletet the trash). Best regards, Martin Stricker -- Homepage: http://www.martin-stricker.de/ Registered Linux user #210635: http://counter.li.org/
Re: (Fwd) Anyone else experiencing problems with the dbi-* mailinglists?
On Thu, 7 Jun 2001, Tim Bunce wrote: [...] Is there a problem with the [EMAIL PROTECTED], [EMAIL PROTECTED], and [EMAIL PROTECTED] mailing lists? I seem to be experiencing sporadic delivery problems. Your network is blocking connections from the perl.org mailhost. archive.develooper.com (and www.perl.org and others) are on the same box. host -t mx alderaan.gsfc.nasa.gov alderaan.gsfc.nasa.gov mail is handled (pri=0) by alderaan.gsfc.nasa.gov $ telnet alderaan.gsfc.nasa.gov 25 Trying 128.183.16.213... ... (times out). # /var/qmail/bin/qmail-qread | grep -v done | grep alderaan.gsfc.nasa.gov| wc -l 412 (from the last week alone) Curiously enough there are 9 mails that made it through. a traceroute from a nearby network which might help your network administrator fix the problem: Matt's traceroute [v0.42] lux.valueclick.comThu Jun 7 16:05:23 2001 Keys: D - Display modeR - Restart statisticsQ - Quit Packets Pings Hostname %Loss Rcv Snt Last Best Avg Worst 1. 216.246.96.1 0%66 101 1 2. 209.85.223.49 0%66 446 13 3. hood-msfc-p1.softaware.com0%66 448 11 4. gigaethernet1-0.lee-12000.0%66 446 12 5. 500.POS3-1.GW6.LAX4.ALTER.0%66 558 21 6. 169.ATM2-0.XR2.LAX4.ALTER.0%66 557 16 7. 192.ATM2-0.TR2.LAX2.ALTER.0%66 558 23 8. 111.at-6-1-0.TR4.SCL1.ALTE0%6624 17 21 30 9. 399.ATM6-0.XR2.SJC1.ALTER.0%6616 16 19 30 10. 192.ATM5-0.BR2.SJC1.ALTER.0%6618 18 20 32 11. 192.150.31.29 0%6614 14 18 30 12. 128.161.3.94 0%6615 14 56226 13. s-GSFC12-ATM.NSN.NASA.GOV 0%5576 75 78 86 14. rtr-wan1-ef.gsfc.nasa.gov 0%5577 77 82 88 15. vlan910-csr2.gsfc.nasa.gov0%5586 77 83 86 16. rtr-b2-cat5.gsfc.nasa.gov 0%5581 78 84 95 17. 128.161.3.94100%05 000 0 - ask -- ask bjoern hansen, http://ask.netcetera.dk/ !try; do();
How to get last insert id using DBI
How do I get the last insert using DBi. I tried the $-{insertid} but that doesnt work. Thanks Dexter
Re: How to get last insert id using DBI
At 5:03 PM -0700 6/7/01, Dexter wrote: How do I get the last insert using DBi. I tried the $-{insertid} but that doesnt work. I suppose not, it looks pretty weird. You might have better luck with: $dbh-{mysql_insertid} At least, if you're using MySQL. Thanks Dexter -- Paul DuBois, [EMAIL PROTECTED]
install DBI problem
QUICK START GUIDE: The DBI requires one or more 'driver' modules to talk to databases. Check that a DBD::* module exists for the database you wish to use. Read the DBI README then Build/test/install the DBI by doing perl Makefile.PL make make test make install Then delete the source directory tree since it's no longer needed. Use the 'perldoc DBI' command to read the DBI documentation. Fetch the DBD::* driver module you wish to use and unpack it. It is often important to read the driver README file carefully. Generally the build/test/install/delete sequence is the same as for the DBI module. I executed second step: make C:\Perl\5.005\binmake make: Error -- No target C:\Perl\5.005\binmake test make: Error -- Don't know how to make test C:\Perl\5.005\binmake install make: Error -- Don't know how to make install How can I do? Thanks a lot! Pei
Re: getting a list of databases
Curt Russell Crandall wrote: Is the DBI-data_sources method the only facility available in the DBI to get a list of databases on a server? I'm trying to build a Perl/Tk application that would give me an interface similar to say RapidSQL where I can have a frame containing a list of all the databases on a server... by clicking one, I can enter that database and issue commands and stuff. Sybase won't return anything with data_sources and I'm not sure if Informix will either... those are the 2 dbs I'm concerned with at this moment. I know in Sybase I could just query the master..sysdatabases table to get this list, but I was hoping there'd be a more portable method available in the DBI especially since I don't know what command to issue in Informix to get a similar list. Have you tried using data_sources with DBD::Informix? If you don't have it, you must have a really, really, really ancient version of DBD::Informix and you are three to four years overdue for an upgrade. Check the test -- t/t??dblist.t IIRC. And/or the documentation? -- Jonathan Leffler ([EMAIL PROTECTED], [EMAIL PROTECTED]) Guardian of DBD::Informix 1.00.PC1 -- see http://www.cpan.org/ #include disclaimer.h
Re: Thanks All on How to get last insert id using DBI
I tried the $-{insertid} It does look alfully weird Ha, Ha Imeant $sth-{insert_id} I know when using PHP , simply uses the insert_id() function . thanks Dexter *** I suppose not, it looks pretty weird. You might have better luck with: $dbh-{mysql_insertid} At least, if you're using MySQL. Thanks Dexter - Original Message - From: Paul DuBois [EMAIL PROTECTED] To: Dexter [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, June 07, 2001 2:07 PM Subject: Re: How to get last insert id using DBI At 5:03 PM -0700 6/7/01, Dexter wrote: How do I get the last insert using DBi. I tried the $-{insertid} but that doesnt work. I suppose not, it looks pretty weird. You might have better luck with: $dbh-{mysql_insertid} At least, if you're using MySQL. Thanks Dexter -- Paul DuBois, [EMAIL PROTECTED]
RE: Thanks All on How to get last insert id using DBI
At 3:53 PM -0600 6/7/01, Sterin, Ilya wrote: Like Paul mentioned you need to use {mysql_insertid} instead since insert_id is deprecated. The other thing is that insertid was a statement handle attribute. However, if you issue your INSERT using $dbh-do(), you won't have a statement handle! So mysql_insertid can be used as a database handle attribute. Ilya Sterin -Original Message- From: Dexter To: [EMAIL PROTECTED]; Paul DuBois Sent: 6/7/01 6:19 PM Subject: Re: Thanks All on How to get last insert id using DBI I tried the $-{insertid} It does look alfully weird Ha, Ha Imeant $sth-{insert_id} I know when using PHP , simply uses the insert_id() function . thanks Dexter *** I suppose not, it looks pretty weird. You might have better luck with: $dbh-{mysql_insertid} At least, if you're using MySQL. Thanks Dexter - Original Message - From: Paul DuBois [EMAIL PROTECTED] To: Dexter [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, June 07, 2001 2:07 PM Subject: Re: How to get last insert id using DBI At 5:03 PM -0700 6/7/01, Dexter wrote: How do I get the last insert using DBi. I tried the $-{insertid} but that doesnt work. I suppose not, it looks pretty weird. You might have better luck with: $dbh-{mysql_insertid} At least, if you're using MySQL. Thanks Dexter -- Paul DuBois, [EMAIL PROTECTED] -- Paul DuBois, [EMAIL PROTECTED]
Re: Anyone else experiencing problems with the dbi-* mailing lists?
I have been having problems posting. The mail often bounces back to me, yet I can receive mail from the list and can mail individuals when replying to a post. The return message was saying that my account wasn't be recognized, or something, by the mailing list server. I also received a message from the mailing list about losing my account because they thought my email was invalid (or something like that). It has since cleared up. --Curt
Re: getting a list of databases
I didn't have an Informix DB available at the time, but yes it does return a list of dbs with data_sources... however, Sybase does not as well as many others. On Thu, 7 Jun 2001, Jonathan Leffler wrote: Curt Russell Crandall wrote: Is the DBI-data_sources method the only facility available in the DBI to get a list of databases on a server? I'm trying to build a Perl/Tk application that would give me an interface similar to say RapidSQL where I can have a frame containing a list of all the databases on a server... by clicking one, I can enter that database and issue commands and stuff. Sybase won't return anything with data_sources and I'm not sure if Informix will either... those are the 2 dbs I'm concerned with at this moment. I know in Sybase I could just query the master..sysdatabases table to get this list, but I was hoping there'd be a more portable method available in the DBI especially since I don't know what command to issue in Informix to get a similar list. Have you tried using data_sources with DBD::Informix? If you don't have it, you must have a really, really, really ancient version of DBD::Informix and you are three to four years overdue for an upgrade. Check the test -- t/t??dblist.t IIRC. And/or the documentation? -- Jonathan Leffler ([EMAIL PROTECTED], [EMAIL PROTECTED]) Guardian of DBD::Informix 1.00.PC1 -- see http://www.cpan.org/ #include disclaimer.h
Re: getting a list of databases
Curt Russell Crandall writes: I didn't have an Informix DB available at the time, but yes it does return a list of dbs with data_sources... however, Sybase does not as well as many others. DBD::Sybase could be made to return the list of known servers (from the interfaces file), but not the list of databases, as that requires connecting to each of the servers in the interfaces file (and we need to know user/pwd for each server, etc - gets a little hairy). Michael On Thu, 7 Jun 2001, Jonathan Leffler wrote: Curt Russell Crandall wrote: Is the DBI-data_sources method the only facility available in the DBI to get a list of databases on a server? I'm trying to build a Perl/Tk application that would give me an interface similar to say RapidSQL where I can have a frame containing a list of all the databases on a server... by clicking one, I can enter that database and issue commands and stuff. Sybase won't return anything with data_sources and I'm not sure if Informix will either... those are the 2 dbs I'm concerned with at this moment. I know in Sybase I could just query the master..sysdatabases table to get this list, but I was hoping there'd be a more portable method available in the DBI especially since I don't know what command to issue in Informix to get a similar list. Have you tried using data_sources with DBD::Informix? If you don't have it, you must have a really, really, really ancient version of DBD::Informix and you are three to four years overdue for an upgrade. Check the test -- t/t??dblist.t IIRC. And/or the documentation? -- Jonathan Leffler ([EMAIL PROTECTED], [EMAIL PROTECTED]) Guardian of DBD::Informix 1.00.PC1 -- see http://www.cpan.org/ #include disclaimer.h -- Michael Peppler - Data Migrations Inc. - [EMAIL PROTECTED] http://www.mbay.net/~mpeppler - [EMAIL PROTECTED] International Sybase User Group - http://www.isug.com Sybase on Linux mailing list: [EMAIL PROTECTED]
RE: Anyone else experiencing problems with the dbi-* mailing list s?
-Original Message- From: Chouda, Prem [mailto:[EMAIL PROTECTED]] Sent: Friday, June 08, 2001 6:31 AM To: 'Sterin, Ilya'; 'Edward J. Sabol '; '[EMAIL PROTECTED] ' Subject: RE: Anyone else experiencing problems with the dbi-* mailing list s? I am with Ilya. I am not facing any problems from last one month. :-) Then your lucky. Not that there is a problem with this list or the listserver, it's the mail host for perl.org. The hosting company valueclick.com should be looking at this but I'm only back on being able to send mail to perl.org after two weeks. No problems getting mail though (nothing wrong with my mail server -- he, he!) This is not worth discussion here. Nobody can do anything about it. Take it up with the sysadmin. --Neil __ Please Note : Only the intended recipient is authorised to access or use this e-mail. If you are not the intended recipient, please delete this e-mail and notify the sender immediately. The contents of this e-mail are the writer's opinion and are not necessarily endorsed by the Gunz Companies unless expressly stated. We use virus scanning software but exclude all liability for viruses or similar in any attachment.
Re: install DBI problem
It looks like you are using ActiveState Perl. If you are, use PPM to install DBI and DBD::xxx. The instructions for it come with ActiveState Perl. -- Mac :}) ** I normally forward private database questions to the DBI mail lists. ** Give a hobbit a fish and he'll eat fish for a day. Give a hobbit a ring and he'll eat fish for an age. - Original Message - From: Pei Du [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, June 07, 2001 16:27 Subject: install DBI problem QUICK START GUIDE: The DBI requires one or more 'driver' modules to talk to databases. Check that a DBD::* module exists for the database you wish to use. Read the DBI README then Build/test/install the DBI by doing perl Makefile.PL make make test make install Then delete the source directory tree since it's no longer needed. Use the 'perldoc DBI' command to read the DBI documentation. Fetch the DBD::* driver module you wish to use and unpack it. It is often important to read the driver README file carefully. Generally the build/test/install/delete sequence is the same as for the DBI module. I executed second step: make C:\Perl\5.005\binmake make: Error -- No target C:\Perl\5.005\binmake test make: Error -- Don't know how to make test C:\Perl\5.005\binmake install make: Error -- Don't know how to make install How can I do?
RE: Version of Oracle 8i
DBI 1.18 DBD::Oracle 1.07 You can usually get the latest versions from CPAN. Not sure what you mean by compatible, they are all compatible, maybe you meant bugs. Ilya Sterin -Original Message- From: Adimoolam Narayanan [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 06, 2001 9:03 AM To: [EMAIL PROTECTED] Subject: Version of Oracle 8i Hi All, I will appreciate it if you could please let me know the following info: latest version of DBI.pm which is compatible with the latest version of Oracle 8, loaded on the latest HP-UX machine. Looking forward to hearing from you, Thank you, Naren