Any other mail list?
Hi, all, I'm new to the list. I just begin to learn perl, and I want some other mail list about perl programming (like CGI, GUI, Network, IPC, RPC, etc) besides DBI. Who can tell me. Thanks a lot!!! Luo Zhenyu
RE: Where is it??
Works on my system. ActiveState 5.6, perldoc DBD::Oracle. Try to reinstall the module. Ilya Sterin -Original Message- From: Pettit, Chris L To: Dbi-Users (E-mail) Sent: 04/09/2001 6:09 AM Subject: Where is it?? I've seen several references to perldoc DBD::Oracle. from my win32 system, an input: perldoc DBD::Oracle returns: no documentation found. I have the modules installed via PPM. I tried www.perldoc.com and a search for DBD::Oracle returns (0). I'm starting to think this might be a win32 thing, or I've missed something keenly simple. === chris "They have computers, and they may have other weapons of mass destruction." - Janet Reno "If you think there's a solution, you're a part of the problem." - George Carlin ==
uninstall DBI
I'm playing with different client server configurations, and I want to "uninstall" DBI from one machine - I ran "make uninstall", but it says that unistall is deprecated - it shows a bunch of unlink's, but when I look after the uninstall ends, all the files are still there. How do I uninstall DBI? TIA. -- Hardy Merrill Mission Critical Linux, Inc. http://www.missioncriticallinux.com
RE: Where is it?? I think I know Y.
Well, it's another mystery. My classified machine at work, that I manually loaded is fine. It's there. My machine(s) at home, loaded with PPM, don't have it. -- Amid a bright flash, and odor of sizzled cerebral tissue. "Ahh,huh, I think I know the answer ", he exclaimed, sounding nearly astute as Maxwell Smart. -- At work I *accidentally* loaded DBD::Oracle not DBD::Oracle8. Then loaded DBD::Oracle8. I'd be willing to bet, at least $1-$.98, I never loaded DBD::Oracle at home. So, I will have to see if the info comes up with DBD::Oracle8. chris -Original Message- From: Sterin, Ilya [mailto:[EMAIL PROTECTED]] Sent: Monday, April 09, 2001 9:44 AM To: 'Pettit, Chris L '; 'Dbi-Users (E-mail) ' Subject: RE: Where is it?? Works on my system. ActiveState 5.6, perldoc DBD::Oracle. Try to reinstall the module. Ilya Sterin -Original Message- From: Pettit, Chris L To: Dbi-Users (E-mail) Sent: 04/09/2001 6:09 AM Subject: Where is it?? I've seen several references to perldoc DBD::Oracle. from my win32 system, an input: perldoc DBD::Oracle returns: no documentation found. I have the modules installed via PPM. I tried www.perldoc.com and a search for DBD::Oracle returns (0). I'm starting to think this might be a win32 thing, or I've missed something keenly simple. === chris "They have computers, and they may have other weapons of mass destruction." - Janet Reno "If you think there's a solution, you're a part of the problem." - George Carlin ==
[OT] Re: Any other mail list?
luozhenyu wrote: I'm new to the list. I just begin to learn perl, and I want some other mail list about perl programming (like CGI, GUI, Network, IPC, RPC, etc) besides DBI. Who can tell me. Thanks a lot!!! http://lists.perl.org
Re: Where is it?? I think I know Y.
My system with ActivePerl has never had DBD::Oracle8 loaded, just DBD::Oracle. Is the DBD::Oracle documentation in the Online Documentation in your DBD::Oracle8 only machine? If it is a problem with the PPM module, you should report it to ActiveState. Their mail lists are described at http://www.ActiveState.com/ . -- 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: "Pettit, Chris L" [EMAIL PROTECTED] To: "Dbi-Users (E-mail)" [EMAIL PROTECTED] Cc: "Sterin, Ilya" [EMAIL PROTECTED] Sent: Monday, April 09, 2001 7:30 AM Subject: RE: Where is it?? I think I know Y. Well, it's another mystery. My classified machine at work, that I manually loaded is fine. It's there. My machine(s) at home, loaded with PPM, don't have it. -- Amid a bright flash, and odor of sizzled cerebral tissue. "Ahh,huh, I think I know the answer ", he exclaimed, sounding nearly astute as Maxwell Smart. -- At work I *accidentally* loaded DBD::Oracle not DBD::Oracle8. Then loaded DBD::Oracle8. I'd be willing to bet, at least $1-$.98, I never loaded DBD::Oracle at home. So, I will have to see if the info comes up with DBD::Oracle8. chris -Original Message- From: Sterin, Ilya [mailto:[EMAIL PROTECTED]] Sent: Monday, April 09, 2001 9:44 AM To: 'Pettit, Chris L '; 'Dbi-Users (E-mail) ' Subject: RE: Where is it?? Works on my system. ActiveState 5.6, perldoc DBD::Oracle. Try to reinstall the module. Ilya Sterin -Original Message- From: Pettit, Chris L To: Dbi-Users (E-mail) Sent: 04/09/2001 6:09 AM Subject: Where is it?? I've seen several references to perldoc DBD::Oracle. from my win32 system, an input: perldoc DBD::Oracle returns: no documentation found. I have the modules installed via PPM. I tried www.perldoc.com and a search for DBD::Oracle returns (0). I'm starting to think this might be a win32 thing, or I've missed something keenly simple. === chris "They have computers, and they may have other weapons of mass destruction." - Janet Reno "If you think there's a solution, you're a part of the problem." - George Carlin ==
RE: Problems builing and testing DBD::ODBC with Cygwin
That was indeed the patch that I used. I have since discovered that there were many copies of sqlext.h on my machine and one had an erroneous function prototype: The prototype that I found was: SQLRETURN SQL_API SQLDriverConnect(SQLHDBC,SQLHWND,SQLCHAR,SQLSMALLINT,SQLCHAR*,SQLSMALLINT,SQLSMALLINT*,SQLUSMALLINT); But it should have been: SQLRETURN SQL_API SQLDriverConnect(SQLHDBC,SQLHWND,SQLCHAR*,SQLSMALLINT,SQLCHAR*,SQLSMALLINT,SQLSMALLINT*,SQLUSMALLINT); This fixes the compiler warning, but the tests still fail as bad as before. What next? - Paul At 10:40 AM 4/9/2001 +1000, Neil Lunn wrote: Paul, Was the patch applied from this message. http://sources.redhat.com/ml/cygwin/2000-08/msg00464.html This should apply to a clean distribution of DBD-ODBC-0.28. Neil -Original Message- From: Paul A. Chernoch [mailto:[EMAIL PROTECTED]] Sent: Sunday, April 08, 2001 7:16 AM To: [EMAIL PROTECTED] Subject: Problems builing and testing DBD::ODBC with Cygwin I searched through the Cygwin archives on redhat and got part way there. I have patched my Makefile.PL to reflect their recommendations (like #UNDEF WIN32 and removing "-lodbccp32") to deal with the win32.h problems. This got me to be able to compile at least. But I get one troublesome warning, and most of the tests fail. The warning below is "warning: passing arg 3 of `SQLDriverConnect' makes integer from pointer without a cast". Any suggestions? I use perl 5.6.1 on Windows 2000, using cygwin 1.1.8. - Paul -- gcc -c -I. -I/usr/lib/perl5/site_perl/5.6.1/cygwin/auto/DBI -DPERL_USE_SAFE_PUTENV -DHAS_SBRK_PROTO -fno-strict-aliasing -DUSEIMPORTLIB -O2 -DVERSION=\"0.28\" -DXS_VERSION=\"0.28\" -I/usr/lib/perl5/5.6.1/cygwin/CORE ODBC.c gcc -c -I. -I/usr/lib/perl5/site_perl/5.6.1/cygwin/auto/DBI -DPERL_USE_SAFE_PUTENV -DHAS_SBRK_PROTO -fno-strict-aliasing -DUSEIMPORTLIB -O2 -DVERSION=\"0.28\" -DXS_VERSION=\"0.28\" -I/usr/lib/perl5/5.6.1/cygwin/CORE dbdimp.c dbdimp.c: In function `odbc_db_login': dbdimp.c:171: warning: passing arg 3 of `SQLDriverConnect' makes integer from pointer without a cast Running Mkbootstrap for DBD::ODBC () chmod 644 ODBC.bs rm -f blib/arch/auto/DBD/ODBC/ODBC.dll LD_RUN_PATH="/usr/local/lib" ld2 -o blib/arch/auto/DBD/ODBC/ODBC.dll -s -L/usr/local/lib ODBC.o dbdimp.o -lodbc32 /usr /lib/perl5/5.6.1/cygwin/CORE/libperl5_6_1.a -lodbc32 dllwrap --dllname ODBC.dll --driver-name gcc --dlltool dlltool --export-all-symbols --as as --output-def libODBC.def --o utput-lib libODBC.a \ -s -L/usr/local/lib ODBC.o dbdimp.o -lodbc32 /usr/lib/perl5/5.6.1/cygwin/CORE/libperl5_6_1.a -lodbc32 dllwrap: no export definition file provided dllwrap: creating one, but that may not be what you want mv ODBC.dll libODBC.a blib/arch/auto/DBD/ODBC/ chmod 755 blib/arch/auto/DBD/ODBC/ODBC.dll cp ODBC.bs blib/arch/auto/DBD/ODBC/ODBC.bs chmod 644 blib/arch/auto/DBD/ODBC/ODBC.bs bash-2.04$ make test PERL_DL_NONLAZY=1 /usr/bin/perl5.6.1 -Iblib/arch -Iblib/lib -I/usr/lib/perl5/5.6.1/cygwin -I/usr/lib/perl5/5.6.1 -e 'use Test::Harness qw(runtests $verbose); $verbose=0; runtests @ARGV;' t/*.t t/01baseok t/02simple..ok 1/14 0 [main] perl5.6.1 1980 handle_exceptions: Exception: STATUS_ACCESS_VIOLATION 1770 [main] perl5.6.1 1980 stackdump: Dumping stack trace to perl5.6.1.exe.stackdump t/02simple..dubious Test returned status 0 (wstat 139, 0x8b) test program seems to have generated a core DIED. FAILED tests 2-14 Failed 13/14 tests, 7.14% okay t/03dbatt...ok 1/6 0 [main] perl5.6.1 2008 handle_exceptions: Exception: STATUS_ACCESS_VIOLATION 3815 [main] perl5.6.1 2008 stackdump: Dumping stack trace to perl5.6.1.exe.stackdump t/03dbatt...dubious Test returned status 0 (wstat 139, 0x8b) test program seems to have generated a core DIED. FAILED tests 2-6 Failed 5/6 tests, 16.67% okay t/05methok 1/6 0 [main] perl5.6.1 2024 handle_exceptions: Exception: STATUS_ACCESS_VIOLATION 1250 [main] perl5.6.1 2024 stackdump: Dumping stack trace to perl5.6.1.exe.stackdump t/05methdubious Test returned status 0 (wstat 139, 0x8b) test program seems to have generated a core DIED. FAILED tests 2-6 Failed 5/6 tests, 16.67% okay t/09bindok 1/9 0 [main] perl5.6.1 1968 handle_exceptions: Exception: STATUS_ACCESS_VIOLATION 1240 [main] perl5.6.1 1968 stackdump: Dumping stack trace to perl5.6.1.exe.stackdump t/09binddubious Test returned status 0 (wstat 139, 0x8b) test program seems to have generated a core DIED. FAILED tests 2-9 Failed 8/9 tests, 11.11% okay Failed Test Status Wstat Total Fail Failed List of Failed
Re: (Fwd) Calling an Oracle Stored Procedure from PERL
I have called Oracle stored procedures from Perl successfully using bound named parameters. I am too busy to reduce my program down to a size suitable for posting to a mailing list, but any interested parties may e-mail me directly. In a separate message I will respond directly to the questioner. My success has been with Perl 5.005_03 (an older ActiveState build 523) and DBI 1.14. I am trying to port it to Cygwin, but am having trouble with DBD::ODBC. (The DBD::Oracle part does work, though.) DBI 1.15 causes problems with DBD::Oracle for some reason. - Paul At 04:00 PM 4/8/2001 -0700, you wrote: I answered you directly last week. Perhaps you should use SQL*Loader instead. -- 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: "Tim Bunce" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Sunday, April 08, 2001 11:47 AM Subject: (Fwd) Calling an Oracle Stored Procedure from PERL From: [EMAIL PROTECTED] () To: [EMAIL PROTECTED] Subject: Calling an Oracle Stored Procedure from PERL Date: Fri, 6 Apr 2001 16:13:49 -0700 I am a beginner PERL programmer and looking for some advice if anyone can help. I just started to learn PERL about 2-3 weeks ago and I like it alot!!! The problem...I currently receive a daily flat file that is loaded into an Oracle (8.0.5) database. When I assumed responsibility of this system the PERL scripts were already written. Since some of the data is incorrect that gets loaded into the Oracle db I need to update it. I have written an Oracle Package (Stored Procedure) in PL/SQL to perform this update HOWEVER, I don't know how to call the package from the PERL script. I'm assuming it is relatively simple however I'm unsure and was looking for some help. I have installed the DBI, DBD::Oracle modules. I am able to connect and retrieve data from my Oracle db. Do I need anything more? It just the procedure that I have all my update code written into and compiled reside on the server and I'm not sure how to call the Package. Help?? Anyone have any suggestions/advice...or better yetAn example piece of code with comments would be great if you have one!?!?! . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Paul Anton Chernoch Zeborg, Inc. 500 West Cummings Park Woburn, MA 01801 t: 781.759.0105 f: 781.935.5090 c: 781.606.7382 http://www.zeborg.com This message is a personal and confidential communication. If you are not the intended recipient, please do not read, copy, or use it, and do not disclose it to others. Please notify the sender of the delivery error by replying to this message, and then delete it from your system. Thank you. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
LIKE / QUOTE probleme ?
Hi, I've got an problem develloping a research tool... Well, using quote param ($dbh-quote (string); )... I would like to get juste that : va\nukl\sjj But using that one it's return : 'va\nukl\sjj' How to cancel the ' and ' at the top of the return string and at the end ? Just for information I do a LIKE reuquest : $dbh-prepare("SELECT foo FROM bar WHERE fore LIKE '%". $dbh-quote( $string ). "%'"; Thanks, I think that I'm explicit ? If you can't understand what I mean, well I suck :/ -- =-~-=-~-=-~-=-~-=-~-=-~-=-~-=-~-=-~-=-~-=-~-=-~-=-~-=-~-=-~-=-~-=-~-= Nicolas JOURDEN - [EMAIL PROTECTED] - #41100039 - +33 0681940905 http://www.wedoo.com/ - La Nouvelle Facon de Surfer... http://ddx.wedoo.com/ - Mon site perso. Programmeur, Integrateur | Perl, CGI, Mysql/PostgreSQL, HTML, Design =-~-=-~-=-~-=-~-=-~-=-~-=-~-=-~-=-~-=-~-=-~-=-~-=-~-=-~-=-~-=-~-=-~-=
Re: LIKE / QUOTE probleme ?
On Mon, Apr 09, 2001 at 06:01:19PM +0200, Nicolas JOURDEN wrote: Hi, I've got an problem develloping a research tool... Well, using quote param ($dbh-quote (string); )... I would like to get juste that : va\nukl\sjj But using that one it's return : 'va\nukl\sjj' How to cancel the ' and ' at the top of the return string and at the end ? But that's the whole point of calling quote()... :) Just for information I do a LIKE reuquest : $dbh-prepare("SELECT foo FROM bar WHERE fore LIKE '%". $dbh-quote( $string ). "%'"; Try this instead: $sth = $dbh-prepare("SELECT foo FROM bar WHERE fore LIKE " . $dbh-quote("%$string%")); Or, with placeholders: $sth = $dbh-prepare("SELECT foo FROM bar WHERE fore LIKE ?"); $sth-execute("%$string%"); Ronald
RE: Problems builing and testing DBD::ODBC with Cygwin
Neil, I must sheepishly admit that I had already made changes to the Makefile.pl before applying the patch so the patch was not entirely successful. After getting a fresh copy of the library and applying the patch, all is well and not only the tests but my application run successfully. Thank you for your assistance and those critical words "apply to a clean distribution". - Paul At 10:40 AM 4/9/2001 +1000, Neil Lunn wrote: Paul, Was the patch applied from this message. http://sources.redhat.com/ml/cygwin/2000-08/msg00464.html This should apply to a clean distribution of DBD-ODBC-0.28. Neil -Original Message- From: Paul A. Chernoch [mailto:[EMAIL PROTECTED]] Sent: Sunday, April 08, 2001 7:16 AM To: [EMAIL PROTECTED] Subject: Problems builing and testing DBD::ODBC with Cygwin I searched through the Cygwin archives on redhat and got part way there. I have patched my Makefile.PL to reflect their recommendations (like #UNDEF WIN32 and removing "-lodbccp32") to deal with the win32.h problems. This got me to be able to compile at least. But I get one troublesome warning, and most of the tests fail. The warning below is "warning: passing arg 3 of `SQLDriverConnect' makes integer from pointer without a cast". Any suggestions? I use perl 5.6.1 on Windows 2000, using cygwin 1.1.8. - Paul -- gcc -c -I. -I/usr/lib/perl5/site_perl/5.6.1/cygwin/auto/DBI -DPERL_USE_SAFE_PUTENV -DHAS_SBRK_PROTO -fno-strict-aliasing -DUSEIMPORTLIB -O2 -DVERSION=\"0.28\" -DXS_VERSION=\"0.28\" -I/usr/lib/perl5/5.6.1/cygwin/CORE ODBC.c gcc -c -I. -I/usr/lib/perl5/site_perl/5.6.1/cygwin/auto/DBI -DPERL_USE_SAFE_PUTENV -DHAS_SBRK_PROTO -fno-strict-aliasing -DUSEIMPORTLIB -O2 -DVERSION=\"0.28\" -DXS_VERSION=\"0.28\" -I/usr/lib/perl5/5.6.1/cygwin/CORE dbdimp.c dbdimp.c: In function `odbc_db_login': dbdimp.c:171: warning: passing arg 3 of `SQLDriverConnect' makes integer from pointer without a cast Running Mkbootstrap for DBD::ODBC () chmod 644 ODBC.bs rm -f blib/arch/auto/DBD/ODBC/ODBC.dll LD_RUN_PATH="/usr/local/lib" ld2 -o blib/arch/auto/DBD/ODBC/ODBC.dll -s -L/usr/local/lib ODBC.o dbdimp.o -lodbc32 /usr /lib/perl5/5.6.1/cygwin/CORE/libperl5_6_1.a -lodbc32 dllwrap --dllname ODBC.dll --driver-name gcc --dlltool dlltool --export-all-symbols --as as --output-def libODBC.def --o utput-lib libODBC.a \ -s -L/usr/local/lib ODBC.o dbdimp.o -lodbc32 /usr/lib/perl5/5.6.1/cygwin/CORE/libperl5_6_1.a -lodbc32 dllwrap: no export definition file provided dllwrap: creating one, but that may not be what you want mv ODBC.dll libODBC.a blib/arch/auto/DBD/ODBC/ chmod 755 blib/arch/auto/DBD/ODBC/ODBC.dll cp ODBC.bs blib/arch/auto/DBD/ODBC/ODBC.bs chmod 644 blib/arch/auto/DBD/ODBC/ODBC.bs bash-2.04$ make test PERL_DL_NONLAZY=1 /usr/bin/perl5.6.1 -Iblib/arch -Iblib/lib -I/usr/lib/perl5/5.6.1/cygwin -I/usr/lib/perl5/5.6.1 -e 'use Test::Harness qw(runtests $verbose); $verbose=0; runtests @ARGV;' t/*.t t/01baseok t/02simple..ok 1/14 0 [main] perl5.6.1 1980 handle_exceptions: Exception: STATUS_ACCESS_VIOLATION 1770 [main] perl5.6.1 1980 stackdump: Dumping stack trace to perl5.6.1.exe.stackdump t/02simple..dubious Test returned status 0 (wstat 139, 0x8b) test program seems to have generated a core DIED. FAILED tests 2-14 Failed 13/14 tests, 7.14% okay t/03dbatt...ok 1/6 0 [main] perl5.6.1 2008 handle_exceptions: Exception: STATUS_ACCESS_VIOLATION 3815 [main] perl5.6.1 2008 stackdump: Dumping stack trace to perl5.6.1.exe.stackdump t/03dbatt...dubious Test returned status 0 (wstat 139, 0x8b) test program seems to have generated a core DIED. FAILED tests 2-6 Failed 5/6 tests, 16.67% okay t/05methok 1/6 0 [main] perl5.6.1 2024 handle_exceptions: Exception: STATUS_ACCESS_VIOLATION 1250 [main] perl5.6.1 2024 stackdump: Dumping stack trace to perl5.6.1.exe.stackdump t/05methdubious Test returned status 0 (wstat 139, 0x8b) test program seems to have generated a core DIED. FAILED tests 2-6 Failed 5/6 tests, 16.67% okay t/09bindok 1/9 0 [main] perl5.6.1 1968 handle_exceptions: Exception: STATUS_ACCESS_VIOLATION 1240 [main] perl5.6.1 1968 stackdump: Dumping stack trace to perl5.6.1.exe.stackdump t/09binddubious Test returned status 0 (wstat 139, 0x8b) test program seems to have generated a core DIED. FAILED tests 2-9 Failed 8/9 tests, 11.11% okay Failed Test Status Wstat Total Fail Failed List of Failed -- -- t/02simple.t 0 13914 13 92.86% 2-14 t/03dbatt.t0 139 65 83.33% 2-6
Re: Help with installing DBD::Oracle
'Just move the modules' is not the instruction for installing modules in ActiveState Perl. Look up PPM in the fine Online Documentation that came with ActiveState Perl and follow the instructions. The usual 'perl Makefile.pl ...' process doesn't normally work with ActiveState Perl, but ActiveState has a large library of pre-built modules ready for you to use. Don't forget to install DBI before DBD::Oracle or DBD::Oracle8 (depending on the version of Oracle client software you have in your system). -- 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: "Reuss, Bob" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, April 09, 2001 12:12 PM Subject: Help with installing DBD::Oracle I am trying to install the DBD::Oracle module on my Windows 2000 system. I have downloaded the module and have extracted the files via winzip. Here is where I run into problems. If I follow the installation instructions for active state and just move the modules, it doesn't work. If I run the makefile.pl file, I get multiple library errors, but, it finds all the oracle paths correctly, and the DBI paths, etc... The problem then is I need to run make on the makefile. I do not have a make utility installed on the windows 2000 server. I tried to install a few I found on the web but they did not work. Can anyone help me with solutions on how to install the module?
MSAccess DB Problem
To whom it may concern, Hi there, I have a problem trying to get my perl script working. I remember when I installed the Activestate implementation I did a test for DB Accessing and it worked fine but then I change to another implementation which one comes with an Apache Web Server so I decided to switch -I am talking about Indigostar -, the server worked fine, the cgis worked fine but when DB Accessing comes I can not figured out what is going on. I am using the DBI interface provided with the implementation please see the script below. #!perl -w use DBI; use CGI; # EXPLICIT VARIABLE DECLARE FOLLOWS my @drivers; my $driver; my @dsns; my $dsn; my $q; $q = new CGI; print $q-header; print $q-start_html("Conectividad"); @drivers = DBI-available_drivers; print "\n\n"; foreach $driver (@drivers){ print "$driver\n"; @dsns = DBI-data_sources($drivers[0]) or print "\t-No DSN available\n"; foreach $dsn (@dsns){ print "\t-$dsn\n"; }; }; print "\nAplicacion de acceso a la Base de Datos de Conectividad"; print $q-end_html; there is nothing fancy just trying to see what DSN do I have access, well it happens I setup a DSN previously called Test which one is pointing to my Access DB, but whenever I run the script I got the following: Content-Type: text/html !DOCTYPE HTML PUBLIC "-//IETF//DTD HTML//EN" HTMLHEADTITLEConectividad/TITLE /HEADBODY ADO -No DSN available ExampleP -No DSN available Proxy -No DSN available mysql -No DSN available Aplicacion de acceso a la Base de Datos de Conectividad/BODY/HTML Sorry I a sent you such a huge email, I am not even registered in your email List, but I want you to have the whole picture. Could you please register me, My name is Juan Antonio Celaya, I am from Mexico. Thanks beforehand. Best regards, Juan Antonio Celaya email: [EMAIL PROTECTED]
Binding to Output Parameters using DBD::ODBC
I am using DBD::ODBC drivers to connect to a Sybase 11.5 database. I have migrated a bunch of procedures from Oracle 8i that use output parameters to return data. I was migrating an abstract database interface that I built dbObject.pm, which previously called the Oracle stored procedures. I verified that the ODBC prepare statement was being correctly built {call get_seq(?,?,?)} and when I called DBI::bind_param_inout on the 3rd output parameter I got the error message "Can't bind output values (currently)". Now I know I am not the only one who has ever tried this so can someone please tell me how to bind Perl variables to stored procedure's output parameters using DBD::ODBC. Thanks, Bruce ``` (o o) --oOO--(_)--OOo Bruce HodgeDynaScript Internet Language P.O. Box 428 http://www.dynascript.com Greenfield, NY 12833 [EMAIL PROTECTED] -o00-00o---
Re: Binding to Output Parameters using DBD::ODBC
Bruce Hodge writes: I am using DBD::ODBC drivers to connect to a Sybase 11.5 database. I have migrated a bunch of procedures from Oracle 8i that use output parameters to return data. I was migrating an abstract database interface that I built dbObject.pm, which previously called the Oracle stored procedures. I verified that the ODBC prepare statement was being correctly built {call get_seq(?,?,?)} and when I called DBI::bind_param_inout on the 3rd output parameter I got the error message "Can't bind output values (currently)". Now I know I am not the only one who has ever tried this so can someone please tell me how to bind Perl variables to stored procedure's output parameters using DBD::ODBC. The OUTPUT params are probably returned as regular result rows in ODBC (that's the way they are returned when using the Sybase libraries...) Michael -- 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: Help with installing DBD::Oracle
What distribution of Perl are you using. If it is not ActiveState, then most likely the correct way to install your module would be to use the CPAN module. You can do a perldoc on CPAN for instructions. --Curt On Mon, 9 Apr 2001, Reuss, Bob wrote: Ok, I followd the docs, but ran into a new problem. We are using a product 'Interwoven' that installs a version of perl that I was told was using ActiveState Perl. After following the docs, I realized that this is not true. Now the question would be, how do I install the DBD::Oracle on a Windows 2000 system not running ActiveState Perl? Thanks, Bob Reuss -Original Message- From: Michael A. Chase [SMTP:[EMAIL PROTECTED]] Sent: Monday, April 09, 2001 2:47 PM To: Reuss, Bob; [EMAIL PROTECTED] Subject:Re: Help with installing DBD::Oracle 'Just move the modules' is not the instruction for installing modules in ActiveState Perl. Look up PPM in the fine Online Documentation that came with ActiveState Perl and follow the instructions. The usual 'perl Makefile.pl ...' process doesn't normally work with ActiveState Perl, but ActiveState has a large library of pre-built modules ready for you to use. Don't forget to install DBI before DBD::Oracle or DBD::Oracle8 (depending on the version of Oracle client software you have in your system). -- 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: "Reuss, Bob" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, April 09, 2001 12:12 PM Subject: Help with installing DBD::Oracle I am trying to install the DBD::Oracle module on my Windows 2000 system. I have downloaded the module and have extracted the files via winzip. Here is where I run into problems. If I follow the installation instructions for active state and just move the modules, it doesn't work. If I run the makefile.pl file, I get multiple library errors, but, it finds all the oracle paths correctly, and the DBI paths, etc... The problem then is I need to run make on the makefile. I do not have a make utility installed on the windows 2000 server. I tried to install a few I found on the web but they did not work. Can anyone help me with solutions on how to install the module?
Re: Binding to Output Parameters using DBD::ODBC
Can't do it... the Sybase driver does not allow placeholders in a prepare of a stored proc. I spent the better part of a day trying to figure out why my code wasn't working when doing something similar until I read Cheetah's section on DBD::Sybase. --Curt On Mon, 9 Apr 2001, Bruce Hodge wrote: I am using DBD::ODBC drivers to connect to a Sybase 11.5 database. I have migrated a bunch of procedures from Oracle 8i that use output parameters to return data. I was migrating an abstract database interface that I built dbObject.pm, which previously called the Oracle stored procedures. I verified that the ODBC prepare statement was being correctly built {call get_seq(?,?,?)} and when I called DBI::bind_param_inout on the 3rd output parameter I got the error message "Can't bind output values (currently)". Now I know I am not the only one who has ever tried this so can someone please tell me how to bind Perl variables to stored procedure's output parameters using DBD::ODBC. Thanks, Bruce ``` (o o) --oOO--(_)--OOo Bruce HodgeDynaScript Internet Language P.O. Box 428 http://www.dynascript.com Greenfield, NY 12833 [EMAIL PROTECTED] -o00-00o---
Re: Binding to Output Parameters using DBD::ODBC
Ooops, I thought you were using the DBD::Sybase driver. Sorry. On Mon, 9 Apr 2001, Bruce Hodge wrote: I am using DBD::ODBC drivers to connect to a Sybase 11.5 database. I have migrated a bunch of procedures from Oracle 8i that use output parameters to return data. I was migrating an abstract database interface that I built dbObject.pm, which previously called the Oracle stored procedures. I verified that the ODBC prepare statement was being correctly built {call get_seq(?,?,?)} and when I called DBI::bind_param_inout on the 3rd output parameter I got the error message "Can't bind output values (currently)". Now I know I am not the only one who has ever tried this so can someone please tell me how to bind Perl variables to stored procedure's output parameters using DBD::ODBC. Thanks, Bruce ``` (o o) --oOO--(_)--OOo Bruce HodgeDynaScript Internet Language P.O. Box 428 http://www.dynascript.com Greenfield, NY 12833 [EMAIL PROTECTED] -o00-00o---
Re: Binding to Output Parameters using DBD::ODBC
Curt Russell Crandall writes: Can't do it... the Sybase driver does not allow placeholders in a prepare of a stored proc. I spent the better part of a day trying to figure out why my code wasn't working when doing something similar until I read Cheetah's section on DBD::Sybase. The next version of DBD::Sybase *will* allow this (although it still won't handle in/out bindings) Michael -- 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: Help with installing DBD::Oracle
If it's not ActiveState Perl, you need to build the modules with the same C compiler and libraries as were used to create Perl. You can find out most of that information by running 'perl -V'. If they didn't use MSVC, you will probably also need to use dmake in place of nmake which is available from the CPAN/modules/by-authors/id/GSAR directory in CPAN. Your best bet for getting the correct information is to talk to the people who originally built the perl you are using. Good luck. You're going to need it. Most of the time we recommend starting with a fresh, local build of perl, but that might mess up Interwoven. -- 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: "Reuss, Bob" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, April 09, 2001 1:27 PM Subject: RE: Help with installing DBD::Oracle Ok, I followd the docs, but ran into a new problem. We are using a product 'Interwoven' that installs a version of perl that I was told was using ActiveState Perl. After following the docs, I realized that this is not true. Now the question would be, how do I install the DBD::Oracle on a Windows 2000 system not running ActiveState Perl?
RE: MSAccess DB Problem
CHANGE: @dsns = DBI-data_sources($drivers[0]) or print "\t-No DSN available\n"; TO: @dsns = DBI-data_sources($driver) or print "\t-No DSN available\n"; -Original Message- From: Juan Antonio Celaya Guzman [mailto:[EMAIL PROTECTED]] Sent: Monday, April 09, 2001 1:36 PM Subject: MSAccess DB Problem I have a problem trying to get my perl script working. I remember when I installed the Activestate implementation I did a test for DB Accessing and it worked fine but then I change to another implementation which one comes with an Apache Web Server so I decided to switch -I am talking about Indigostar -, the server worked fine, the cgis worked fine but when DB Accessing comes I can not figured out what is going on. I am using the DBI interface provided with the implementation please see the script below. #!perl -w use DBI; use CGI; # EXPLICIT VARIABLE DECLARE FOLLOWS my @drivers; my $driver; my @dsns; my $dsn; my $q; $q = new CGI; print $q-header; print $q-start_html("Conectividad"); @drivers = DBI-available_drivers; print "\n\n"; foreach $driver (@drivers){ print "$driver\n"; @dsns = DBI-data_sources($drivers[0]) or print "\t-No DSN available\n"; foreach $dsn (@dsns){ print "\t-$dsn\n"; }; }; print "\nAplicacion de acceso a la Base de Datos de Conectividad"; print $q-end_html; there is nothing fancy just trying to see what DSN do I have access, well it happens I setup a DSN previously called Test which one is pointing to my Access DB, but whenever I run the script I got the following: Content-Type: text/html !DOCTYPE HTML PUBLIC "-//IETF//DTD HTML//EN" HTMLHEADTITLEConectividad/TITLE /HEADBODY ADO -No DSN available ExampleP -No DSN available Proxy -No DSN available mysql -No DSN available Aplicacion de acceso a la Base de Datos de Conectividad/BODY/HTML Sorry I a sent you such a huge email, I am not even registered in your email List, but I want you to have the whole picture. Could you please register me, My name is Juan Antonio Celaya, I am from Mexico.
RE: MSAccess DB Problem
Hi Phil, When I used [0] I was trying to refer to the ADO DSNs but it doesnt matter really, by changing this sentence I will get the DSNs for every Driver Installed, see what I got replacing the sentence. Content-Type: text/html !DOCTYPE HTML PUBLIC "-//IETF//DTD HTML//EN" HTMLHEADTITLEConectividad/TITLE /HEADBODY ADO -No DSN available ExampleP -dbi:ExampleP:dir=. Proxy install_driver(Proxy) failed: Cant Locate RPC/PlClient.pm in @INC (@INC Contains: C:/Apache/lib C:/Apache/site/lib .) at C:/Apache/site/lib/DBD/Proxy.pm line 28. BEGIN failed -- Complitaion aborted at C: I think the problem is I am not getting the ODBC driver, It should appears OBCD and then under it my DSN Test no?? I am not really sure what the problem is any idea??
Binding to Output Parameters using DBD::ODBC
I am using DBD::ODBC drivers to connect to a Sybase 11.5 database. I have migrated a bunch of procedures from Oracle 8i that use output parameters to return data. I was migrating an abstract database interface that I built dbObject.pm, which previously called the Oracle stored procedures. I verified that the ODBC prepare statement was being correctly built {call get_seq(?,?,?)} and when I called DBI::bind_param_inout on the 3rd output parameter I got the error message "Can't bind output values (currently)". Now I know I am not the only one who has ever tried this so can someone please tell me how to bind Perl variables to stored procedure's output parameters using DBD::ODBC. Thanks, Bruce ``` (o o) --oOO--(_)--OOo Bruce HodgeDynaScript Internet Language P.O. Box 428 http://www.dynascript.com Greenfield, NY 12833 [EMAIL PROTECTED] -o00-00o---
Re: Most common anything in a database --
On Fri, Apr 06, 2001 at 08:26:28PM -0400, Sean Cooper wrote: Hello all -- I'm sorry if this is off topic, but does anybody know of a way to find the most common entry in a database using an SQL query? I'm using MySQL to cache search engine terms and want to find the 5 most common terms I can do it in perl pretty easily using a hash to store the counts of each value, but don't want to do it that way unless there is no way to do it in SQL. Here's how I would accomplish this: SELECT term, count(*) FROM search_terms GROUP BY term ORDER BY count(*) And the first five rows returned would contain the five most common terms. Ronald
Re: DBI 1.15 subclassing bug!
Tim Bunce [EMAIL PROTECTED] wrote: On Fri, Apr 06, 2001 at 05:11:38PM -0400, Phil R Lawrence wrote: Uncaught exception from user code: DBI-disconnect is not a DBI method... I wouldn't want to call you a beginner, but somewhere, for some reason, you're executing DBI-disconnect or $foo-disconnect where $foo contains DBI. You were kind to not call me a beginner! Nonetheless, the issue was a screwed up @ISA ordering. See below for the bug. I'm glad you added the code to make DBI-disconnect blow up in DBI 1.15. I learned a bit more about inheritance as a result. Thanks, Phil R Lawrence package STORIT; use SUBCLASS_DBI; use vars qw( @ISA ); @ISA = qw ( SUBCLASS_DBI ); sub new { my $proto = shift; my $class = ref($proto) || $proto; my $s = $class-test_connect or die; return $s; } #== package STORIT::db; use vars qw( @ISA ); @ISA = qw( STORIT SUBCLASS_DBI::db ); # ^^ # this caused disconnect invocation to be first looked # for as a DBI method (due to STORIT's @ISA) instead # of as a SUBCLASS_DBI::db method (which would have # correctly resolved as a DBI::db method). #== package STORIT::st; use vars qw( @ISA ); @ISA = qw(SUBCLASS_DBI::st);