RE: Which SQLite DBD To Use
-Original Message- From: Peter J. Holzer [mailto:h...@wsr.ac.at] On 2010-03-16 17:14:32 -0500, Will Rutherdale (rutherw) wrote: I am about to ask someone to install DBI and DBD-SQLite on a platform. I noticed there are a number of related repos on CPAN: DBD-SQLite, DBD-SQLite2, DBD-SQLite-Amalgamation. Is DBD-SQLite the right one to get? Yes. Thanks for the info. Also, the DBD-SQLite package has a funny description: Self-contained RDBMS in a DBI Driver. This doesn't mean that DBD-SQLite re-implements all of SQLite, does it? No. It doesn't reimplement it, it just bundles it. Or does it just mean that it is the Driver for the Self-contained RDBMS of SQLite? No. The drivers includes an SQLite version and will ignore any other version which may already be installed on the system. Interesting. In embedded systems there is often a lot of fighting over flash space, and if people are using SQLite then it has already been installed somewhere. Is there any way to get the driver to use the existing SQLite and to avoid the cost of installing the extra one that comes with DBD-SQLite? -Will
RE: Which SQLite DBD To Use
-Original Message- From: David Nicol [mailto:davidni...@gmail.com] amalgamation includes the optional Full Text Search Engine module, which is extremely cool if you need it. Thanks, I'll keep that in mind. -Will
Problem in Install 'DBD-Oracle' version 1.17 in ActivePerl 5.8.6.811.
Hello I was trying to install DBD-Oracle today. I installed DBI successfully. But when I tried to install DBD-Oracle through PPM, it is giving error. I am just copy pasting the entire install log below. Install 'DBD-Oracle' version 1.17 in ActivePerl 5.8.6.811. Transferring data: 25900886/30817722 bytes. Read error on tarfile (missing dat a) 'oracle-instant-client/MSWin32-x86-multi-thread/oraociei10.dll' at offset unknown at C:/Perl/site /lib/PPM/Archive/Tar.pm line 25 Extracting 39/39: oracle-instant-client/MSWin32-x86-multi-thread/oci.dll Installing C:\Perl\site\lib\auto\DBD\Oracle\dbdimp.h Installing C:\Perl\site\lib\auto\DBD\Oracle\mk.pm Installing C:\Perl\site\lib\auto\DBD\Oracle\Oracle.h Installing C:\Perl\site\lib\auto\DBD\Oracle\Oracle.bs Installing C:\Perl\site\lib\auto\DBD\Oracle\ocitrace.h Installing C:\Perl\site\lib\auto\DBD\Oracle\Oracle.dll Installing C:\Perl\site\lib\auto\DBD\Oracle\Oracle.exp Installing C:\Perl\site\lib\auto\DBD\Oracle\Oracle.lib Installing C:\Perl\site\lib\auto\DBD\Oracle\Oracle.pdb Files found in blib\arch: installing files in blib\lib into architecture dependent library tree Installing C:\Perl\site\lib\Oraperl.pm Installing C:\Perl\site\lib\oraperl.ph Installing C:\Perl\site\lib\DBD\Oracle.pm Installing C:\Perl\site\lib\DBD\Oracle\GetInfo.pm Installing C:\Perl\bin\ora_explain.bat Installing C:\Perl\bin\ora_explain Found local libraries Oracle url = file:///C:\DOCUME~1\mithun\LOCALS~1\Temp\DBD-Oracle-1-3936-1268850904\oracle-instant-cl ient/MSWin32-x86-multi-thread ORACLE TECHNOLOGY NETWORK DEVELOPMENT AND DISTRIBUTION LICENSE AGREEMENT We, us, and our refers to Oracle USA, Inc. You and your refers to the individual or entit y that wishes to use the Programs from Oracle under this Agreement. Programs refers to the Softwa re Products referenced below that you wish to download and use and Program documentation. License refers to your right to use the Programs and Program documentation under the terms of this Agreemen t. The substantive and procedural laws of California govern this Agreement. You and Oracle agree t o submit to the exclusive jurisdiction of, and venue in, the courts of San Francisco, San Mateo, or Santa Clara counties in California in any dispute arising out of or relating to this Agreement. We are willing to license the Programs to you only upon the condition that you accept all of the ter ms contained in this Agreement. Read the terms carefully and select the Accept button at the bott om of the page to confirm your acceptance. If you are not willing to be bound by these terms, selec t the Do Not Accept button and the registration process will not continue. Software Product - Instant Client License Rights License. We grant you a non-exclusive right and license to use the Programs solely for your business purposes and development and testing purposes, subject to the terms of this Agreement. You may allow third parties to use the Programs, subject to the terms of this Agreement, provided such third party use i s for your business operations only. Distribution License We grant you a non-exclusive right and license to distribute the Programs, provided that you do not charge your end users for use of the Programs. Your distribution of such Programs shall at a minimu m include the following terms in an executed license agreement between you and the end user that: (1 ) restrict the use of the Programs to the business operations of the end user; (2) prohibit (a) the end user from assigning, giving, or transferring the Programs or an interest in them to another indi vidual or entity (and if your end user grants a security interest in the Programs, the secured party has no right to use or transfer the Programs); (b) make the Programs available in any manner to any third party for use in the third party's business operations (unless such access is expressly permi tted for the specific program license or materials from the services you have acquired); and (c) tit le to the Programs from passing to the end user or any other party; (3) prohibit the reverse enginee ring (unless required by law for interoperability), disassembly or decompilation of the Programs and prohibit duplication of the Programs except for a sufficient number of copies of each Program for t he end user's licensed use and one copy of each Program media; (4) disclaim, to the extent permitted by applicable law, our liability for any damages, whether direct, indirect, incidental, or conseque ntial, arising from the use of the Programs; (5) require the end user at the termination of the Agre ement, to discontinue use and destroy or return to you all copies of the Programs and documentation; (6) prohibit publication of any results of benchmark tests run on the Programs; (7) require the end user to comply fully with all relevant export laws and regulations of the United States and other a pplicable export and import
RE: Which SQLite DBD To Use
-Original Message- From: Peter J. Holzer [mailto:h...@wsr.ac.at] Is there any way to get the driver to use the existing SQLite and to avoid the cost of installing the extra one that comes with DBD-SQLite? Almost certainly yes. Thanks for the help. -Will
DBD::DB2 1.78 with strawberry perl ... some success
Hi, I am was having problem with compiling DBD::DB2 on strawberry perl. After some fussing about I realized that the build statement was not made correctly ( it was not linking the db2cli.lib and db2api.lib in dmake). So I manually ran that command and got it to work. However now when I do dmake test I get errors saying it cannot load DB2.dll even when it is located there. Here is the entire build log. http://paste.scsys.co.uk/40859 Error on load is: load_file:Attempt to access invalid address at ...Dynaloader.pm line 200 Thank you, kthakore
Getting IBM's DB2 Perl interface to work with Windows 7
Hi, I'm trying to load IBM's DB2 Perl Database Interface for LUW on my brand new Dell desktop running Windows 7 Professional and ActiveState Perl but despite the easy instructions at http://www-01.ibm.com/support/docview.wss?rs=71uid=swg21297335 every time I run the command ppm install http://cpan.uwinnipeg.ca/PPMPackages/10xx/DBD-DB2.ppd; I get an error message saying ppm install failed: The PPD does not provide code to install for this platform which clearly isn't good. Does anyone have any idea if Windows 7 is supported by IBM's interface? I'd hate to find out my new O.S. isn't going to support my work... Thanks, Bob
Re: Which SQLite DBD To Use
Will Rutherdale (rutherw) wrote: -Original Message- From: Peter J. Holzer [mailto:h...@wsr.ac.at] On 2010-03-16 17:14:32 -0500, Will Rutherdale (rutherw) wrote: Is DBD-SQLite the right one to get? Yes. No. The drivers includes an SQLite version and will ignore any other version which may already be installed on the system. Interesting. In embedded systems there is often a lot of fighting over flash space, and if people are using SQLite then it has already been installed somewhere. Is there any way to get the driver to use the existing SQLite and to avoid the cost of installing the extra one that comes with DBD-SQLite? Yes, you can. Look at the source of the Makefile.PL, http://cpansearch.perl.org/src/ADAMK/DBD-SQLite-1.30_01/Makefile.PL , for information on how to do that. The ability to use a system-installed SQLite is present, but disabled by default for casual users, because you could be more likely to run into problems due to potential version incompatibilities and so forth or other build system complexities. You enable it by setting the USE_LOCAL_SQLITE and optionally the SQLITE_LOCATION environment variables. Moreover, you have to change the indicated if(0) to if(1) in the Makefile.PL. -- Darren Duncan
Perl 5.6.1 supports DBI module
Hello All I am working on Perl 5.6.1 version for my web application. I want to know whether perl5.6.1 supports the DBI module or not, if it supports the what is the version of DBI module. Please let me know the answers. Thanks in advance. Regards Sudhakara Reddy Peram Desk: +91 - 40 - 30674037 Mobile: +91 - 9618909018
Re: Perl 5.6.1 supports DBI module
On Thu, Mar 18, 2010 at 8:32 AM, Peram, Sudhakara sudhakara.pe...@pfizer.com wrote: I am working on Perl 5.6.1 version for my web application. Why? Why not 5.6.2, 5.8.8 or 5.8.9, or even (bravado) 5.10.1? I want to know whether perl5.6.1 supports the DBI module or not, if it supports the what is the version of DBI module. If you choose an old enough version of DBI, then yes. You might have to go to the BackPan though, instead of CPAN. Hmm; 1.49 dropped support for 5.6.0 (only supporting 5.6.1 or later). Up to 1.609, I can see no mention of not supporting 5.6.1. So, DBI 1.609 should work for you. -- Jonathan Leffler jonathan.leff...@gmail.com #include disclaimer.h Guardian of DBD::Informix - v2008.0513 - http://dbi.perl.org Blessed are we who can laugh at ourselves, for we shall never cease to be amused.
Re: Perl 5.6.1 supports DBI module
Hi, DBI-1.605 was the last version not to require perl 5.8. Even though the Readme doesn't state it, version 1.606 and newer requires 5.8.10 in the Makefile.PL and will not let you create a makefile without some editing of the Makefile.PL to ignore that requirement. Regards, Michael On Thu, 18 Mar 2010, Peram, Sudhakara wrote: Date: Thu, 18 Mar 2010 23:32:26 +0800 From: Peram, Sudhakara sudhakara.pe...@pfizer.com To: dbi-users@perl.org Subject: Perl 5.6.1 supports DBI module Hello All I am working on Perl 5.6.1 version for my web application. I want to know whether perl5.6.1 supports the DBI module or not, if it supports the what is the version of DBI module. Please let me know the answers. Thanks in advance. Regards Sudhakara Reddy Peram Desk: +91 - 40 - 30674037 Mobile: +91 - 9618909018 -- ---//--- Time flies like the wind. Fruit flies like bananas. --- Groucho Marx Either write something worth reading or do something worth writing. --- Benjamin Franklin A meeting is an event at which the minutes are kept and the hours are lost