Search Discussions

169 discussions - 495 posts

  • Anyone using perl 5.8.0? Jarkko and I would be interested in any feedback you may have. Obviously my main interest is with DBI and drivers but Jarkko's is wider. Please reply to Jarkko (CC'd) and ...
    Tim BunceTim Bunce
    Feb 25, 2003 at 12:51 pm
    Mar 26, 2003 at 12:05 am
  • I have a number of perl scripts used under Windows that I am trying to port to a Redhat 8 Linux machine. All my scripts use DBI.pm and DBD::ODBC to connect to an MS SQL Server database. I have seen ...
    Russell KrobothRussell Kroboth
    Feb 24, 2003 at 5:27 pm
    Feb 25, 2003 at 11:35 pm
  • Hello I am working with Perl CGi. There is a query where i have to select all columns in a table and display the data on the web page. the query is something like "select * from <tablename But the ...
    Manisha GuptaManisha Gupta
    Feb 18, 2003 at 10:57 pm
    Feb 21, 2003 at 3:58 pm
  • Hello, I have some (jpeg) blobs in oracle. table looks like this: asset_id height width preview varchar2 varchar2 varchar2 blob Ihave the programming DBI book here, but it does not cover this very ...
    Scott PurcellScott Purcell
    Feb 17, 2003 at 8:42 pm
    Feb 24, 2003 at 7:20 pm
  • Hi, I'm trying to install DBI 1.32 on my Jaguar system (10.2.3). I have Perl 5.8.0 installed with threading enabled... this is an upgrade from the stock Perl 5.6.0 that was on there. The installation ...
    Feb 6, 2003 at 4:39 pm
    Feb 15, 2003 at 8:49 pm
  • hi i ask myself how to prog my select statments platform independend if i need ISNULL function on varchar fields in MsSQL2K... this will not work on a move to MySQL and so on... another problem is ...
    Feb 2, 2003 at 12:18 pm
    Feb 4, 2003 at 6:03 pm
  • There is the need at my organization to process DDL statements contained in a group of SQL files. I would like to know what the known limitations are concerning this, specifically: I am running perl ...
    Fernando LunaFernando Luna
    Feb 26, 2003 at 9:15 pm
    Feb 27, 2003 at 6:16 pm
  • DBI-Users, The DBI prepare statement documentation http://search.cpan.org/author/TIMB/DBI-1.32/DBI.pm#prepare says prepare "Prepares a single statement for later execution by the database engine" The ...
    Colin WoodfordColin Woodford
    Feb 7, 2003 at 10:45 am
    Feb 11, 2003 at 6:17 pm
  • I recently upgraded the OS on my SGI (UNIX) system and after word my web database connection tells me that it cannot find the DBI or the DBD modules. Everything worked fine before the upgrade and the ...
    Chamlee, Douglas, B. (Contractor)Chamlee, Douglas, B. (Contractor)
    Feb 4, 2003 at 4:37 pm
    Feb 5, 2003 at 3:25 am
  • Can someone tell me the necessary modules needed to access a MySQl database using DBD/DBI? Looking in CPAN my guess is from what I find there is: DBI-1.32.tar.gz DBD-mysql-2.1020.tar.gz ...
    Barone, PhilipBarone, Philip
    Feb 7, 2003 at 5:10 pm
    Feb 7, 2003 at 5:26 pm
  • Hi Folks, I've encountered an error when configuring some open-source software (Bugzilla) that has asked me to "build a new perl executable which either supports dynamic loading or has the DBI module ...
    Chris BucchereChris Bucchere
    Feb 28, 2003 at 2:20 pm
    Feb 28, 2003 at 4:27 pm
  • Does enyone have a reasonably working implementation of column_info() for mysql? Tim.
    Tim BunceTim Bunce
    Feb 20, 2003 at 6:58 pm
    Feb 25, 2003 at 9:23 am
  • Since David is too busy to work on DBD::Pg right now, I have ported the changes that I made against 1.13 to CVS HEAD from gborg.postgresql.org. The patch can be found here: ...
    Rudy LippanRudy Lippan
    Feb 12, 2003 at 3:50 am
    Feb 13, 2003 at 3:54 am
  • Up until now I have only used DBI for generic SQL and never had a problem I am having problems trying to access a function within Oracle via DBI / DBD::Oracle The function in question is called ...
    David BakkersDavid Bakkers
    Feb 4, 2003 at 10:10 pm
    Feb 9, 2003 at 8:05 pm
  • I am developing a registration area for a members site that will interface with a MySQL DB users table, and I ran into a problem. Note that I am using DBI as my DB Driver. Suppose the user tries to ...
    Feb 7, 2003 at 7:00 pm
    Feb 7, 2003 at 7:28 pm
  • The uploaded file DBI-1.33.tar.gz has entered CPAN as file: $CPAN/authors/id/T/TI/TIMB/DBI-1.33.tar.gz size: 299066 bytes md5: c6a737c990bc59f95c34657ec72ac68a No action is required on your part ...
    Feb 27, 2003 at 12:25 am
    Feb 27, 2003 at 9:44 am
  • We had some fun connecting to SQL Server from linux via DBD::Proxy a while back... Initially, we had problems with the PlRPC package; under Win32 "\n" gets written as 0x0a,0x0d to the socket. Fixing ...
    Feb 18, 2003 at 11:00 am
    Feb 25, 2003 at 11:46 am
  • I'll investigate and let you know. That is incorrect. The undelimited table name Collection matches an undelimited table of that name in any case (e.g. COLLECTION, collection, Collection). And ...
    Jeff ZuckerJeff Zucker
    Feb 20, 2003 at 8:47 pm
    Feb 21, 2003 at 6:59 pm
  • this seems to have changed since i installed DBI 1.32 (i upgraded from 1.30), and is breaking some scripts which assume that it will always return a hash. sometimes (when the query returns no rows), ...
    Craig SandersCraig Sanders
    Feb 14, 2003 at 2:18 am
    Feb 16, 2003 at 12:55 am
  • Hi, I have loaded perl 5.8.0/DBD-Sybase .91, .95/freetds .60 and it works properly except if I use it under apache (1.3.27)--which is where I need it most. The errors I receive are (1) seg fault, (2) ...
    Gordon RossGordon Ross
    Feb 26, 2003 at 12:26 am
    Feb 26, 2003 at 11:45 pm
  • I am trying to read email off a mail server using perl, parse it, and then store the fields in a MySQL database. I managed to write the first two parts in a couple of days, but now I've spent two ...
    Feb 26, 2003 at 5:10 pm
    Feb 26, 2003 at 7:26 pm
  • Hi, Can anyone tell me some of the Perl packages used for Encrypting or Decrypting some data mostly strings using some Public and Private key like RSA. Please suggest some.I want to encrypt/decrypt ...
    Nilanjan DasNilanjan Das
    Feb 25, 2003 at 2:47 pm
    Feb 26, 2003 at 6:48 pm
  • Hi! When I destroy my objects I would like to know if there are uncommitted transactions. There shouldn't be any but I would like to know. Given only a DBI database handle, is it possible to find out ...
    Roger PerttuRoger Perttu
    Feb 13, 2003 at 9:10 am
    Feb 15, 2003 at 12:58 pm
  • perl 5.6.1 With use warnings, dependant upon the query I execute, I will recive the following: Use of uninitialized value in join or string..... I see this when I am selecting against v$ views and ...
    Markham, RichardMarkham, Richard
    Feb 14, 2003 at 6:32 pm
    Feb 14, 2003 at 7:01 pm
  • This is probably more of an oracle problem than DBI problem but I'm getting desperate. I can connect from any machine thats in the same domain as my server but not from any machine outside that ...
    Morrison DavisMorrison Davis
    Feb 13, 2003 at 2:36 pm
    Feb 14, 2003 at 3:43 pm
  • how to use DBD::ODBC to connect sql server on nt machine do i have to install odbc-odbc bridge on client and server or is any simplest way to connect mssql via tcp ? greg
    Feb 4, 2003 at 3:05 pm
    Feb 4, 2003 at 7:18 pm
  • Tim, There's probably a deeper timing issue on these that's causing the issues, but I thought I'd let you know: 1) The following fails on my machine: t/40profile.t line 93 ok($total $longest); In ...
    Jeff UrlwinJeff Urlwin
    Feb 27, 2003 at 4:10 pm
    Feb 28, 2003 at 9:38 am
  • Here's the 'make test' failures, I'm seeing when running 'make test' on the DBD::Sybase 0.95. Don't see them in 0.94. Maybe our faithful CPAN contributor can make heads or tails of it. Note the ...
    Karyn UlriksenKaryn Ulriksen
    Feb 26, 2003 at 12:50 am
    Feb 27, 2003 at 5:14 pm
  • Good morning. I'm having an issue with attempting to specify the AutoCommit option on a Connect to any Oracle database. Here is an example of my Connect statement: <begin $dbh = DBI- ...
    Feb 27, 2003 at 1:47 pm
    Feb 27, 2003 at 4:41 pm
  • Howdy! I'm trying to write a WARN handler for an Informix application. I want to be able to get to stuff in the SQLCA, which, if I read things correctly, means I need the statement handle for the ...
    Michael HoughtonMichael Houghton
    Feb 25, 2003 at 8:15 pm
    Feb 26, 2003 at 1:46 pm
  • Hello Tim Bunce, I cannot install the DBD module in my HP UX 11.00 box, as I can't understand the instuctions in the README.hpux file, no idea what do when I got stuck up with the following error ...
    Feb 22, 2003 at 12:20 pm
    Feb 24, 2003 at 3:20 pm
  • So the recent discussion on column_info in DBD::Pg had me delving into the code to see if foreign_key_info had been implemented but undocumented. Turns out it has not, at least in the latest release ...
    Keith KellerKeith Keller
    Feb 21, 2003 at 10:44 pm
    Feb 22, 2003 at 11:11 pm
  • Hi I am working on a perl script that runs a sql which extracts all data from a view and prints them on a web page. But the problem is I am not able to print the field names as headings of the ...
    Ms manisha guptaMs manisha gupta
    Feb 20, 2003 at 8:50 pm
    Feb 21, 2003 at 3:46 pm
  • Folks Is there a Postgres DBI/DBD::Pg call which will retrieve the column attributes the way "show columns from $table" does under MySQL? -- Cheers Ron Savage, ron@savage.net.au on 19/02/2003 ...
    Ron SavageRon Savage
    Feb 19, 2003 at 8:17 pm
    Feb 20, 2003 at 4:52 pm
  • Recently we upgraded to Oracle 9i and the DBD::Oracle-1.12 does not seem to work anymore. The CPAN documentation says, it was for Oracle 7 and 8. We've Oracle 9.2.0 Please help ?!!! regards surjit ...
    Surit SahooSurit Sahoo
    Feb 6, 2003 at 5:36 pm
    Feb 18, 2003 at 6:21 pm
  • Hi, I need a bit of a help with DBI/DBD combo. I have tried to narrow it down and came up with the following. Here is the problem summary: Versions: Perl: 5.6.1 DBI: 1.32 DBD-Oracle: 1.12 Operating ...
    Srdjan NikolicSrdjan Nikolic
    Feb 15, 2003 at 5:59 am
    Feb 17, 2003 at 1:27 am
  • Dear all i am having a problem with SQL-Statement-1.005, whereas SQL-Statement-0.1020 is working fine. SQL ERROR: Mismatched parentheses in WHERE clause! SV = RV(0x810cad0) at 0x829105c REFCNT = 1 ...
    Walter B. TakensWalter B. Takens
    Feb 14, 2003 at 10:24 am
    Feb 14, 2003 at 7:32 pm
  • Hi, I have a script which runs in non-stop in the background on a HPUX system. It checks various table in my database and updates some rows when needed. It connects to the database (Oracle ...
    Frans PostmaFrans Postma
    Feb 10, 2003 at 4:01 pm
    Feb 14, 2003 at 3:41 pm
  • I think the issue is that I need to use gcc instead of cc. But I don't know how to change the Makefile.PL to configure this... Any direction is appreciated... # perl Makefile.PL *** Note: The ...
    Dave JamesDave James
    Feb 11, 2003 at 11:34 pm
    Feb 13, 2003 at 5:23 pm
  • I am using CSV under DBI. A select statement with "group by" always gives me error: ex: "SELECT AVG(id), MIN(id), MAX(id) FROM $table WHERE NOT (id IS NULL) GROUP BY name" SQL ERROR: Bad table or ...
    Ming LeiMing Lei
    Feb 12, 2003 at 3:29 am
    Feb 12, 2003 at 6:53 pm
  • Hello, I am having a small problem with inserting a date into a table. I'm working on an accounting app, and I have to insert the due date into a table, which is 30 days in the future. I try the ...
    JT MacNeilJT MacNeil
    Feb 11, 2003 at 10:58 pm
    Feb 12, 2003 at 3:06 pm
  • ----- Forwarded message from Thomas Good <tomg@sqlclinic.net ----- Delivered-To: tim.bunce@pobox.com X-Authentication-Warning: q8.nrnet.org: tomg owned process doing -bs Date: Tue, 11 Feb 2003 ...
    Tim BunceTim Bunce
    Feb 11, 2003 at 4:46 pm
    Feb 12, 2003 at 8:26 am
  • KdamundsonKdamundson
    Feb 11, 2003 at 3:30 pm
    Feb 12, 2003 at 2:27 am
  • Hi, I've recently been 'bitten' by the placeholder feature in selects. While I certainly appreciate that placeholders are a good way of reducing the workload for large selects, etc., what I'm ...
    Preston de GuisePreston de Guise
    Feb 10, 2003 at 10:07 pm
    Feb 11, 2003 at 2:05 pm
  • I am new to this environment.... I don't know how to establish connection to SQL Server from Linux machine using Perl.... Pls help me in this issue.... Expecting your favourable answers.... Thanx in ...
    Feb 8, 2003 at 11:58 am
    Feb 9, 2003 at 1:14 pm
  • Hi All, I have installed MySql database on a RedHat 8.0 Database, I am trying to access the records in a table using the perl script, which is as below: #! /usr/bin/perl use DBI; my $dsn = ...
    Feb 27, 2003 at 2:46 pm
    Mar 3, 2003 at 7:12 am
  • This distribution has been tested as part of the cpan-testers effort to test as many new uploads to CPAN as possible. See http://testers.cpan.org/ Please cc any replies to cpan-testers@perl.org to ...
    Feb 28, 2003 at 8:10 am
    Feb 28, 2003 at 12:12 pm
  • Tim, I hate to say this, but, DBD::Oracle (here) doesn't work with DBI 1.33... Dbd_discon_all needs to be defined. Jeff
    Jeff UrlwinJeff Urlwin
    Feb 27, 2003 at 10:02 pm
    Feb 28, 2003 at 12:09 pm
  • Hi, I've been trying to get DBD::ODBC to work on a Mac OS 10.2 machine using MyODBC/iODBC. For now I just want it to connect to the MySQL server running on localhost - eventually I need it to connect ...
    Chris HinrichsChris Hinrichs
    Feb 27, 2003 at 6:04 pm
    Feb 27, 2003 at 7:51 pm
  • Hello dbi-users, I'm trying to install dbd::odbc v1.04 with perl v5.8.0, dbi v1.32, unixODBC v2.2.4, and Easysoft OOB v1.1.0.0 Platforms are MS W2K (SQL 2000) on the server side of the bridge, and ...
    Jonathan Hall [Dial]Jonathan Hall [Dial]
    Feb 27, 2003 at 4:20 pm
    Feb 27, 2003 at 7:20 pm
Group Navigation
period‹ prev | Feb 2003 | next ›
Group Overview
groupdbi-users @

198 users for February 2003

Tim Bunce: 39 posts Frans Postma: 16 posts Jeff Urlwin: 15 posts Jonathan Leffler: 15 posts Ron Savage: 13 posts Dave K: 11 posts Jeff Zucker: 11 posts Dan Muey: 10 posts Michael Peppler: 10 posts Ian Harisay: 8 posts Jared Still: 8 posts Alex: 7 posts Karyn Ulriksen: 7 posts Rudy Lippan: 7 posts Russell Kroboth: 7 posts Scott T. Hildreth: 7 posts David Wheeler: 6 posts Steve Haslam: 6 posts Curt Russell Crandall: 5 posts Fernando Luna: 5 posts
show more