-Original Message-
From: Jeff Urlwin [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 23, 2001 6:27 AM
To: Neil Lunn; 'Timothy C. Phan'; [EMAIL PROTECTED]
Subject: RE: [Patch] RE: DBD-ODBC 0.28 for Cygwin
Neil,
To confirm: you don't need the readme.cygwin anymore?
That should
Terry,
I am going to answer your question in the braod strokes rather than in the
context of you message as this seems to have a need to be said.
There seems to be a gross misunderstanding in the community in general of
what exactly ODBC and therefore DBD::ODBC is.
Questions like this
-Original Message-
From: NYIMI Jose (BMB) [mailto:[EMAIL PROTECTED]]
Sent: Saturday, August 18, 2001 1:02 AM
To: '[EMAIL PROTECTED]'
Subject: Remote DB Connection
How I can connect to a remote Informix database ?
The database from which I would like to extract
data (a simple SQL
Allen,
It might help if you told people which version of perl you were using and
for which platform.
It seems like you statements though at least say something. You should never
run test.pl.
What you should be doing is:
perl Makefile.PL
make
make test
make install
as per the standard perl
of your database connection.
--Neil
Regards
CCJ
- Original Message -
From: Neil Lunn [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, August 17, 2001 3:25 PM
Subject: RE: Wildcards
-Original Message-
From: Clinton [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 17, 2001 3:11
That's the fourth time. Enough is enough. Stop posting this. Someone will
answer [maybe] in their own time.
Perhaps you may think that prodding a tiger with a stick is also a wise
thing to do?
--Neil
-Original Message-
From: Falk [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 16,
-Original Message-
From: gopinath r [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 15, 2001 4:52 PM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Database connection
Hello
I have some doubts about connecting oracle 8.4
database from perl 5
I installed Indigoperl(perl 5) in
-Original Message-
From: Jon Barker [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 14, 2001 8:28 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: SQL Statement - Selecting details if they exist if not...
I'm not completely sure I understand you but:-
select * from Jobs
-Original Message-
From: Bart Lateur [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 14, 2001 8:30 PM
To: [EMAIL PROTECTED]
Subject: Re: Removing duplicate records - OT
On Tue, 14 Aug 2001 11:12:23 +1000, Neil Lunn wrote:
Use something like this as the record source for items
While I can read that the person who posted this message has solved their
issue, this might be worthwhile still.
One thing I notice is that all responses are processing very record to see
if a duplicate record is there. Hopefully though the database server is a
little more powerful than the
-Original Message-
From: Falk [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 10, 2001 6:15 PM
To: [EMAIL PROTECTED]
Subject: ActivePerl DBI Setup
Hi,
I'm using Active Perl on WinNT.
I tried to setup the DBI Module - so far without success. I tried make,
nmake, ppm.
None of them works.
-Original Message-
From: Tim Bunce [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 08, 2001 8:58 PM
To: Neil Lunn
Cc: 'Timothy C. Phan'; [EMAIL PROTECTED]; Jeff Urlwin
Subject: Re: [Patch] RE: DBD-ODBC 0.28 for Cygwin
Can't the (intended) error be silenced by the test script?
Sorry
-Original Message-
From: Veeresh [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 09, 2001 2:36 PM
To: [EMAIL PROTECTED]
Subject: Can't locate DBD/Oracle.pm
Hi All,
I'm using the Oracle 8.1.6 version. I was trying to run the
Perl script i got this error.
install_driver(Oracle)
Hmm. Not really a DBI question but I feel charitable. Beside this might stop
people asking in the future. See the code below.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 08, 2001 12:50 PM
To: [EMAIL PROTECTED]
Subject: Exporting Data
-Original Message-
From: Veeresh [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 08, 2001 2:07 AM
To: [EMAIL PROTECTED]
Subject: Can't locate loadable object for module DBI
Then I installed the DBI.pm as per instructions in the
website.The following
is the result
Can't locate
-Original Message-
From: Timothy C. Phan [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 07, 2001 6:20 AM
To: [EMAIL PROTECTED]
Subject: RE: DBD-ODBC 0.28 for Cygwin
Hi,
I'm actually using ActiveState Perl for a couple of years now.
I, however, wanted to try diff version
-Original Message-
From: Jonathan Leffler [mailto:[EMAIL PROTECTED]]
Neil Lunn wrote:
It's off by defualt. But the documentation should help more here.
Are you sure? I think you'll find it is on by default,
because that's the only
mode that all databases, even databases without
Yes. While the soolution below is correct it might help to tell the person
who oringally posted this question why they where getting an error.
The difference is in:
$sth = $dbh-do(insert
$sth-bind_param( ...
and
$sth = $dbh-prepare(insert
$sth-bind_param( ...
Essentially the
If I use something like:
my $data= $sth-fetchall_arrayref;
foreach (@$data){
print qq(@$_BR);
}
I get all the data, but how the hell do I access the specific
elements in
this array of arrays? Is there a better fetch method to use?
my $data = $sth-fetchall_arrayref;
# Print Each
Use ppm for ActiveState perl.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 31, 2001 3:34 PM
To: [EMAIL PROTECTED]
Subject: DBI on Win2k
Hi all,
I have installed ActivePerl on windows 2000 and want to
install and configure DBI module.
Then use a dsnless connection. Look at perldoc DBD::ODBC for the examples
(connecting to Access) that are already listed.
--Neil
-Original Message-
From: Michael Blackmore [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 30, 2001 10:51 AM
To: [EMAIL PROTECTED]
Subject: DBI::ODBC
Check your installation. It is definately there.
--Neil
-Original Message-
From: Alex Algard [mailto:[EMAIL PROTECTED]]
Sent: Saturday, July 14, 2001 9:16 AM
To: [EMAIL PROTECTED]
Subject: fetchall_hashref() - does/will it exist?
I just downloaded DBI 1.18, and although the
Looks like your make is broken. Get an update from your nearest mirror under
/pub/gnu
-Neil
-Original Message-
From: ARCS (Wade) [mailto:[EMAIL PROTECTED]]
Sent: Friday, July 13, 2001 4:22 PM
To: [EMAIL PROTECTED]
Subject: Problems installing DBI 1.14 on SunOS 5.6 (Solaris 2.6)
Hello,
-Original Message-
From: Farouk Khawaja [mailto:[EMAIL PROTECTED]]
Sent: Friday, July 13, 2001 7:09 AM
To: Sterin, Ilya; '[EMAIL PROTECTED] '
Subject: RE: Compile problems with DBD::ODBC
also, opt/odbc/lib is defined in LD_LIBRARY_PATH
Looks like the wrong driver manager. This should
You will do better to post an example of your script, the actual error
message(s) received, and the output of perl -V, as is suggested in the
documentation.
You are running your script with -w aren't you!
--Neil
-Original Message-
From: anshuman das [mailto:[EMAIL PROTECTED]]
Sent:
Old Perl in your path!
/bin/perl -I/usr/perl5/5.00503/sun4-solaris -I/usr/perl5/5.00503
^^^
-Original Message-
From: Deng Ruijie [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 02, 2001 4:23 PM
To: [EMAIL PROTECTED]
Subject: compiling error
Hi everybody,
Can
-Original Message-
From: Deng Ruijie [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 02, 2001 6:26 PM
To: [EMAIL PROTECTED]
Subject: RE: compiling error
Hi Neil Lunn,
Following is the output for 'perl -V':
# perl -V
Summary of my perl5 (5.0 patchlevel 5 subversion 3) configuration
-Original Message-
From: Christine Kluka [mailto:[EMAIL PROTECTED]]
Sent: Saturday, June 23, 2001 1:29 AM
To: Rudy Lippan
Cc: Ronald J Kimball; Chase Michael A.; Neil Lunn; [EMAIL PROTECTED]
Subject: Re: DBI Connect Failure
Rudy,
I'm studying the DBI module to get smarter on this. I
-Original Message-
From: Chad [mailto:[EMAIL PROTECTED]]
Sent: Monday, June 25, 2001 8:47 AM
To: [EMAIL PROTECTED]
Subject: CachedKids Attribute need help understanding
I've just started implementing prepare_cached into my scripts
and my code is
similar to the example in the book
-Original Message-
From: Christine Kluka [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, June 20, 2001 8:25 PM
To: Ronald J Kimball
Cc: [EMAIL PROTECTED]
Subject: Re: DBI Connect Failure
Ronald,
Thanks for your reply. I:
- declared $i=0; -- it still fails to import
That means this:
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, June 13, 2001 6:29 PM
To: [EMAIL PROTECTED]
Subject: Strange Warning
Hi,
I get a strange warning in the following part of my code:
my @zeile;
while (@zeile = $sth-fetchrow_array()) {
print
Contact ActiveState. But I would suggest ppm verify --upgrade DBI should
work.
--Neil
-Original Message-
From: John [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, June 13, 2001 8:35 PM
To: [EMAIL PROTECTED]
Subject: DBI and Perl 5.6.1.62x Application Error
Suddenly Perl doesn't work with
Check your Informix licencing requirements and dependancies for ESQL/C for
more information on this. You are also subject to the same criteria for Perl
and other modules as stated in the Perl Artistic licence and/or other
licence statements submitted with those modules.
--Neil
-Original
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
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
-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
-Original Message-
From: Guangzu Wang (Houston) [mailto:[EMAIL PROTECTED]]
Sent: Monday, June 04, 2001 3:57 AM
To: [EMAIL PROTECTED]
Subject: Only return the FIRST field from DBD/ODBC/Sql Server stored
proce dure
I use DBD::ODBC with Easysoft ODBC bridge to connect SQL
server
-Original Message-
From: Sterin, Ilya [mailto:[EMAIL PROTECTED]]
Sent: Monday, June 04, 2001 1:02 PM
To: Neil Lunn; 'Guangzu Wang (Houston)'; [EMAIL PROTECTED]
Subject: RE: Only return the FIRST field from DBD/ODBC/Sql
Server stored
proce dure
@list = $sth-fetchrow_array
Unless fetchrow_array is in a loop that would imply to me that there are
more results to fetch. If it is in a loop, is it possible there is a loop
exit before all results are fetched?
-- Neil
-Original Message-
From: Hèctor Alòs i Font [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May
Well you did't say what the error was. Try this and at least you should get
an error that tells you something about why connect is failing.
use DBI; my $dsn = 'DBI:mysql:my_database:localhost';
my $db_user_name = 'admin';
my $db_password = 'secret';
my $dbh = DBI-connect($dsn, $db_user_name,
-Original Message-
From: Richard Castrios [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 15, 2001 3:14 AM
To: '[EMAIL PROTECTED]'
Cc: '[EMAIL PROTECTED]'
Subject: Problems installing DBI on HP-UX 11.0 w/Perl 5.6.1
Hello,
I am getting the following error message when trying
-Original Message-
From: Jack McKinney [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 11, 2001 12:27 AM
To: '[EMAIL PROTECTED] '
Subject: Re: ODBC connects, but queries fail.
Big Brother tells me that Sterin, Ilya wrote:
$driver = driver={Microsoft Access Driver
-Original Message-
From: Jack McKinney [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 11, 2001 1:24 PM
To: [EMAIL PROTECTED]
Subject: Re: ODBC connects, but queries fail.
Big Brother tells me that Sterin, Ilya wrote:
DBI-connect(Driver=/usr/local/lib/odbc-i02.so;Se...
: Neil Lunn [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 11, 2001 2:58 PM
To: [EMAIL PROTECTED]
Subject: RE: ODBC connects, but queries fail.
-Original Message-
From: Jack McKinney [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 11, 2001 1:24 PM
To: [EMAIL PROTECTED]
Subject: Re
You do not actually use Apache::DBI in your script. Please Read the
documentation.
-Original Message-
From: Mikael Hansen [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 09, 2001 4:38 PM
To: Perl DBI users
Subject: Problem with require_version via package DBI
Hi I have a small
-Original Message-
From: Tim Bunce [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 10, 2001 7:07 AM
To: Sterin, Ilya
Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: executing atomic transactions in DBI
but now I've changed it to say:
: If you turn CRaiseError on then
Jack,
Just as an extra check. What do you get if you fully qualify the DSN in the
dbi connect string?
(that is, a DSN'less connection) ie dbi:ODBC:driver= 'etc'
Neil
-Original Message-
From: Jack McKinney [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 10, 2001 6:12 AM
To: [EMAIL
Missed this before. My eyes hurt! Answer Below.
-Original Message-
From: Trevor Webster [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 09, 2001 5:03 PM
To: [EMAIL PROTECTED]
Subject: Problem with DBI and Access newbie
Hello
I am running a Perl script that is supposed to
-Original Message-
From: Sterin, Ilya [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 10, 2001 2:26 PM
To: Neil Lunn; 'Trevor Webster'; [EMAIL PROTECTED]
Subject: RE: Problem with DBI and Access newbie
$SQL = qq|INSERT INTO Respondent (england, relativity,
lotr) VALUES
-Original Message-
From: Sterin, Ilya [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 10, 2001 2:29 PM
To: Neil Lunn; 'Trevor Webster'; [EMAIL PROTECTED]
Subject: RE: Problem with DBI and Access newbie
Neil, not that I'm an Access expert, but I believe (almost
sure
-Original Message-
From: Shah, Deepak K [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 08, 2001 10:32 AM
To: '[EMAIL PROTECTED]'
Subject: database query fails when run with Perl
Hello,
We are running a query against an Oracle database using Perl.
This query has
a
-Original Message-
From: Sterin, Ilya [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 02, 2001 10:56 PM
To: 'Simon Oliver '
Cc: '''[EMAIL PROTECTED]' ' '
Subject: RE: Extract data from MS Excel Spreadsheets. Can it be done?
Also I would think that this is a big enough issue to
Excuse me. But what exactly is your code. I hope your not looping over both
of those lines of code.
-- Neil
-Original Message-
From: jeff knot [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 03, 2001 8:14 AM
To: [EMAIL PROTECTED]
Subject: DBI buffer commit
Hi,
I am new to this
-Original Message-
From: PD Miller [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 30, 2001 6:31 PM
To: Sterin, Ilya; Mike Schienle; [EMAIL PROTECTED]
Subject: RE: Easiest way to tell if a table already exists?
At 21:56 -0400 25/4/01, Sterin, Ilya wrote:
Why would (select * from
Where have you set ODBCHOME to:
-Original Message-
From: Mike McPherson [mailto:[EMAIL PROTECTED]]
Sent: Friday, April 27, 2001 1:03 PM
To: [EMAIL PROTECTED]
Subject: I need a hand
I need a hand cause I can't seam to figure this out.
As much info I can give here:
Red Hat
Mike,
Could you attach the output of perl Makefile.PL and make:
perl Makefile.PL 21 | tee log-conf
make 21 | tee log-make
Neil
-Original Message-
From: Mike McPherson [mailto:[EMAIL PROTECTED]]
Sent: Friday, April 27, 2001 2:38 PM
To: [EMAIL PROTECTED]
Subject: RE: I need a hand
Hmmn. This appears to be normal. The tests are only faling on data_sources
and ping methods so
the driver should be able to be used otherwise.
Perhaps this needs someone to look at iODBC, or a different approach to the
implementation in DBD::ODBC. Not really for this discussion. Simply note
that
-Original Message-
From: Thomas von Elling Skifter Eibner [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 25, 2001 7:27 AM
To: Mark Riehl
The New Riders MySQL book has the following statements:
SELECT COUNT(*) FROM table_name
SELECT * FROM table_name WHERE 1=0
Each
-Original Message-
From: Sterin, Ilya [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 18, 2001 2:56 AM
To: 'Kutler, Christopher '; ''DBI User Group' '
Subject: RE: Complex SQL statments - Do they work?
You sure that's an ANSI SQL statement. Looks like a
procedure. I am not
Roberto,
It was my message. Like I said many hands on much work.
If you deparately need conenctivity to Progress at least for development
work you may want to look at:
http://www.openlinksw.com
There are some pretty flexible ODBC connection options for just about any
platform.
-Original
-Original Message-
From: Tim Bunce [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 04, 2001 6:17 PM
To: Tim Bunce; Jonathan Leffler; dbi-users
Subject: Re: DBI 1.15 - regressed DBD::ADO driver?
I'd be very happy for DBD::ADO to be released to CPAN (DBI::Shell and
the proxy
-Original Message-
From: Sean Carte [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 04, 2001 7:27 PM
To: [EMAIL PROTECTED]
Subject: Storing and Retrieving Arrays
You're right. You have misunderstood the concept
I've asked for help on this topic before, but received no
the project fell through I never pursued it. Anyhow I did
this through
freetds (and I remember reading a lot about sybase at the time for
some reason):
TDS has nothing to do with MS Access.
__
Please Note :
Only
You should only need the client libraries for the machine you are on.
-Original Message-
From: Joe Grastara [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 28, 2001 9:59 AM
To: [EMAIL PROTECTED]
Subject: Installing DBD::MySql without MySql installed
Hi,
I would like to install the
Phil,
Because I and others use DBD::ODBC with other drivers. I have no such
problem. That is why I ask the question.
-Original Message-
From: Phil R Lawrence [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 27, 2001 5:53 PM
To: Neil Lunn; [EMAIL PROTECTED]
Subject: Re: ODBC Error
I already knew how to do this using fetchall_arrayref, but I don't
believe there is any documentation on how to do this one fell swoop:
return $sth-fetchall_arrayref($slice);
Which is documented eg. fetchall_arrayref({}).
the selectall functions and the like are only utility methods
66 matches
Mail list logo